Category Archives: Connection Strings
-
A quick and dirty scan of a list of instances using a dynamic linked server.
5November 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 -
How do I test if a linked server works using T-SQL?
4October 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 -
What is (local)?
Leave a commentApril 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 -
A transport-level error has occurred when sending the request to the server.
4March 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 -
UDL files and connection strings
Leave a commentDecember 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
SQL Studies 