Microsoft's SQL Server has a handy command that rebuilds all indexes in a table. Oracle users typically rebuild each index in a table individually.

With more updates to the Visual Studio interface for SQL projects coming up and an immediate iteration to v2 of the Microsoft.Build.Sql SDK, there's new ways to increase your confidence in database ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.