Connect to SQL Server Instances
SQL Live! speaker Bill Vaughn guides you through the maze of issues you''ll face as you connect to, manage, and monitor SQL Server instances.
Watch the video of the session! (1 hour, 10 minutes, Windows Media format)
Using a series of demos drawn from his latest book, Bill guides you through the maze of issues you'll face as you connect to, manage, and monitor SQL Server instancesincluding the new SQL Express instance. He shows the new utilities and code used to configure SQL Server 2005, including demonstrations of code used to create the new SqlConnectionStringBuilder. You'll learn how to discover data source instances as well as start, stop, pause, and continue them, and how to configure, manage, and monitor the connection pool using new 2.0 Framework classes.
You'll see how to capture and display real-time operational statistics including data from the new performance counters. Using the new ADO.NET 2.0 async functions, Bill also shows how to fetch data and still retain control of the form thread to display statusfor both the execute and fetch phases of the query.