Tag 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. Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

    4

    December 17, 2018 by Kenneth Fisher

    Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error …
    Continue reading

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

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

  7. SSMS’s Dark Theme

    5

    April 4, 2018 by Kenneth Fisher

    There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
    Continue reading

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

  9. Turning ANSI_PADDING off, and why you shouldn’t

    4

    June 15, 2017 by Kenneth Fisher

    I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
    Continue reading

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

Join 2,513 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013