Connect to SQL Server Instances -- Visual Studio Magazine

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.

By Bill Vaughn
10/01/2005

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 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.

Printable Format

comments powered by Disqus

Featured

Microsoft Closes Request for Universal UI Builder: 'It's Baffling'

Microsoft last week closed a feedback request for a universal UI builder as capable as WinForms, putting an end to a long-sought coding nirvana with a decision that angered some developers.
Azure AI Foundry Gets NVIDIA Tech

AI powerhouse NVIDIA flexed its muscle at its GTC 2025 conference this week where several partnerships with Microsoft were announced, mostly concerning Microsoft's Azure AI Foundry offering.
AI's Takeover of Software Development Gets a Name: 'Vibe Coding'

Microsoft's VS Code dev team rides the vibe.
.NET 10 Preview 2 Enhances Blazor, .NET MAUI

According to the release notes, however, most dev-team attention was devoted to small fixes, features and functionality, as was the case in Preview 1, which shipped a few weeks ago.
OpenSilver 3.2 Takes WPF Apps to Mobile with .NET MAUI Hybrid Integration

OpenSilver, an open-source, WebAssembly-based reimplementation of the deprecated Microsoft Silverlight, now supports .NET MAUI Hybrid for cross-platform web and native app development.