Skip to main content

Add as a preferred source on Google


In-Depth

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

comments powered by Disqus

Featured

  • At Build 2026, Microsoft Sets Up Windows as an OS for AI Agents

    Microsoft's Build 2026 Windows developer announcements point to a broader platform strategy for agentic AI, spanning terminal workflows, local models, app-building skills, Cloud PCs and operating system-level containment.

  • Slammed by Copilot Usage-Based Billing on Day 1, Facing $180 Bill for June

    A journalist using GitHub Copilot Pro details how a broken editorial workflow on day one of usage-based billing led to runaway token consumption, a projected $180 monthly bill, and practical tactics for cutting AI credit burn.

  • AdaBoost.R2 Regression Using C#

    AdaBoost.R2 regression works by building an ensemble of decision trees, training them on reweighted data, and combining their predictions with a weighted median, while also showing how parameter choices affect accuracy and overfitting.

  • VS Code 1.122 Lets BYOK Work Without GitHub Sign-In

    Microsoft's May 2026 VS Code update makes BYOK usable in restricted environments while adding agent, browser and issue-reporting updates.

Most   Popular

Subscribe on YouTube