Category Archives: Settings

  1. Saving and restoring session options settings

    4

    September 25, 2017 by Kenneth Fisher

    There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. …
    Continue reading

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

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

  4. My SQL logins don’t work. Again.

    Leave a comment

    January 25, 2017 by Kenneth Fisher

    My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
    Continue reading

  5. Why won’t my SQL Logins work?

    10

    January 12, 2017 by Kenneth Fisher

    I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
    Continue reading

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

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

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

  9. What is the database property “Compatibility Level”

    7

    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

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

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

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013