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
  • Performance Tuning

    Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox

    July 7, 2021 /

    A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU is high for instance this can be a real quick life saver. At times, for me, those two options do not return enough information for what I’m looking for which is the associated stored procedure or object. Using this little helper along with the session id can easily get you that information. Let’s take a look. First, I will create a simple procedure to generate a workload. CREATE OR ALTER PROCEDURE KeepRunning AS DECLARE @i INT=1 WHILE (@i <1000) BEGIN select…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Everything is coming up ACE’s

    October 28, 2015

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

    November 11, 2026

    5 Ways to Examine Cardinality Metrics

    May 2, 2018
  • Azure,  Performance Tuning

    Using Readable Secondary in Azure SQLDB

    June 30, 2021 /

    When using a Geo Replicated Azure SQL Database Readable Secondary  there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed: MVP Edition as we discuss what you need to keep in mind with Microsoft’s Anna Hoffman, @AnalyticAnna.    

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Live, Learn, and Grow

    April 25, 2018

    The Gang vs. Jason: Unmasking JSON’s Secrets in SQL Server 2025- Scooby Dooing Episode 7

    October 1, 2025

    Back up Encryption for SQL Server

    September 5, 2018
  • SQL Family

    Data Saturdays Logo Contest

    March 23, 2021 /

    Lots of exciting things are happening with Data Saturdays and we want you, the #SQLFamily, involved. Last week, Rob Sewell (B|T) announced the new automation and setup process for events.  This week I am announcing a new logo and branding initiative. With the generous donation from Denny Cherry and Associates Consulting, DCAC, we have commissioned 99Designs artists to create a new logo for branding. The Data Saturdays Admins reviewed over 220 submissions these were considered the likeability, accessibility, inclusiveness, and ease of multi-use. We have narrowed down the choices to these four.  Please take a moment to click the link below and rate your favorite, we will use your influence…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Ooops! Was that me? (Blog Challenge)

    January 10, 2017

    Back to Basics: Why not parameterize?

    December 23, 2015

    My Thoughts on PASS Virtual Summit – An Editorial

    June 11, 2020
  • DevOps

    How SQL Server Synonyms Help Database DevOps

    March 10, 2021 /

    Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another database object such as a view, user defined table, scalar function, stored procedure, inline table valued function (tvf), or extended stored procedure. They can also be used for CLR Assembly related stored procedures, CLR tvf, CLR scalar functions or even CLR aggregate functions.  There are many practical uses for synonyms, and I’ll explain how to create them and some use cases. Read the full article here at Red-Gate’s Simple Talk

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

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

    September 24, 2025

    Please Don’t Do This! Default Index Fill Factor

    September 6, 2017

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

    August 28, 2025
  • Performance Tuning

    Identifying SQL Server Performance Problems Part 3

    February 24, 2021 /

    Continuing with our Performance Tuning series as you have learned baselining and knowing your normal system performance metrics is an important part of performance tuning. In part 1 we discussed collecting vital system metrics such as CPU Utilization and Memory usage. In part 2 we took a glimpse into how we can gather those metrics and other using the different tools that are available to use like Performance Monitor, Profiler, Extended Events and DMVs. In this part 3 we will look at how identifying the appropriate waits events and corresponding resolution will be critical for resolving performance issues. But first you need to understand what waits are and where to find…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Expanding My Reach

    February 7, 2018

    The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

    September 17, 2025

    Hide and Group Columns in SSRS Using a Parameter

    December 9, 2016
  • Performance Tuning

    SQL Index Creation Using DROP EXISTING= ON

    February 17, 2021 /

    When you are making changes to an existing Non-Clustered index SQL Server provides a wide variety of options. One of the more frequently used methods is DROP EXISTING; in this post you will learn all about that option. This option automatically drops an existing index after recreating it, without the index being explicitly dropped. Let us take a moment understand the behavior of this choice. DROP EXSITING=ON which is my preferred method, will DROP the current index only after it finishes creating and building the index with the new definition. The pitfall is that if the index does not exist, you will get an error and must create it without the…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Live, Learn, and Grow

    April 25, 2018

    Memory Optimized Tables in SQL Server

    January 8, 2020

    Caution When Dropping Unused Indexes on an Azure SQL Database

    August 12, 2020
  • Back to Basics,  Performance Tuning

    Identifying SQL Server Performance Problems Part 2

    February 10, 2021 /

    Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to gather for baselining your environment. Be sure to read part one first. Performance Monitor First let’s start with what comes native to Windows Server platform, whether you are on an Azure SQL Virtual Machine or your standard SQL Server instance install on premises you have a native tool, called Performance Monitor (affectionately known to most as PerfMon). This reliable tool allows you to easily monitor performance metrics through a Graphical User Interface (GUI), by selecting performance counters for the operating system as well as installed applications such as SQL Server. It…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    So How Did It Go?

    September 28, 2015

    SQL Server Vulnerability Assessment

    December 12, 2018

    Eliminating Unnecessary DELETE Operations

    February 27, 2025
  • Back to Basics

    Mastering TempDB: The Basics

    February 3, 2021 /

    I regularly deliver a presentation called “Mastering TempDB”. I wrote it based on what I wish I knew about TempDB “growing up” in my career as a SQL Server DBA. It really is a breakdown of what TempDB is, how it is used, what problems actually occur within it, and how to best configure it. With advice from my colleagues, I have decided to break that down into this article to educate you. What is TempDB? TempDB is a global resource used by everyone and everything inside SQL Server. Think of it as a dumping ground for anything that doesn’t fit in memory. It is always database_id number two in…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    New Resumable Online Index Create SQL Server 2019

    November 28, 2018

    Can You Hear It Now?

    January 31, 2018

    Respectfully Responding

    June 14, 2018
  • Back to Basics,  Performance Tuning

    Identifying SQL Server Performance Problems Part 1

    January 27, 2021 /

    Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database administrators to properly monitor and fix those performance issues whether it is in your traditional on premises environment or in the cloud. This article will cover ways monitoring performance and how to establish a baseline. We will go over several important performance metrics every database administrator should know and how to gather and interpret those metrics through several different options within SQL Server and your Windows operating system. Now which tool you use to accumulate these metrics depends on what problem you are trying to solve. The…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Trace Flags That Are Now Defaulted Behaviors in SQL Server

    December 18, 2019

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

    November 4, 2025

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

    September 30, 2026
  • Back to Basics

    Storage Tiers What SQL Server DBAs Need to Know

    January 19, 2021 /

    “One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know what type they are and the power that they provide. Storage is not about gerbils it is about IOPs, bandwidth, latency, and tiers. As a DBA it is important for you to understand and know what kind of storage is attached to your servers and how it is handling your data. It is not important to master everything about it, but it is very advantageous to be able to talk to your storage admins or “Gerbil CoLo, LLC” provider intelligently especially…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    How to get started with Always Encrypted for Beginners Part 1

    November 29, 2017

    Does Your Code Have a Preamble?

    October 18, 2017

    Please Don’t Do This! Default Index Fill Factor

    September 6, 2017
12345

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
  • Understanding Columnstore Indexes in SQL Server Part 1
    Understanding Columnstore Indexes in SQL Server Part 1
  • 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
Graceful Pro Theme by Optima Themes - 2026 ©
Loading Comments...