Policy Based Management gives us centralized management of our SQL Servers. It allows us to evaluate, configure, and enforce standards across the enterprise. If you […]
Category: SQL Server
Dallas TechFest 2011 Wrap-up
Dallas TechFest was a 2 day event full of great content! I’m a SQL guy and most of the conferences I go to are SQL centric. This event, […]
Beware the CMS Import
Many people already have connections setup in their local SSMS to all the servers in their environment. We can import those connections into our CMS so […]
T-SQL Tuesday on Wednesday
This month’s T-SQL Tuesday has been moved to Wednesday. The topic this month is “crap code”. This is a great topic to showcase what not to […]
How to setup CMS
If you need to setup a Central Management Server or just want to check it out, then here is how to do it. Open SQL […]
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 […]
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 […]
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 […]
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 […]
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 […]
You must be logged in to post a comment.