SQL Server


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.

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.

Add Images to SQL Server

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

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.

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.

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.

Speed Up SQL Server Apps

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

Output Your Trace Info

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

Most   Popular