Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Skip Navigation Links
RSS
Login or Join
Skip Navigation Links

Session Details - 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 session will show that many of the answers to these issues are included in the new management features in SQL Server 2008: • Policy Management allows fine grain control and audit of the state of all of the servers in the organisation. • Configuration Servers 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.
Andrew Fryer
I am an MCDBA and evangelsit at Microsoft specialising in business intelligecne and data management. I got interested in large databases while at HM Customs in the nineties as part of the move to intelligence led resourcing, but another inititive namely outsourcing meant that my last ten years have been in the private sector working for a number of gold partners, before joining Microsoft last July. I got into SQL Server in v6 and have used this platform almost exclusively since then for a wide variety of clients from tiny breweries to global banks.

To view the presentation below in full screen double click on it.


Click here to view in local media player

Due to the size of these files we can only provided streamed versions.

Other sessions from this conference

A Testing Time... (Downloads) (Video)
A walk down memory lane (Downloads) (Video)
Advanced T-SQL (2005 and 2008) (Downloads) (Video)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite (Downloads) (Video)
Data Vizualisation - Make your reports useful to business - No more "Speed Dials" (Downloads) (Video)
Does your cube support your users reporting needs? (Downloads) (Video)
Don't try this at work ! (Downloads) (Video)
End to End Report Creation and Management using Microsoft SQL Server 2008 (Downloads) (Video)
Getting more value from your data through data mining. (Downloads) (Video)
Head in the Cloud... (Downloads) (Video)
How to approach zero downtime database upgrades (Downloads) (Video)
Indexes Basically (Downloads) (Video)
Microsoft's integrated end-to-end BI offering. (Downloads) (Video)
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse (Downloads) (Video)
Small Problem - Simple Solution: Lookup Tables (Downloads) (Video)
SQL Server 2008 for Developers (Downloads) (Video)
Understanding Query Cache and Query Plans (Downloads) (Video)
Useful Sql'y stuff that I've picked up over the years (Downloads) (Video)
Where’s my data? An introduction to Spatial Queries in SQL Server 2008 (Downloads) (Video)