Category Archives: Settings

  1. SSMS Setup


    November 16, 2015 by Kenneth Fisher

    Every time I install a new version of SSMS I make a handful of changes to the default setup. For …
    Continue reading

  2. Generating scripts for previous versions of SQL


    October 21, 2015 by Kenneth Fisher

    I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
    Continue reading

  3. What is the database property “Compatibility Level”


    July 8, 2015 by Kenneth Fisher

    What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in …
    Continue reading

  4. Adding a new keyboard shortcut in SSMS.


    July 6, 2015 by Kenneth Fisher

    I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. …
    Continue reading

  5. Yet one more quick and easy performance tuning setting


    June 1, 2015 by Kenneth Fisher

    I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS …
    Continue reading

  6. Multiple Windows Groups with different default databases


    May 28, 2015 by Kenneth Fisher

    A question came up at work the other day, mostly as a mind game, but you never know it might …
    Continue reading

  7. Default database


    May 26, 2015 by Kenneth Fisher

    What? The default database is one of the options when creating a login in SQL Server. This is the initial …
    Continue reading

  8. Port numbers and SQL Server

    Leave a comment

    March 30, 2015 by Kenneth Fisher

    I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
    Continue reading

  9. Why not NOLOCK?


    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  10. Database default locations


    September 29, 2014 by Kenneth Fisher

    One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
    Continue reading


Get every new post delivered to your Inbox.

Join 831 other followers