RYANJADAMS
-
SSWUG and PBM
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…
-
PBM Import Options
When you import policies into your Policy Based Management Server you have two options. The first option is “Replace duplicates with items imported”. This option will replace any policies in your PBM server that have the same name as the one you are importing. This can come in handy if you have to make a…
-
Speaking at PASS DBA Virtual Chapter
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…
-
Understanding PBM Terminology
I get a lot of questions about the terminology surrounding PBM. Here is a list of the terms you will want to become familiar with along with a description. Facet – These are a grouping of properties based on a feature or particular aspect of SQL Server. Be sure to look through these after you enable…
-
Speaking at SQLSaturday #90
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…
-
What is Policy Based Management
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 are familiar with Active Directory Group Policy Objects then you will see a direct resemblance between the two technologies. PBM allows us to create rules for our SQL Servers so…
-
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…