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 ...

SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...

Stay tuned for “The end of SQL databases – part 2” (of a 3 part series) where we will take a walk through some of the currently available open and closed source NoSQL databases. Then in “The end of ...

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 ...

Having spent the last article showing how we can use WMI to perform a query for the current space on a drive, we need to take a it a step forward and begin tracking this data in a way that we can then ...

In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology ...

Built-in functions, UDFs, materialized results, and integrations with ML and AI models make streaming SQL a compelling choice ...