Category Archives: SSMS

  1. What is (local)?

    Leave a comment

    April 27, 2020 by Kenneth Fisher

    When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to …
    Continue reading

  2. Change the size of the grid results view in SSMS


    March 4, 2020 by Kenneth Fisher

    After my post last month about configuring your tools I’ve been on a make my life easier kick and one …
    Continue reading

  3. Configure your tools : T-SQL Tuesday #123


    February 11, 2020 by Kenneth Fisher

    Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing …
    Continue reading

  4. What does the User Mapping tab of Login Properties really tell us.


    June 24, 2019 by Kenneth Fisher

    In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, …
    Continue reading

  5. A transport-level error has occurred when sending the request to the server.


    March 27, 2019 by Kenneth Fisher

    Brent recently did a post called In Azure SQL DB, what does “The connection is broken and recovery is not …
    Continue reading

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

  7. Error in SSMS: Attempted to read or write protected memory.


    February 18, 2019 by Kenneth Fisher

    There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked …
    Continue reading

  8. Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.


    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

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

  10. Dealing with multiple AD accounts


    November 19, 2018 by Kenneth Fisher

    To help promote the seperation of duties one of the things my company has done is to divide our permissions …
    Continue reading

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

Join 3,516 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013