If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.

Redgate Data Tools in Visual Studio 2017 Enterprise

by Additional Articles

SQLServerCentral.com

RedGate

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.

SQL Migrator (Part 1)

by Datamate Technology

SQLServerCentral.com

Migration

Read about a free automated Upgrade\Migration Tool for SQL Server.

TempDB Database On a Local Disk for an FCI

by Sadan Kumar Budde

SQLServerCentral.com

failover

The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.

The Migration Checklist

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about the checklist you would want if you needed to move a SQL Server instance to new hardware.

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

by Additional Articles

MSSQLTips.com

Azure SQL database

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.

Actionable Metrics

by Steve Jones

SQLServerCentral.com

Editorial

Metrics should help you learn, or otherwise change the behavior of the system.

Detective Stories - Tracking Down the Database's Dependents Part 2

by Brandie Tarvin

SQLServerCentral.com

database dependencies

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.

Query Store and In-Memory OLTP

by Additional Articles

SimpleTalk

Query Data Store (QDS)

Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.

SSIS Catalog Compare v2.0 Launch Event

by Press Release

SQLServerCentral.com

Integration Services (SSIS)

Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.

Exploring Azure Storage for SQL Server DBAs

Redgate Data Tools in Visual Studio 2017 Enterprise

SQL Migrator (Part 1)

TempDB Database On a Local Disk for an FCI

The Migration Checklist

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

Actionable Metrics

Detective Stories - Tracking Down the Database's Dependents Part 2

Query Store and In-Memory OLTP

SSIS Catalog Compare v2.0 Launch Event

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

Increase Deadlock Detection

A Tool is Better than a Script

Understanding Deadlock Victim Selection in SQL Server

Question of the Day

Increase Deadlock Detection