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

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

In the second part of this series, Joey describes the methods that Microsoft uses to manage code rollouts, and how it detects hardware and software problems on Azure SQL. In Part 1 of this series, you ...

But not everyone has VB skills, and writing SMO (SQL Server Management Objects) is neither easy nor intuitive. PowerShell allows you to script a database in just 21 characters of code and schedule it ...