25 September 2009 10:01 tonyrogerson

References + Deck + SQL Samples from my System Management presentation on 20090929 @ MS Data Management Conference in London

Note that I will be going into more detail in a series of 30-40 minute LiveMeetings starting towards the end of October, please see sqlserverfaq.com for more information - I'll be posting the info this weekend so check back after then. The session abstract: This predominately demo based session explores the features around the management of SQL Server 2008, specifically the Management Data Warehouse (Data Collector) and its use as a problem determination tool and for capacity planning, using Powershell and SQLCmd for routine maintenance and its use in applications, Event Notifications and Extended Events for keeping an eye out for unfolding problems, Policy Based Management to protect your Production environment and Dynamic Management Views (DMV's) for your day to day administration. The demos will be used to build a real world working system.

If you want a copy of the database for the Data Collector (MDW) demo workload you can download it here: http://sqlcontent.sqlblogcasts.com/meetings/ms20090929_datacollectiondemo.zip (75MB); make sure you check out the attached ZIP which contains the script prompt I used which will help you find your way through - any questions just email me tonyrogerson@torver.net.

The SQL Demos and my demo talk script can be got from here: http://sqlcontent.sqlblogcasts.com/meetings/MS20090929_SlideDeck_SQLDemos_TalkNotesScript.zip 

References

Enterprise Policy Management Framework

http://www.codeplex.com/EPMFramework

SQL Server Policy Based Management Blog

http://blogs.msdn.com/sqlpbm/archive/2008/04/20/policy-based-management-overview.aspx

SQL Server 2008 Feature Pack

http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en

Keep up-to-date with any new policies

Get Report Builder 2.0“Administering Servers by Using Policy-Based Management” – “Configuring Alerts to Notify Policy Failures”: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/ef2a7b3b-614b-405d-a04a-2464a019df40.htm

Central Management System

http://sqlcms.codeplex.com/ (Buck Woody Microsoft)

Powershell

Free Powershell scripts -> http://www.idera.com/Products/Free-Tools/PowerShell-scripts/

Extended Events

http://www.codeplex.com/ExtendedEventManager/ (by Jonathan Kehayias SQL MVP)

Event Notifications

http://sqlblogcasts.com/blogs/martinbell/archive/2009/05/22/Event-Notifications.aspx

http://sqlblogcasts.com/blogs/martinbell/archive/2009/05/26/WMI-Event-Alerts.aspx

 

Filed under: , , , , ,

Comments

No Comments