SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a ...

Welcome to the first of a two-part series. In this first part, I'll talk about the physical infrastructure that Microsoft uses to ensure availability and provide a high degree of uptime for the Azure ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale. One of the most fundamental choices to make when developing an ...