Category Archives: Settings

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

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

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

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

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

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

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

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

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

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

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

Join 2,469 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013