SQLServerPedia Syndication
All posts in this category get syndicated to SQLServerPedia.com
-
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, however, had something for everyone. There was everything including SQL, .Net, SharePoint, Security, Kinect, and even Windows phone. Overall, everything seemed to go very well. I delivered two sessions for the 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 we don’t have to manually recreate them all. We can also export the connections in our CMS to have available for importing to another CMS, another local SSMS, or simply…
-
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 do and see some actual bad code. After all we tend to learn best from our mistakes. However, I’m not going to show bad code. I want talk about code…
-
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 Server Management Studio and connect to the SQL instance you want to host your CMS. By default SSMS does not show you the Registered Servers pane. If you do not…
-
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 areas like .Net, Java, Windows Phone, and of course SQL Server. This year the conference has grown and expanded from one day to two days, and is…
-
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 it in the following post: How to add your CMS server to a group The second one can be a pain in large companies with multiple environments,…
-
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 and get a quick view of every server in our environment without having to remember each server and instance name. We also have the flexibility to arrange…
-
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 to a new drive. Let’s just walk through the basic steps. The first thing you need to do is get the new drive added to the cluster and…
-
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 and locations of the cluster resources itself are a little hidden in Windows 2008. Let’s just walk through the basic steps. The first thing you need to do…
-
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 directory file locations are not available. I recently ran into this after moving the user and system databases to a different SAN drive. Even though you tell SQL…