Tag Archives: Microsoft SQL Server
-
Shrinking a large database with limited outage windows
13April 22, 2019 by Kenneth Fisher
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where …
Continue reading -
How do I let someone execute a SQL Agent job they don’t own?
12April 15, 2019 by Kenneth Fisher
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
Continue reading -
Can SQL Ids be used on an instance with Windows Authentication only?
2April 11, 2019 by Kenneth Fisher
tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
Continue reading -
Writing Crossword puzzles with a database: T-SQL Tuesday #113
2April 9, 2019 by Kenneth Fisher
Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases …
Continue reading -
SQL Homework – April 2019 – Practice dealing with corruption
Leave a commentApril 3, 2019 by Kenneth Fisher
Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of …
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 -
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
SQL Studies 