TechEd IT Forum: Data Management Track Top 5 Sessions
Here are the top 5 sessions for the Data Management track according to the client track owner:
An Overview of the Next Release of Microsoft SQL Server
This session provides an overview of the next release of SQL Server, SQL Server 2008. The session will cover the core value-proposition, major themes and scenarios, and some specific improvements. We also cover the new development processes being used to build this release, the release timeline and the disclosure calendar.
The Next Release of Microsoft SQL Server: Manageability Overview
The next release of SQL Server will contain exciting new manageability features targeted at reducing total cost of ownership. Come learn more about what's in store in areas like policy-driven administration and performance data collection and analysis. The session focuses on the database engine.
SQL Server 2008 – Enhancement for the Relational Data Warehouse
As a part of the “Pervasive Insight” theme, a lot of work was done to make SQL Server 2008 an even better platform for relational Data Warehouses (DWs), from small to multi-Terabyte. New T-SQL commands like MERGE are introduced to make updating a DW a better experience. Change Data Capture enables you to do high performance tracking of changes in production tables. Star Join enhancements make typical DW queries faster and more efficient. Data and Backup compression reduces both on-disk size and I/O bandwidth requirements on large DWs. Partitioned Table parallelism enhance multithreaded queries against partitioned tables. Native support for new Date/Time data types enable hassle-free import of temporal data from other platforms. Come to this session to see how all of these features work and how they make SQL Server 2008 a great Data Warehousing platform.
Introducing SQL Server 2008 Resource Governor
Resource Governor is a new technology in Microsoft SQL Server 2008 that enables DBAs to manage SQL Server workload and resources by specifying limits on resource consumption by the workloads. In an environment where multiple distinct workloads are present on the same server, Resource Governor enables one to differentiate these workloads and allocate shared resources based on the specified limits. This would improve predictability of execution and minimize "run-away query" scenarios when combining workloads with different resource requirements. Understanding Resource Governor model will help writing smarter applications to utilize it to the full extent.
During the session we will go over the functionality of SQL Server 2008 Resource Governor. We will cover typical user scenarios, explain the model, and describe ways to control resources in this release followed by a demo of the functionality.
Secrets to Fast Detection and Recovery from Database Corruptions
How can you tell whether your data is corrupt? If you have corruption, how do you work out what’s wrong with the database? How do you ensure you have a valid backup? If you don’t have a valid backup, how and what do you repair? If you do have a backup, how do you work out whether you should restore or repair? And at what granularity? How do you go about determining what went wrong in the first place? It’s all about limiting downtime and data-loss when a corruption occurs - from knowing the tools to understanding the choices to planning a successful strategy. Some of the features discussed:
- Torn-page detection and page checksums
- IO read-retry
- Backup checksums
- Consistency checks (DBCC CHECKDB and related commands
- Database repairs
Facing database corruption is almost inevitable in every DBAs career - make sure you're prepared when it happens to you.
Want to know which other sessions that have been planned at the event? Check out the Content Search tool
