Monthly Archives: March 2019
-
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 -
What version of SQL is SSMS scripting for?
Leave a commentMarch 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 -
Mixed feelings over the new truncation error
2March 20, 2019 by Kenneth Fisher
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. …
Continue reading -
Hugo’s SQL Server Execution Plan Reference
1March 18, 2019 by Kenneth Fisher
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and …
Continue reading -
Querying temp tables across a linked server.
2March 14, 2019 by Kenneth Fisher
And if you are still reading you probably fit into one of the following categories. Not a DBA A relatively …
Continue reading -
Dipping into the Cookie Jar: T-SQL Tuesday #112
1March 12, 2019 by Kenneth Fisher
This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies. …
Continue reading -
Disabling and enabling triggers
2March 6, 2019 by Kenneth Fisher
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now …
Continue reading -
SQL Homework – March 2019 – Reconfigure tempdb
Leave a commentMarch 4, 2019 by Kenneth Fisher
You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor …
Continue reading