SQL Server and SDS


Choose the Right Tab Control

ASP.NET's Repeater, DataList, and DataGrid controls display data in a tabular format with various features. Learn which control is the best fit for your app.

Build SQL Server Reports Quickly

Use the SQL Server Report Designer's wizards for a streamlined solution to setting up, designing, polishing, and publishing reports.

Track Changes With XML DataSets

Track changes in files using XML datasets with the DiffGram format. This format lets you track what has changed, and what hasn't.

Books: Master C# Database Programming

Database Programming with C# explains the essentials of database programming to those familiar already with C#. Learn to exploit the VS.NET IDE to access data, and more.

Store Large Lookup Tables in DataSets

When mobile users need to look up and edit data without direct network connections, persist DataSets of lookup information as local XML files to preserve offline updates.

Add Images to SQL Server

Adding images to and removing them from a SQL Server database is straightforward using simple drag-and-drop procedures.

Speed Up SQL Server Apps

Learn 10 useful tips and tricks that help boost SQL Server application performance.

Unifying Data, Documents and Processes

Disparate systems make business process automation inefficient. Semantic integration of structured, unstructured and process data simplifies implementation of a robust SOA model.

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.

Subscribe on YouTube