Configuring Azure SQL Databases Using Azure Resource Manager Templates

Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.

When Statistics Update

The default lock timeout

Installing SQL Server vNext on an AWS EC2 RHEL Instance

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.

Logical processors

Target Recovery Interval and Indirect Checkpoint

Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.

SQL Agent job to show SQL Server service details upon agent restart

To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.

Quick SQL Server Configuration Summary Report

This script will detect and display a quick summary of your SQL Server installation.

Setting Up Your SQL Server Agent Correctly

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.

Context Is Everything - Check Your Settings

Check 96 server and database settings to make sure they match your expectations in your databases with this script.