Change Data Capture and Change Tracking
Do you need to find out what changed in a database? SQL Server 2008 contains two new features that enable you to detect changes to tables in an efficient and easy to consume way. Change Data Capture (CDC) is intended for scenarios like data warehouse load, where you need to be able to detect every single change, while Change Tracking is intended for synchronization where you only need to know which rows have changed. In this session, we compare these two features and explain when to use what. Then we go into details on configuration, performance and best practices of change data capture that we learned while creating the whitepaper “Tuning the Performance of Change Data Capture in SQL Server 2008”
| Session level: 300 |
 |
Consolidation and Optimization Best Practices: SQL Server 2008 and Hyper-V
In this session you will learn about the considerations you have to make when implementing a consolidation strategy using SQL Server and Microsoft Virtualization solutions. You will learn about the different methods of SQL Server 2008 consolidation and see on how you can implement SQL Server 2008 in an Hyper-V environment. The session covers best practices for running SQL Server workloads with Hyper-V, monitoring strategies and actions and data points related to performance of SQL Server running on an Hyper V Platform. You will understand on how Microsoft is “Saving Customers Money”, by bringing you the right consolidation techniques and implementation strategies.
| Session level: 200 |
|
Policy Based Managment with SQL Server 2008
Microsoft SQL Server 2008 introduces a new policy-based framework for database administrators, which can significantly improve administrative productivity and reliability. Database administrators declare their administrative intent through policies that are then applied by the system. This approach reduces the potential for administrative error and enables the framework to monitor or enforce the policies in an automated fashion. Not only can policies be applied to individual databases or tables on a single server, but they can also seamlessly be scaled to include large collections of objects spanning many server instances.
| Session level: 300 |
|
Upgrade to SQL Server 2008
So you like SQL Server 2008 and now you want to upgrade your existing SQL Server 2000 and 2005 instances to SQL Server 2008 and you want to migrate your databases to a new hardware? Then this session is for you. Learn what you need to do so your upgrade or migration goes smoothly. We explain the tools and resources that are available to prevent “interesting” experiences during upgrade, tell you how the upgrade process works and give an overview on how to upgrade individual components to SQL Server 2008.
| Session level: 200 |
|
