Determining the number of DTUs which will help in deciding the service tier for Azure SQL.

The Upgrade Storm

by Steve Jones

SQLServerCentral.com

Editorial

Steve discusses upgrading your SQL Server and why it might make sense.

Advanced Testing of Your PowerShell Code with Pester

by Additional Articles

SimpleTalk

test

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.

Rollbacks Are Normal

by Steve Jones

SQLServerCentral.com

Editorial

At Google, rollbacks from deployments are normal.

Loading CSV Files Using Dynamic SQL

by Steven Tidwell

SQLServerCentral.com

Dynamic SQL

In this article, we will see of a quick way to load CSV files from a directory on your computer.

Monitoring Costs

by Steve Jones

SQLServerCentral.com

Editorial

There are lots of costs to monitoring your systems that many people ignore.

Azure SQL Database High Availability

by Additional Articles

Database Journal

Azure SQL database

Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high availability features of Azure SQL Database that mitigate risks affecting services within an individual Azure datacenter, rather than an entire Azure region.