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
  • Back to Basics

    Install ALL Things SQL Server… What?

    November 26, 2019 /

    Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL Server installation process using GUI and checked every option available to them, then just clicked Next, Next, Next and then Install. If this is your environment, please take a moment to evaluate and decide which of these services that are required. From a performance tuning perspective, it is important to only run the services that you need. Each of these services can consume resources on your server. Sharing resources reduces what youe SQL Server Engine, SQL Server (MSSQLSERVER) or named instance…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Static Data Masking (SSMS 18.0 Preview)

    December 19, 2018

    QUICK & DIRTY: Table name change for all stored procedures

    December 10, 2015

    T-SQL Tuesday #84 – Helping New Speakers

    November 8, 2016
  • Azure

    Simple-Talk Article…Understanding Azure Storage Options

    November 20, 2019 /

    Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of being a guest Author and explain Azure storage options. I cover types of storage accounts, supported services, what performance tiers work with each storage account, and what kind of access you have with those storage types. Be sure to check it out. Here’s an excerpt…. Editor’s Intro: The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution. Understanding Azure Storage Options Azure can be a complicated mess of alphabet soup with all the acronyms…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Caution When Dropping Unused Indexes on an Azure SQL Database

    August 12, 2020

    Memory Optimized Tables in SQL Server

    January 8, 2020

    It’s time to speak again!

    December 1, 2015
  • Speaking,  Summit

    I’m Speaking at Pass Summit 2019

    November 1, 2019 /

    I am very excited to be heading to PASS Summit 2019 in Seattle next week. It’s one of my favorite weeks of the year. Getting to hang out with and learn from so many data professions is priceless. I am even more excited this year because I will be giving a Pre Con and a regular session for the first time at Summit. If you have ever attended one of my sessions, you know how passionate I am about speaking and being able to share my knowledge. What is PASS Summit? According to PASS it’s “Interactive training on the latest technologies and spotlights on hot topics such as security, cloud,…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    In Memory Table Indexes

    January 22, 2020

    The New Public Speaking

    April 29, 2020

    SQL Data Discovery and Classification in SSMS 17.5

    December 5, 2018
  • Important Links,  Lone DBA

    Invest in Yourself Stop Making Excuses

    October 22, 2019 /

    Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me and elicited a strong reaction from myself. It got me thinking I need to write a blog on this, so here we go. Many times, over the years I’ve had conversations with people in which they have said things like below. “I can’t learn anything new because my work won’t send me to training” “I can’t learn about xyz because my boss or coworkers won’t sit down with me to show me how” “I don’t have time to learn anything new” “We’ll never go to the cloud, so I don’t need to know that” “I’m too busy…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Please Don’t Do This! Default Index Fill Factor

    September 6, 2017

    So let’s talk naming conventions

    September 15, 2015

    Initial SQL Server Configurations

    October 19, 2015
  • Performance Tuning

    The FAST number_rows Query Hint

    October 16, 2019 /

    Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when returning code results, that you would want to see the data as soon as possible, even before the complete set of data has been returned. Did you know that you can return a subset of rows to look at BEFORE the entire result set is returned? The FAST n query hint allows the optimizer to return a specified number of rows as quickly as possible. Imagine an application result screen where users frequently wait for data to appear. Wouldn’t it make…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    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

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

    October 17, 2025
  • Speaking

    New Event Calendar

    October 15, 2019 /

    Speaking Engagements Check out my new Event Calendar, to see my upcoming and past speaking engagements. You can catch me at various events throughout the year. If you are interested in having me speak at your event reach out via my contact me page.  

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    SQL Data Discovery and Classification in SSMS 17.5

    December 5, 2018

    Invest in Yourself Stop Making Excuses

    October 22, 2019

    It’s time to speak again!

    December 1, 2015
  • Performance Tuning

    SQL Server Statistics Health Reminder

    September 18, 2019 /

    I’ve written about statistics in SQL Server a few times now. Through conversations  I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics up to date is one of the more critical components of SQL Server performance issues. Please be sure you are doing more than just index maintenance to maintain your statistics.  Index maintenance  only maintains statistics created by indexes and single field predicate created table statistics. There are also column statistics that need to be maintained that are created by predicates usage in your queries or even manually created. For each insert, update, or delete the distribution of your data changes and…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Invest in Yourself Stop Making Excuses

    October 22, 2019

    The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3

    September 3, 2025

    Wait… Could This Be the End of Index Maintenance?

    November 5, 2026
  • Back to Basics,  Quick and Dirty

    Quick SSMS Tip

    September 11, 2019 /

    It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid writing it. So, when I find little tips that make coding easier for me, I like to share. Did you know that you can surround your code with a click of a button with IF, BEGIN END, WHILE code blocks? SQL Server Management Studio (SSMS) gives us the basic structure of a Transact-SQL statement code block as a starting point. Take Look In SSMS In a query window, Right Click and Choose Surround With (note the hot keys of Ctrl+K or…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Ooops! Was that me? (Blog Challenge)

    January 10, 2017

    So let’s talk naming conventions

    September 15, 2015

    Caution When Dropping Unused Indexes on an Azure SQL Database

    August 12, 2020
  • Performance Tuning

    What SQL Server Performance & Management Tools Do I Use?

    September 4, 2019 /

    Several times I’ve been asked what tools are in my performance tuning and SQL Server management arsenal, so I decided to just create this blog to list them out for you. Keep in mind, these are ones I personally use. There are many more out there that the community uses. Feel free to comment with any you may use that is not on my list. Community Tools (Free)   Ola Hallengren’s Maintenance Scripts- Index Maintenance, Integrity and Backup Scripts https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html   Glenn Berry’s Diagnostic Scripts -Various scripts based on DMVs to extract SQL Performance statistics and information  https://www.sqlskills.com/blogs/glenn/category/dmv-queries/   Adam Machanic sp_WhoIsActive See what is currently going on in SQL…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    QUICK & DIRTY: Table name change for all stored procedures

    December 10, 2015

    DMV’s for the Beginner

    May 15, 2019

    Synchronous VS Asynchronous Statistics Updates

    October 25, 2017
  • Indexes

    Are My SQL Server Indexes Being Used?

    August 28, 2019 /

    Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as part of your index maintenance procedures that you periodically check to see if your indexes are being used. Many times, indexes are created in the belief they are needed but in fact they are never used. You can reduce that IO overhead on inserts when you remove unnecessary indexes. How Do You Find Them? Glenn Berry (B|T) has a fantastic script as part of his diagnostic scripts (link) that helps identify index utilization. In his diagnostic scripts it is listed as…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    5 Ways to Examine Cardinality Metrics

    May 2, 2018

    QUICK & DIRTY: Table name change for all stored procedures

    December 10, 2015

    Expanding My Reach

    February 7, 2018
45678

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...