Speeding up large web server databases by using Distributed Partitioned Views on Federated Database...
FAQs on SQL Server replication and solutions to common problems. By Narayana Vyas Kondreddi.
Articles, code samples, and tools help with development of robust and flexible Data Transformation ...
Tutorial on Managing Unstructured Data with SQL Server 2008 by Graeme Malcolm.
Learn to combine SQL Server's PIVOT and UNPIVOT commands with Common Table Expressions by Michael J...
This tutorial walks you through SSIS Designer to create a simple ETL package that includes looping,...
Explanation of Replication with SQL Server 2000 by Mahesh Kodli.
Introduction and definition of SQL Server Service Broker by Roger Wolter.
Introduction to Spatial Data concepts as well as detailed SQL Server instructions on use by Jason F...
Article explores four approaches for coding SQL when results will be returned to an application tha...