Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...
2018-03-29
514 reads
Have you ever had an issue where TempDB was filling up on your secondary replicas? Do those secondaries happen to...
2018-03-28 (first published: 2018-03-21)
3,901 reads
So for this month’s TSQL Tuesday, Adam Mechanic has asked us to take a look into the future and think...
2018-03-13
438 reads
The other day I got thinking about what would happen if all databases on a single instance grew out, every...
2018-03-12
261 reads
Here’s a quick one for you. If you happen to be managing SQL Servers with a large number of databases...
2018-03-07
340 reads
Here’s a strange one that I’ve recently come across. I had a customer report that their log shipping restore jobs...
2018-02-22
737 reads
Here is a quick guide to getting started with the SQLUndercover Inspector.
Pre-requisites:
SQL 2012 or higherSQL Server AgentA database to store...
2018-02-19
367 reads
So this month’s T-SQL Tuesday invitation comes from Aaron Bertrand. It’s a non-technical post this month as he asks us...
2018-02-13
810 reads
The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here:...
2018-02-11
1,028 reads
sp_AGReconfigure 1.1 is now available HERE and on GitHub
V1.1 includes a new Parameter and some minor bug fixes:
@Readable
NULL – DEFAULT: ...
2018-02-08
380 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers