Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.

Azure DWH Part 5: How to work with the command line in Azure SQL DW

by Daniel Calbimonte

SQLServerCentral.com

Azure

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse

Database Cattle

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones says you should treat your database servers like cattle. It makes life easier.

SQL Migrator (Part 2)

by Datamate Technology

SQLServerCentral.com

SQL Server

Automated Upgrade\Migration Tool for SQL Server

Exploring Azure Storage for SQL Server DBAs

by Additional Articles

SimpleTalk

Azure Storage

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.