DBA307 SQL Server 2005: End-to-End Part 2 (Deploy and Operate)
Day/Time: Tuesday, June 7 5:00 PM - 6:15 PM Room: N 320 D/H Speaker(s): Euan Garden, Michael Raheem, Dan Winn
There are a number of steps involved in the creation of a database application. In this series of sessions we look at the full application lifecycle, from design and build, through deployment and operations to adding BI features to the final application. Throughout the series, you will see best practices for approaching each phase, so if you are looking for the best way to build SQL Server 2005 applications then these three sessions are the place to start. In the second of this series we look at how to take the application that was designed and built in the first session and deploy it into a production environment. We review many of the decisions that you can make with regards to setting the environment up to achieve great reliability, scalability, availability and security. We also look at how SQL Server 2005 helps you manage and operate your application more efficiently once it is deployed, including looking at how the new management and operation tools let you monitor your systems and schedule common tasks, giving you more time to focus on value added tasks.
DBA312 Â Upgrade and Migration: Planning Considerations for SQL Server 2005
Day/Time: Friday, June 10 9:00 AM - 10:15 AM Room: N 220 E Speaker(s): Michelle Alexander, Michael Raheem
The new features of SQL Server 2005 are well worth the upgrade effort, but how do you upgrade your existing systems painlessly? This session drills into the necessary upgrade planning: preparing to upgrade, choosing the best upgrade strategy, and identifying incompatibility issues. Learn tips and techniques on how to reduce your upgrade down time and how to best utilize the upgrade tools. This session has live demos of the Upgrade Advisor tool and in-place upgrade features of SQL Server 2005.
DBA320 Be More Productive: A Guided Tour of the New Management Tools in SQL Server 2005
Day/Time: Thursday, June 9 1:30 PM - 2:45 PM Room: N 320 D/H Speaker(s): Michael Raheem
Learn how the next generation of SQL Server 2005 tools can increase your productivity. This session drills into the new features of the tools, and demonstrates how to best leverage them to increase your efficiency. Come away with tips and techniques for increasing your productivity with the new tools. This session is filled with demos of Management Studio, SQL Agent, Profiler/Replay, Database Tuning Advisor & SQLCMD.
DAT310 Â Programming SQL Server Management Objects (SMO)
Day/Time: Friday, June 10 10:45 AM - 12:00 PM Room: S 210 E Speaker(s): Michiel Wories
SQL Server Management Objects (SMO) is a new .NET object model providing programmatic management for SQL Server 2005, as well as SQL Server 2000. This session provides detail about the SMO architecture improvements over SQL-DMO and gives you an overview of its main features. Various code examples will illustrate SMO's usage.
DAT383 SQL Profiler for the Developer
Day/Time: Tuesday, June 7 10:45 AM - 12:00 PM Room: S 220 E Speaker(s): Richard Campbell, Vipul Shah
The Profiler tool in SQL Server 7/2000 is one of the most underutilized tools available for SQL Server. The Profiler allows you to see exactly what commands and statements SQL Server receives from your application -- and what you write often isn't what SQL Server gets. This session explores how Profiler works and how you can use Profiler to understand your database application's behaviour. Included in this session is a detailed examination of ADO.NET and how different ADO.NET settings can change the behaviour of the same SQL query. Get a handle on what's really going on in SQL Server!
DBA209 SQL Server Management and Monitoring in the Enterprise: Managing a Distributed SQL Server Environment with SQL Server 2005
Day/Time: Thursday, June 9 3:15 PM - 4:30 PM Room: S 210 B Speaker(s): Vipul Shah, Dmitry Sonkin
This presentation is focused on managing SQL Server 2005 in a distributed environment using SQL Agent, SQL Server Management Pack for Microsoft Operations Manager (MOM ) and Replication Monitor. First, we briefly cover the SQL Agent architecture. We then discuss key enhancements to SQL Agent in SQL Server 2005 and its role as the primary job scheduling and execution mechanism for SQL Server. Then, we complete the equation with the latest in service availability detection, performance monitoring, problem detection, alerting and diagnosis of a distributed SQL Server environment using MOM and the new and improved Replication Monitor.
Previous Topic
