Category Archives: Connection Strings

  1. A quick and dirty scan of a list of instances using a dynamic linked server.

    5

    November 12, 2020 by Kenneth Fisher

    Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently …
    Continue reading

  2. How do I test if a linked server works using T-SQL?

    4

    October 27, 2020 by Kenneth Fisher

    I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
    Continue reading

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

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

    4

    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

  5. UDL files and connection strings

    Leave a comment

    December 5, 2018 by Kenneth Fisher

    A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and …
    Continue reading

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

Join 3,538 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013