Category Archives: Settings

  1. The default filegroup, and why you should care.

    2

    February 19, 2018 by Kenneth Fisher

    You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
    Continue reading

  2. How to: Create an Azure VM with SQL Server using a default template

    1

    December 14, 2017 by Kenneth Fisher

    One of the really cool things about the cloud is how quickly you can spin up a new machine to …
    Continue reading

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

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

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

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

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

  9. SSMS Setup

    8

    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

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

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

Join 2,424 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013