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

Backup SQL Server on Linux Databases using SQL Server Agent on Windows

In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.

The Profiler Extension in Azure Data Studio (ADS)

This article covers the basics of the Profiler extension in Azure Data Studio, a handy way to trace your application calls.

Understanding Maximum Server Memory in SQL SERVER

This short piece explains the value of maximum server memory and shows you how to change this.

Sending resource alerts on Managed Instance using db_mail

One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don't have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In this post, you will see how you can monitor resource usage and send email alerts if there is a risk that you might reach the limits.

Finding Database File Growths

Identify log write limits on Azure SQL Managed Instance using QPI library

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify write log throughput issue on Managed Instance.

Attaching Databases

Backing Up Master