SQL Server and SDS


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.

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.

Getting Started With PKI

Computer networks allow people to share resources, but computer security prevents access to resources. How to decide if you need PKI, and a step-by-step guide to installing PKI on your servers.

Subscribe on YouTube