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

How to Find Queries Using an Index (and Queries Using Index Hints)

by Additional Articles

SQLServerCentral

Sometimes you know a query is out there, but it’s hard to find the exact query. In this post, Kendra Little gives example code to find queries using a specific index, or using an index hint.

DevOps Isn't Perfect

by Steve Jones

SQLServerCentral.com

Editorial

Mistakes will still be made with a DevOps process, but the benefits outweigh the mistakes.

Enable Trace Flags in SQL Server

by Steve Jones

SQLServerCentral.com

Administration

Learn how to enable trace flags to change the behavior of your SQL Server instance.

Deployment Automation for SQL Server Integration Services (SSIS)

by Additional Articles

SimpleTalk

Integration Services (SSIS)

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects.

Adding Years, Months and Days

by Pete Revell

SQLServerCentral.com

T-SQL

Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.

GUI or CLI

by Steve Jones

SQLServerCentral.com

Editorial

The debate over the CLI or GUI is an age old debate.

Managing Azure SQL Database Recovery

by Additional Articles

Database Journal

Azure SQL database

Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.