SQL Server Under New Management

  • Article

I am now hard at work on the events that will occur around the release SQL Server 2008. This time around I will be presenting:

SQL Server Under New Management

The ratio of DBA’s to the size of data being  managed is increasing all the time as is the burden of compliance regulation ,so what can be done to square this circle?  This TechNet event will show that many of the answers to these issues are included in the new management features in SQL Server 2008, none of which require a change to existing applications:

  • Policy Management allows fine grain control and audit of the state of all of the servers in the organisation.
  • Configuration Server allows policies and SQL to be evaluated against a group of servers.
  • Resource Governor in Enterprise edition dynamically mediates workloads when the server is under pressure.
  • The Performance Data Warehouse allows historical statistics to be analysed.
  • Change Data Capture and audit provide a rich source of compliance data without adversely impacting performance.
  • Replication is much simpler to configure and maintain.
  • PowerShell support allows repetitive tasks to be scripted and integrated into other administrative tasks in Windows Server 2008.

The accompanying PowerPoint deck for this event is there as an aide memoire for you, as it’s going to take all morning to show all of this in action, and to answer your questions.

This will be run in Manchester on the morning of 7th October (register here) and then again down in Exeter in the afternoon of 23rd October (register here) and in Manchester.

There will be another event at the Microsoft campus in Reading on 10th of September, but the details of this have not been finalised yet. 

BTW Don’t infer the release dates of SQL Server from these dates as these events are driven by availability of venues and speakers and not by any cunning marketing plan. when I know you’ll know.

Technorati Tags: SQL Server 2008,events,technet