SQL Server


Create a DSN-Less Database Connection

Increase your application's flexibility and make the installation simpler by connecting to the database without generating a DSN in the ODBC Data Source Administrator. Instead, use VB code to configure the connection.

Books: SQL Server for Gurus

The Guru's Guide to SQL Server Architecture and Internals helps SQL Server power users manage their complex enterprise systems. This valuable reference manual goes far beyond the product's base documentation.

Output Your Trace Info

Output your trace information to new targets, including SQL Server and XML—and do it without parsing.

Enhance UI Performance in WinForms

You can improve your UI in several ways, using the .NET Framework's built-in multithreading and asynchronous execution mechanisms.

Automate Exception Logging

You can automate exception logging with one line of client code, control it through an App.config file without recompiling, and use custom publishers to craft cool logging tools.

Keep Data Consistent With Transactions

Employ the manual and automatic transaction models supported by the .NET Framework to maintain consistent data in your applications.

Enlist ADO.NET Connections in Pooled Objects Manually

You can boost performance in server-side apps by using COM+ pooled objects to cache resources. Be sure to enlist the connection manually each time the object pool picks up the object.

Activate Windows Impersonation Selectively

Activate Windows impersonation selectively, determine the update order of DataTables at run time, guarantee the delivery order of asynchronous delegates, and more.

Secure Your Directory-Enabled Apps

Find out how Active Directory Application Mode and Windows Authorization Manager can simplify security, personalization, and configuration for your directory-enabled applications.

Pros and Cons of SQLXML

Roger Jennings and a reader acknowledge that using the SQLXML interface to provide HTTP access to SQL Server is not appropriate for high-performance enterprise solutions.

Create a .NET-J2EE Shared Database

Create a shared database to provide interoperability between .NET and J2EE platforms, then extend it with a notification level between platforms.

Leverage Advanced Grid Components

ComponentOne's Studio Enterprise suite offers feature-rich components for desktop, Web, and mobile app development, available by annual subscription with quarterly updates.

Transfer Files Over the Internet

Use FTP or HTTP POST to transfer files over the Internet with .NET. Also learn how to secure a database Connection string.

Simplify Site Updates With Templates

Use a template to create a consistent look and feel for a Web site that doesn't require the end user who updates the site to be a programmer himself.

Use DataSets as Business Objects

Enhance the DataSet class with inheritance and extend its associated XML schema to hook validation checks and custom validation routines into DataSets declaratively.

Secure Your Directory-Enabled Apps

Find out how Active Directory Application Mode and Windows Authorization Manager can simplify security, personalization, and configuration for your directory-enabled applications.

Accelerate the Delivery of .NET Apps

Check out a number of .NET add-ins, including one that helps accelerate the deliver of .NET Framework solutions.

Product Listings

Take advantage of a number of VS.NET add-ins, including one that lets you implement and manage temporary links, which are URLs that are active for a limited amount of time and are typically used in software distribution and e-mail campaigns.

Indigo: The Longhorn Communications Layer

Indigo is the core for communication in the next generation of Windows, code-named Longhorn. This model of its architecture gives you a good sense of what to expect from it.

Manage SharePoint Lists

Use the Lists Web service and CAML to update Windows SharePoint Services' MSDE database.

Subscribe on YouTube