Connect to SQL Server Instances
Learn to address the issues you'll face as you connect to, manage, and monitor SQL Server instances.
VSLive! Orlando, October 2005
 Watch the video of the session! (1 hour, 10 minutes, Windows Media format)
|
|
|
Bill Vaughn,
President,
Beta V Corp.
|
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 instances—including 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 status—for both the execute and fetch phases of the query.
About the Speaker
William (Bill) Vaughn is President of Beta V Corp. He's developed for, taught, and written about mainframe and personal computers since '72, including 14 years at Microsoft. He's the author of the best-selling books ADO.NET and ADO Examples and Best Practices for VB Programmers, Second Edition and ADO.NET Examples and Best Practices for C# Programmers.
Back to top
|