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

Oh Data! Microsoft Ships First Major OData Update in Nearly 8 Years

Microsoft today shipped a preview of OData .NET 8. OData v7.0 was released in August of 2016.
Full Stack Hands-On Development with .NET

In the fast-paced realm of modern software development, proficiency across a full stack of technologies is not just beneficial, it's essential. Microsoft has an entire stack of open source development components in its .NET platform (formerly known as .NET Core) that can be used to build an end-to-end set of applications.
.NET-Centric Uno Platform Debuts 'Single Project' for 9 Targets

"We've reduced the complexity of project files and eliminated the need for explicit NuGet package references, separate project libraries, or 'shared' projects."
Creating Reactive Applications in .NET

In modern applications, data is being retrieved in asynchronous, real-time streams, as traditional pull requests where the clients asks for data from the server are becoming a thing of the past.
AI for GitHub Collaboration? Maybe Not So Much

No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.