A Shot of SQLEspresso

SQL Blogs by Monica Morehouse (Rathbun)

  • Home
  • Session Downloads
  • Event Calendar
  • PASS
    • Hampton Roads SQL User Group
    • SQL Saturday
    • PASS WIT VC
  • DCAC
  • Contact Me
    • Disclaimer
  • Home
  • Session Downloads
  • Event Calendar
  • PASS
    • Hampton Roads SQL User Group
    • SQL Saturday
    • PASS WIT VC
  • DCAC
  • Contact Me
    • Disclaimer

No Widgets found in the Sidebar Alt!

SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

read more

Wait… Could This Be the End of Index Maintenance?

read more

SQL Server Is Still Here and Microsoft Is Still Investing in It

read more

Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant

read more

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

read more
Link 1
Azure Cloud Chronicles with Microsoft MVPs
Link 2
Data Exposed YouTube
Link 3
Paul Randals -SQL Server Wait Statistics Library
Link 4
Glenn Berry'd SQL Server Performance DMVs
Link 5
sp_whoisactive Download
  • Azure

    Moving Your SQL Workload to the Cloud   

    March 25, 2020 /

    Every day, more IT organizations decide to move their SQL Server databases to Azure. In fact, over a million on-premises SQL Server databases have been moved to Azure. There’s an interesting blog about how Microsoft is faster and cheaper than its competitors that’s worth a read. To assist with your move to Azure Microsoft offers a number of migration tools and services to make this move as smooth as possible which I think attributes to their success. Two of those options are below with some informational links. If you’re migrating a number of large SQL Server instances, Azure Database Migration Service  is the best way to migrate databases to Azure…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Filtered Index Basics

    May 22, 2019

    Being a Woman in the SQL Community

    February 26, 2020

    The Mystery of the Locked-Up Database -Scooby Dooing Episode 6

    September 24, 2025
  • SQL Family

    Being a Woman in the SQL Community

    February 26, 2020 /

    In celebration of Women’s History Month starting next week, I was asked to write this blog about my experiences as a woman in the SQL Community, and it really got me thinking. At first, I thought I should be very politically correct and only talk about the great stuff and hype up all wonderful experiences I’ve had but then I thought that wouldn’t give a true picture. So, I am writing this as openly and honestly as I can. Here it goes. The Ugly I am going to start with the negatives to get those out of the way and draw attention to things that are still happening not only…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Change Azure SQL Database Service Level Objectives in SSMS

    August 28, 2020

    Live, Learn, and Grow

    April 25, 2018

    SQL Server Updates Tricked Me for Years

    February 21, 2018
  • Speaking

    Upcoming International Speaking Engagements

    February 19, 2020 /

    I am very excited and fortunate to be chosen to speak at both SQLBits and DataGrillen this year. These two conferences are incredible community run events and if you can attend either of them, I would highly recommend it.  Here’s a little bit about each event and information on how you can register. If you can attend be sure to check out my sessions. SQLBits SQLBits the largest SQL Server conference in Europe, being held in London England March 31st– April 4th. It is a conference for leading data professionals with over 200 sessions from speakers all over the world. https://sqlbits.com/ Join Me -Thursday April 2nd 17:10 Room 10 Always…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Quick Model Database Tidbit

    October 30, 2017

    Cycle SQL Server Error Logs

    September 26, 2018

    System-Versioned Temporal Tables

    August 30, 2017
  • Performance Tuning

    String Split Function in SQL Server

    February 12, 2020 /

    Did you know that a native STRING_SPLIT function built into SQL Server was added into SQL Server 2016? As a consultant I see so much code that call out to a scalar function that are used to split out string delimited variables into a usable list. For those that use this method I suggest you look at this function. STRING_SPLIT is a table valued function that returns a single column of your string values split out by the delimiter. This is an unusual bit of T-SQL, in that compatibility level 130 or higher is required for its use (Microsoft didn’t want to induce breaking changes into existing user code). Using…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Free Training 24HOP

    April 18, 2018

    Understanding Columnstore Indexes in SQL Server Part 1

    June 26, 2019

    Master of None

    October 8, 2015
  • Performance Tuning

    Sorting in Stored Procedures – Food for Thought

    January 29, 2020 /

    We know that sorting can be one of the most expensive things in an execution plan as shown below. However,  we continue to do ORDER BYs repeatedly. Yes, I 100% agree that there is a need to sort a results set and that this should be done in the procedure for good reason, but my concern is having  multiple sorts, erroneous sorts, and the sorts that can be done elsewhere. These are the ones that waste resources and can stifle performance. Many of us writing procedures tend to write in code blocks. We write the SELECT, JOINS, FROMs and WHERES then immediately follow it up with and ORDER BY as…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    What is Automatic Tuning in Azure SQL Database

    August 28, 2018

    SQL Server Updates Tricked Me for Years

    February 21, 2018

    Are My SQL Server Indexes Being Used?

    August 28, 2019
  • Performance Tuning

    In Memory Table Indexes

    January 22, 2020 /

    Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s look at indexes and how they are created and how they work within those tables. As you can imagine indexes, called memory optimized indexes are different for these types of tables, so let’s see just how different that are from regular tables. Before we dive into this subject it is VERY important to note the biggest differences. First,  If you are running SQL Server 2014 memory optimized indexes MUST be created when the table is created or migrated. You cannot add indexes in an existing table without dropping and recreating the table. After 2016 you now…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Importance of Statistics in SQL Server

    May 30, 2018

    This Idera ACE Has Been Busy

    August 23, 2016

    SQL Server Vulnerability Assessment

    December 12, 2018
  • Performance Tuning

    Memory Optimizer Advisor

    January 15, 2020 /

    Previously I wrote about In-Memory Optimized Tables, in this blog I am going to discuss how to determine which tables could benefit from being In-Memory by using a tool called Memory Optimization Advisor (MOA). This a is a tool built into SQL Server Management Studio (SSMS) that will inform you of which tables could benefit  using In Memory OLTP capabilities and which may have non supported features. Once identified, MOA will help you to actually migrate that table and data to be optimized. Let’s see how it works by walking through it using a table I use for demonstrations in AdventureWorks2016CTP3. Since this is a smaller table and doesn’t incur…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Back to Basics: Why not parameterize?

    December 23, 2015

    Quick Tip: Remove CONVERT\CAST from your WHERE\JOIN clauses

    March 28, 2022

    So How Did It Go?

    September 28, 2015
  • Performance Tuning

    Memory Optimized Tables in SQL Server

    January 8, 2020 /

    Sometimes when I try to learn about a concept my brain blocks out everything about it. Talking about anything that uses the “In Memory” concept tends to do this to me on occasion. It’s important to note that “In Memory” is a marketing term for a series of features in SQL Server that have common behaviors but are not inherently related. So, in my next few blogs I am going to attempt to explain some In-Memory concepts as it relates to SQL Server starting with a dive into Memory Optimized Tables. I’ve already written about Columnstore which has vastly different use cases to In Memory OLTP, and you can find…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Comparing Execution Plans

    June 19, 2019

    Bloggers Should Have Reach

    February 14, 2018

    Does Your Code Have a Preamble?

    October 18, 2017
  • Performance Tuning

    Trace Flags That Are Now Defaulted Behaviors in SQL Server

    December 18, 2019 /

    If you have ever attended one of my performance tuning sessions, you know I tend to talk about  trace flags.  Trace Flags can help fix performance issues and some are now defaulted in later SQL Server versions. In my opinion, when a trace flag’s behavior defaulted in a version, then you should potentially put them in place within environments that do not have them implemented. Below, are a few of these particular traces flag along with Microsoft’s definition of what each trace flag does, taken straight from MS documents.  I have also included a brief commentary on each one.  As with any change, you should be sure to thoroughly test…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Ruh-Roh! SQL Server 2025 Finally Brings Us a Free Standard Developer Edition – Scooby Dooing Episode 2

    August 28, 2025

    Cycle SQL Server Error Logs

    September 26, 2018

    Free Training 24HOP

    April 18, 2018
  • Performance Tuning

    Introduction to the performance features on SQL Server on Linux

    December 4, 2019 /

    I’ve been tinkering with SQL Server on Linux lately and noted a few things in regards to performance I thought I would share with you. SQL Server 2019 on Linux uses the same SQL Server database engine with many of the performance features and services you would find on Windows. There are more similarities than you would initially think. However, if you’re a Linux user who is new to SQL Server, I thought the following introduction to some performance features on SQL Server 2019 on Linux will be helpful. Columnstore index As I’ve written about before in my 3-part blog series that you can find here, a columnstore index allows…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    5 Ways to Examine Cardinality Metrics

    May 2, 2018

    SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

    November 11, 2026

    So How Did It Go?

    September 28, 2015
