Check Azure SQL DB Space Used

Learn how you can check the space used for your Azure SQL databases.

Logical Operators

Updatable Views II

Daylight Saving Time

Error_Severity()

The Default Variable String

An Updatable View

Use a Table Variable for Logging Entries that Need to Survive Rollbacks.

This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.

Query Exercise: Find the Best Time for Maintenance

If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?

Deploying Azure SQL Database Using an ARM Template

Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).