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

    Keep It Simple Stupid

    July 24, 2019

    Expanding My Reach

    February 7, 2018

    Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4

    September 10, 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

    Admit You Can’t Do Everything

    September 28, 2015

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

    September 17, 2025

    In Memory Table Indexes

    January 22, 2020
  • 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

    Synchronous VS Asynchronous Statistics Updates

    October 25, 2017

    Introduction to the performance features on SQL Server on Linux

    December 4, 2019

    So How Did It Go?

    September 28, 2015
  • 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

    Synchronous VS Asynchronous Statistics Updates

    October 25, 2017

    System-Versioned Temporal Tables

    August 30, 2017

    Query Predicates in SQL Server

    May 24, 2018
  • 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

    Approximate COUNT DISTINCT

    January 3, 2019

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

    November 4, 2025
  • 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

    Invest in Yourself Stop Making Excuses

    October 22, 2019

    Install ALL Things SQL Server… What?

    November 26, 2019

    What does this little check box do? Query Governor SQL Database Setting

    September 13, 2017
  • 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

    How Your Hypervisor Can Impact Your CPU

    March 6, 2019

    SQL Server Data Collection and Management Data Warehouse

    October 3, 2018

    Bloggers Should Have Reach

    February 14, 2018
  • 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

    Replication Max Text Length

    June 20, 2018

    SQL Server Updates Tricked Me for Years

    February 21, 2018

    Back to Basics: Why not parameterize?

    December 23, 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

    Why I Go to Summit Each Year?

    October 11, 2017

    Attending Summit as a New Leader

    November 6, 2015

    Importance of Statistics in SQL Server

    May 30, 2018
  • 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

    Quick Model Database Tidbit

    October 30, 2017

    T-SQL Tuesday #84 – Helping New Speakers

    November 8, 2016

    Attending Summit as a New Leader

    November 6, 2015
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

  • Resizing Tempdb (When TEMPDB Wont Shrink)
    Resizing Tempdb (When TEMPDB Wont Shrink)
  • What’s a Key Lookup?
    What’s a Key Lookup?
  • It's All in the Name, Index Naming Conventions
    It's All in the Name, Index Naming Conventions
  • Tempdb Performance Improvements in SQL Server 2022 are Dramatic
    Tempdb Performance Improvements in SQL Server 2022 are Dramatic
  • Memory Optimized Tables in SQL Server
    Memory Optimized Tables in SQL Server
  • How to get started with Always Encrypted for Beginners Part 1
    How to get started with Always Encrypted for Beginners Part 1
  • The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
    The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
  • Understanding Columnstore Indexes in SQL Server Part 2
    Understanding Columnstore Indexes in SQL Server Part 2
  • The Case for Scooby-Dooing: Solving SQL Server Mysteries Like a Pro– Scooby Dooing Episode 8
    The Case for Scooby-Dooing: Solving SQL Server Mysteries Like a Pro– Scooby Dooing Episode 8
  • Please Don’t Do This! Default Index Fill Factor
    Please Don’t Do This! Default Index Fill Factor
Graceful Pro Theme by Optima Themes - 2026 ©
 

Loading Comments...