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,194 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,194 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
742 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
951 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,457 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,362 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,305 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
696 reads
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Useful tips to make your jobs more stable Too many IT teams treat SQL...
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
We're currently on SQL 2019 and will likely be looking to migrate to a...
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers