Live classes start in 17d 21h 53m — Save your seat

News & Opinion

Classing Up SSMS is as Easy as 1, 2, 3.

Step 1: go into Tools, Options and set this:

Step 2, set this:

Step 3, check this box:

And presto, no one will ever again question whether or not you know what you’re doing.

Free, 3× a week

Get my new posts by email

Three posts a week, plus a Monday roundup of the best database news from around the web.

25 comments

  1. And you can even goof around with the batch separator and make it fun(nier). For this to work, go to the same Tools, Options and then to Query Execution, SQL Server, General and change to Batch Separator. And here’s how it can look like:

    select * from sys.databases
    Run_Forest

  2. Going to use SSMS to generate all my formal dinner party invites now 🙂

  3. “And presto, no one will ever again question whether or not you know what you’re doing.”
    I think if I saw a DBA switch SSMS to the font Brent chose I would question Everything he or she is doing! :p
    Kidding of course.
    Stay classy San Diego!

      1. HAH! Well played. What’s that expression…better to have people wonder if you know than to open your mouth and remove all doubt 🙂

  4. Wow, I did not know about the beep option… Makes me wonder what kind of nonsense you can do in SQL server/SSMS… Can we start making games with sound effects? Pew Pew your queries are done

  5. OMFG I never noticed this before in the Options!! Mostly because I didn’t care about much in there outside of Text Editor and Query Results settings…

  6. And presto, no one will ever again question whether or not you know what you’re doing.????

  7. This could be a winner in the category of “things to do when your colleague forgets to lock their screen”

  8. As Easy as 1,2,3…

    Question: is that a play on spreadsheet names from the late ’80s?

    At a time when the go-to Spreadsheet was “Lotus 123” and completely unaffordable for us students, there was a share-ware spreadsheet called “As Easy As” which we all used.

    So was the title of this article intentional or not?

  9. Real professionals are using Wingdings as default font.

    And don’t forget to use bright green font color on a pink background color (one of my previous (femal) coworkers did this, so I can assure, that it works – nobody stared at her screen – don’t know if she is color blind)

  10. Made me spit my coffee! Had a coworker when I was a newbie DBA, managed to get to my local SQL Server a few days before he quit, put a .wav file of a cricket singing, set up an agent job to run it everyday at a specific time…..that was pretty awesom!

Leave a comment

Your email address will not be published. Required fields are marked *

Email me about new comments: