Tag Archives: SSMS

  1. Default Instance Reports – Configuration Changes History

    Leave a comment

    July 17, 2017 by Kenneth Fisher

    Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
    Continue reading

  2. Default reports in SSMS

    1

    July 13, 2017 by Kenneth Fisher

    As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are …
    Continue reading

  3. SSMS Tips: Copy Full Path

    Leave a comment

    April 24, 2017 by Kenneth Fisher

    When you right click on a tab you’ll see a number of different options. You can set up new horizontal …
    Continue reading

  4. Hiding tables in SSMS Object Explorer

    6

    April 3, 2017 by Kenneth Fisher

    Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
    Continue reading

  5. Changing what SSMS opens on startup

    Leave a comment

    February 1, 2017 by Kenneth Fisher

    When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and …
    Continue reading

  6. :OUT :OUT darn results!

    3

    December 19, 2016 by Kenneth Fisher

    Years ago I worked for a company that had a rather cool way of handling requests. When we ran the …
    Continue reading

  7. Using Snippets

    Leave a comment

    October 17, 2016 by Kenneth Fisher

    A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
    Continue reading

  8. Pinned Tabs

    4

    September 27, 2016 by Kenneth Fisher

    It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) …
    Continue reading

  9. Emojis in SQL Server

    13

    September 15, 2016 by Kenneth Fisher

    I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures …
    Continue reading

  10. Perfectly Placed Parentheses

    14

    June 27, 2016 by Kenneth Fisher

    Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,474 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013