Category Archives: Settings

  1. What version of SQL is SSMS scripting for?

    Leave a comment

    March 25, 2019 by Kenneth Fisher

    Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
    Continue reading

  2. SQL Homework – February 2019 – Instance configurations

    4

    February 4, 2019 by Kenneth Fisher

    This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not …
    Continue reading

  3. SQL Homework – January 2019 – Baselines

    Leave a comment

    January 2, 2019 by Kenneth Fisher

    Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
    Continue reading

  4. SQL Homework – December 2018 – Configure SSMS

    Leave a comment

    December 3, 2018 by Kenneth Fisher

    I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
    Continue reading

  5. Copying formatted text out of a grid column.

    3

    August 27, 2018 by Kenneth Fisher

    I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
    Continue reading

  6. What are my permissions?

    1

    August 16, 2018 by Kenneth Fisher

    Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
    Continue reading

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

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

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

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

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

Join 2,528 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013