34567

About Me

Monica Morehouse (Rathbun)

Microsoft MVP, Performancing Tuning Expert, Leader Hampton Roads SQL Server User Group, Read More…

Consulting

Sessions List

Favorite Tidbits

  • Reminder to Developers

Topic Categories

  • Azure
  • Back to Basics
  • Configurations
  • Data Masking
  • DevOps
  • Encryption
  • Idera Ace
  • Important Links
  • Indexes
  • Lone DBA
  • Misc
  • MVP
  • New SQL Version
  • Performance Tuning
  • Posts with Scripts
  • Problems & Solutions
  • Quick and Dirty
  • Security
  • Speaking
  • SQL Family
  • SQLSaturday
  • SSRS
  • Summit
  • Training
  • TSQL Tuesday
  • Uncategorized

Top Posts & Pages

  • Understanding Columnstore Indexes in SQL Server Part 2
    Understanding Columnstore Indexes in SQL Server Part 2
  • Wait… Could This Be the End of Index Maintenance?
    Wait… Could This Be the End of Index Maintenance?
  • Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox
    Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox
  • Scheduling things to Run in SQL Server
    Scheduling things to Run in SQL Server
  • Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
    Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
  • SQL Server Statistics Health Reminder
    SQL Server Statistics Health Reminder
  • Simple-Talk Article...Understanding Azure Storage Options
    Simple-Talk Article...Understanding Azure Storage Options
  • Memory Optimizer Advisor
    Memory Optimizer Advisor
  • Hmmm... What’s This? Date Correlation Optimization in SQL Server
    Hmmm... What’s This? Date Correlation Optimization in SQL Server
  • Adaptive Joins in SQL Server
    Adaptive Joins in SQL Server
Graceful Pro Theme by Optima Themes - 2026 ©
Loading Comments...