Category Archives: Settings

  1. Running code on the startup of SQL Server

    1

    February 1, 2016 by Kenneth Fisher

    Every now and again you need to run code when your instance starts up. For example you might want to …
    Continue reading

  2. SSMS Setup

    7

    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

  3. Generating scripts for previous versions of SQL

    1

    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

  4. What is the database property “Compatibility Level”

    3

    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

  5. Adding a new keyboard shortcut in SSMS.

    5

    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

  6. Yet one more quick and easy performance tuning setting

    1

    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

  7. Multiple Windows Groups with different default databases

    2

    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

  8. Default database

    1

    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

  9. 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

  10. Why not NOLOCK?

    5

    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

Follow

Get every new post delivered to your Inbox.

Join 847 other followers