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!

  • 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

    Back to Basics: Why not parameterize?

    December 23, 2015

    SQL Data Discovery and Classification in SSMS 17.5

    December 5, 2018

    Why I Go to Summit Each Year?

    October 11, 2017

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

  • DMV’s for the Beginner
    DMV’s for the Beginner
  • TIL: Microsoft Azure Part 1
    TIL: Microsoft Azure Part 1
  • Install ALL Things SQL Server… What?
    Install ALL Things SQL Server… What?
  • What is Batch Mode on Rowstore in SQL Server?
    What is Batch Mode on Rowstore in SQL Server?
  • Hmmm... What’s This? Date Correlation Optimization in SQL Server
    Hmmm... What’s This? Date Correlation Optimization in SQL Server
  • Identifying SQL Server Performance Problems Part 3
    Identifying SQL Server Performance Problems Part 3
  • It's All in the Name, Index Naming Conventions
    It's All in the Name, Index Naming Conventions
  • Replication Max Text Length
    Replication Max Text Length
  • How Much Will Compression Really Gain Me in SQL Server?
    How Much Will Compression Really Gain Me in SQL Server?
  • Understanding Columnstore Indexes in SQL Server Part 1
    Understanding Columnstore Indexes in SQL Server Part 1
Graceful Pro Theme by Optima Themes - 2026 ©
 

Loading Comments...