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!

  • SQL Family

    My Thoughts on PASS Virtual Summit – An Editorial

    June 11, 2020 /

    On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server community. Many events are moving to a virtual platform as well as being able to offer them at no costs to all attendees. PASS though, is a different kind of “company” for lack of a better word. We are a community of people that built this “company” from the ground up. Due to normal day to day commitments, like jobs, most of us do not have time to run the day to day operations of the “company” and we rely on…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    5 Ways to Examine Cardinality Metrics

    May 2, 2018

    So let’s talk naming conventions

    September 15, 2015

    Change Azure SQL Database Service Level Objectives in SSMS

    August 28, 2020
  • 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

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

    September 24, 2025

    The Case for Scooby-Dooing: Solving SQL Server Mysteries Like a Pro– Scooby Dooing Episode 8

    October 8, 2025

    How to get started with Always Encrypted for Beginners Part 3: One Two Punch

    January 17, 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

    Eliminating Unnecessary DELETE Operations

    February 27, 2025

    Respectfully Responding

    June 14, 2018

    The New Public Speaking

    April 29, 2020
  • Performance Tuning

    Join me for a PASS Summit Pre-Con

    April 24, 2019 /

    I am very excited to announce I will be delivering a pre-conference session on SQL Server Performance Tuning on November 5th at PASS Summit 2019. If you have ever attended one of my sessions, you know how passionate I am about this particular topic. So, you also know how very excited I am to have this opportunity to spend a full day talking about SQL Server Performance Tuning and Optimization. Performance Tuning is one of my favorite things to do with SQL Server. There is nothing like seeing performance improvements in an environment as your reward for your hard work. It’s tangible and gratifying. In this session you will be…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    So let’s talk naming conventions

    September 15, 2015

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

    October 1, 2025

    Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox

    July 14, 2021
  • SQL Family,  SQLSaturday,  Summit

    Why I Go to Summit Each Year?

    October 11, 2017 /

    This year will be my 6th PASS Summit that I will have attended. Some people have asked me why I still go, and what I get out of Summit that I don’t get from attending and speaking at SQL Saturdays. That’s an easy one for me to answer, but a long answer at that. Networking First and foremost, it’s for the networking. Getting to meetup with so many other like minded people is gratifying. This networking allows you to exchange ideas, war stories, and downright geek out with others that know what you are talking about and don’t have their eyes glaze over when discussing optimizer internals. On top of…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Attending Summit as a New Leader

    November 6, 2015

    Comparing Execution Plans

    June 19, 2019

    Admit You Can’t Do Everything

    September 28, 2015
  • Summit

    Summit Submission Feedback Response

    June 28, 2016 /

    I’m It Survival Tips for the Lone DBA – Level 100 (Not Accepted: Higher rated session selected) Track: Professional Development As others have done I also will share my feedback from my submission to speak at PASS Summit in hopes it will lend some more insight into the process. Abstract: Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    What is Automatic Tuning in Azure SQL Database

    August 28, 2018

    Quick Model Database Tidbit

    October 30, 2017

    Scooby-Doo and the Mystery of Cloud Costs (Let’s have some fun!) – Scooby Dooing Episode 1

    August 25, 2025
  • Back to Basics,  Posts with Scripts,  Quick and Dirty

    Back to Basics: Why not parameterize?

    December 23, 2015 /

    I think sometimes those of us that have been doing database administration/development for a while take it for granted that everyone knows the basics. One such basic is parameterizing stored procedures. This allows us to potentially consolidate multiple stored procedures into a single procedure.  It’s as simple thing to do that many don’t. I try to parameterize as many stored procedures as possible. This not only minimizes the amount of procedures I need to maintain, it in my opinion is a much cleaner way to code. It disturbs me when I see multiple stored procedures that pull the exact same data, but may have slight differences between them. Whether it…

    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

    Comparing Execution Plans

    June 19, 2019
  • Summit

    Attending Summit as a New Leader

    November 6, 2015 /

    It’s that time again where everyone writes their post PASS Summit Blog and tells of the great time they had with SQL Family and all the exciting new things they learned.  While those are both very true for me as well, I want to talk about how it felt to go to Summit as a new leader in the community. This year I became a Chapter Leader and spent Tuesday at Summit in the PASS Chapter Leader and SQL Saturday meetings. It was an honor for me to walk into those meetings and collaborate with such a phenomenal group of people.  It was even more remarkable to be called out…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Memory Optimized Tables in SQL Server

    January 8, 2020

    What SQL Server Performance & Management Tools Do I Use?

    September 4, 2019

    November #SQLChat – How to Build your Name Recognition and SQL Network

    November 12, 2015
  • Uncategorized

    So How Did It Go?

    September 28, 2015 /

    My first time speaking at a SQL Saturday is now behind me.  I cannot wait to do it again. The support from the SQL Family leading up to and after the event was nothing I expected, it was beyond AMAZING. From high fives in the halls to virtual hugs. I had my own cheering section. I was a little nervous and talked probably too fast at times, I am sure, but I hear everyone does on their first time out, right? (Evidently, I say that a lot) The good part was that the audience looked to be truly engaged and listening to what I had to say. I even had…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox

    July 14, 2021

    Summit Submission Feedback Response

    June 28, 2016

    Ooops! Was that me? (Blog Challenge)

    January 10, 2017
  • Uncategorized

    My First Speaking SQL Saturday

    September 21, 2015 /

    I will be speaking at my first SQL Saturday on September 26th in Spartanburg SC.  I am so excited to have been selected to give my session on Survival Techniques for the Lone DBA.  After a year of, not so subtle hints from the SQL Family (John Morehouse (b|t), Rie Irish (t), Melody Zacharias (b|t), Mike Fal (b|t), Argenis Fernandez (b|t) , Kirsten Benzel (b|t), Andy Yun (b|t), Lindsay Clark (t)), I submitted my first session and got selected.   I will be finally standing up before a room of colleagues and talking about my experience as a lone DBA for the last 15+ years. What did I just do? Unless…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Are My SQL Server Indexes Being Used?

    August 28, 2019

    TIL: Microsoft Azure Part 1

    May 17, 2017

    How to Get Started with Always Encrypted for Beginners Part 2

    December 13, 2017
12

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

  • Ruh-Roh! SQL Server 2025 Finally Brings Us a Free Standard Developer Edition -  Scooby Dooing Episode 2
    Ruh-Roh! SQL Server 2025 Finally Brings Us a Free Standard Developer Edition - Scooby Dooing Episode 2
  • Memory Optimized Tables in SQL Server
    Memory Optimized Tables in SQL Server
  • What’s a Key Lookup?
    What’s a Key Lookup?
  • DMV’s for the Beginner
    DMV’s for the Beginner
  • Resizing Tempdb (When TEMPDB Wont Shrink)
    Resizing Tempdb (When TEMPDB Wont Shrink)
  • Synchronous VS Asynchronous Statistics Updates
    Synchronous VS Asynchronous Statistics Updates
  • Hide and Group Columns in SSRS Using a Parameter
    Hide and Group Columns in SSRS Using a Parameter
  • Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox
    Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox
  • Tempdb Performance Improvements in SQL Server 2022 are Dramatic
    Tempdb Performance Improvements in SQL Server 2022 are Dramatic
  • SQL Server Statistics Health Reminder
    SQL Server Statistics Health Reminder
Graceful Pro Theme by Optima Themes - 2026 ©
 

Loading Comments...