Event Review: Microsoft SQL Server 2005 Technical Overview (Session TNT1-133)

Download the full multimedia recording of this session.

Download just the slides and transcripts of this session.

In this demonstration the new management interface for SQL Server 2005 is shown, including the new buttons, menus, Register Server panel, Object Explorer, and Solution Explorer. The ability to hide panels is also demonstrated as is the ability to store multiple scripts and projects in Management Studio. Examine the configuration steps for configuring and using SQLiMail, the new SMTP-based e-mail notification program.   
Download

See what the new Object Explorer interface Solution Explorer look like. The ability to hide panels is demonstrated as is the ability to store multiple scripts and projects in Management Studio.   
Download

Examine the configuration steps for configuring and using SQLiMail, the new SMTP-based e-mail notification program.  
Download

Here the new XML Showplan feature is demonstrated using saved queries. Learn how to use the Database Tuning Advisor to analyze a saved workload in the form of a trace file and how you can choose the recommendations that you want to implement. Also, learn how those recommendations can be saved as Transact-SQL in a script.
Download

View in one window both the results of a Profiler trace that you have run and the results of the Performance Monitor operating system capture that you ran at the same time. The new view also allows you to step through the code, viewing the impact on the operating system counters you chose to capture, or you can choose a point in the graph and see the line of code that caused that change in the counters. Also, capture deadlocks. After you have captured a deadlock in a trace file, use the new graphical display of a deadlock to help analyze where the issues are located in the code that was run. The last new diagnostic tool that is demonstrated is the ability to view Windows event logs and SQL Server logged events in a single display, where events that were logged at the same time in the two tools are displayed together.   
Download

View one of the new security enhancements, the ability to use Profiler to audit DDL events, with the ability to choose the columns that will be reported on.  
Download

This demonstration shows that, with the new security architecture that separates the user from the schema, you can drop a user without having to rewrite application code.  
Download

Get a look at the configuration steps that set up table partitioning, including the configuration of the file groups, the partition function, and the partition scheme. After the configuration is complete, you can query to find out the partition a particular row is in to determine whether the row has been corrupted and, if so, you can restore just that file group.  
Download

Look at the configuration of the initial publication you want to use in peer-to-peer replication. Then see the new (Beta 3) peer-to-peer configuration wizard, which will allow you to configure the entire peer-to-peer topology between two or many servers. Since the wizard still has a bug, you see the completed configuration of the topology using another script. After the configuration is complete, applets will be used to demonstrate the ability of SQL Server 2005 to replicate DDL statements, and you see the replicated records between the two databases used in this demonstration.  
Download