Data for Defense

• by Steve Jones

• SQLServerCentral

• Security

The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.

Increase Query Speed with Covering Indexes

• by steve@thesqlguy.com

• SQLServerCentral

Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.

Implementing SQL Server Integration Services with Azure Data Factory

• by Additional Articles

• Database Journal

• Azure Data Factory
• Integration Services (SSIS)

Read on to step through the process of implementing Azure Data Factories.

Using All Your Tools

• by Steve Jones

• SQLServerCentral

• Database Weekly
• Tools
• T-SQL

Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.

Performance Tuning Using Extended Events: Part 1

• by Brian Davey

• SQLServerCentral.com

• Extended Events (XE)

In this article, learn how to identify performance tuning opportunities using Extended Events.

What's a forgivable mistake?

• by Steve Jones

• SQLServerCentral

• Career

Today Steve wonders if your company is understanding of your human frailty.

From Source Control to Database using SQL Compare Command Line

• by Additional Articles

• Redgate

• source control
• SQL Compare

Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.

Understanding Azure Storage Options

• by Additional Articles

• SimpleTalk

• Cloud Computing

The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.

Expect the Unexpected with DiRT

• by Steve Jones

• SQLServerCentral

• Disaster Recovery (DR)

Disaster recovery is no joke at Google, where they really test their systems, people, and processes.

Migrating Column Level Encryption from 2008R2 to Azure SQL Database

• by Gareth Barnes

• SQLServerCentral

A migration to Azure is stuck because of an encryption change in SQL Server. Learn how to get around this by using a certificate for encryption.