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

Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures

Learn how to capture errors in SQL Server stored procedures and gracefully handle errors using Try Catch coding in your stored procedures.

SQL WAITFOR Command to Delay SQL Code Execution

One of the most rarely used commands in SQL is the WAITFOR command. It is one option to invoke a delay in program execution in absentia. Because it is sparsely used, how and where it can be applied when needed is often forgotten. For example, we could use this to mimic a user response or input or perhaps to collect data at certain intervals during the day.