How to move Cluster Quorum Drive
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...
2011-07-25
2,478 reads
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...
2011-07-25
2,478 reads
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the...
2011-07-14
747 reads
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
955 reads
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,568 reads
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,368 reads
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until...
2011-07-06
1,316 reads
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is...
2011-06-14
699 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers