-
Speaking at Dallas TechFest
I will be presenting two sessions at Dallas TechFest! I am honored and excited to be speaking. Dallas TechFest is a premiere technology conference that includes many technology… Continue Reading
-
Disadvantages of using CMS
There are two drawbacks to how CMS works. The first one I have already written about, so I won’t cover that in this post. You can read about… Continue Reading
-
Advantages of using CMS
The most obvious advantage of a CMS is that it holds an inventory of all the SQL servers in our environment. We can now connect to a single place… Continue Reading
-
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple thing to do, but you can’t redirect the MSDTC resource… Continue Reading
-
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 thing to do, but some of the options… Continue Reading
-
SQLAgent Error 435
Do you get error 435 in the Application event log and your SQLAgent fails to start? The reason you’re getting this error is that the SQLAgent error log and working… Continue Reading
-
Why My Policy will not Evaluate System DBs
Do you have a policy that is supposed to include “Every Database” as part of its condition, but for some reason it never includes the system databases? The “Every”… Continue Reading
-
How to move the TempDB Database
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the physical file on the file system. First we… Continue Reading
-
How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make sure to keep the same name. Technically we don’t… Continue Reading
-
How to move the Model Database
First we need to know the name and file location of the Model database files. When you change the location, make sure to keep the same name. Technically we don’t… Continue Reading
-
How to move the Master database
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the Resource database must reside in the same location… Continue Reading
-
How to add your CMS server to a group
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until SQLSaturday in Houston, where John Sterrett (Blog|Twitter) pointed… Continue Reading
