By Brian Moran – Eating a steak in multiple, smaller bites is easier, safer, and tastier than trying to gulp it down all at once. The same advice holds true when modifying massive amounts of data.

This library implements a Delphi class for easy writing of Extended Stored Procedures for the Microsoft SQL Server.

.NET offers new options for accessing your data, forcing you to decide two things when you design the interface that exposes this content. With the release of Visual Studio .NET (VS.NET) and the .NET Framework, a good number of organizations have begun architecting and implementing .NET

Large XML documents present a problem when they need to be transformed using XSLT or filtered using the XmlDocument class. Because the DOM works by loading the entire XML document into memory, transformations can perform poorly. Fortunately, the .NET platform provides a robust set of classes in the

Wednesday, June 26 – Learn the best strategies to implement replication and troubleshoot any technical hurdles along the way from Microsoft’s own replication experts! This chat will cover all types of replication including Transactional Replication, Merge Replication and Snapshot Replication in SQL

by Brad M. McGehee – As SQL Server DBAs and developers, we all know how important it is to document our database designs and server configurations. Producing and maintaining complete SQL Server documentation is an important job of every SQL Server developer and DBA. Here are just a few of benefits o

By Alexander Chigrik – In this article, I want to tell you about distribution statistics, and about how you can view and update distribution statistics.

I was digging through Books Online the other day and I ended up on the FROM clause. I was expecting a simple little entry but that wasn’t quite what I found …

From SQLSecurity – NGSSoftware releases yet another SQL Server 2000 buffer overflow with exploit code written in T-SQL (not too shabby). The hole affects the OPENDATASOURCE function when invoking the Jet data access provider. Microsoft’s solution – download the latest Jet version. Does this strike a

Here is a useful list of tips for SQL Server 2000 optimization.