Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in CMS

Below is a link to a white paper I wrote on Central Management Server.  This white paper is an excellent guide for those who have never used it before.  It walks you through how to use CMS from beginning to end.  Here is what you can expect to learn: Where to find CMS in management […]

On September 7th, 2011 at 1pm Central Time the SQL Server Worldwide User Group will be airing my presentation on how to Manage your shop with CMS and PBM.  The webcast is free for SSWUG members and $29 for non-members.  As an added bonus, I will be in the live chat room ready to answer […]

I will be speaking for the PASS DBA Virtual Chapter on August 24th, 2011 at 11AM CT.  I will be delivering my presentation on Central Management Server and Policy Based Management. If you have not checked out the virtual chapters that PASS has, then you need to Go Check Them Out.  These chapters are designed to fill […]

I will be speaking at SQLSaturday #90 in Oklahoma City on August 27th, 2011.  I will be delivering my presentation on Central Management Server and Policy Based Management. I’m looking forward to this event since I lived in the western Oklahoma City suburb of Yukon for about 5 years.  I’m hoping to visit some of […]

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 […]

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 […]

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 […]

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, […]

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 […]

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 out that you can use an IP address.  I think Microsoft prevents this primarily because you already have a connection defined for it simply by virtue of it […]