Opinions, tips, and news orbiting Microsoft
First published on MSDN on Jul 03, 2017
Authored by Steven Schneider
Reviewed By: Denzil Ribeiro, Dimitri Furman, Mike Weiner, Rajesh Setlem, Murshed Zaman
Background
SQLCAT often works w… Continue reading How the SQLCAT Customer Lab is Monitoring SQL on Linux
First published on MSDN on Jun 02, 2017
Reviewed by:
Dimitri Furman, Sanjay Mishra, Mike Weiner, Arvind Shyamsundar, Kun Cheng, Suresh Kandoth, John Hoang
Background
Some of the best practices … Continue reading Performance impact of memory grants on data loads into Columnstore tables
First published on MSDN on May 17, 2017
Authored by John Hoang
Authors: John Hoang, Joe Sack and Martin Lee
Abstract
This article provides an overview of the Microsoft Azure SQL Data Warehouse… Continue reading Azure SQL Data Warehouse loading patterns and strategies
First published on MSDN on Apr 06, 2017
Contributions from, and reviewed by: Ken Van Hyning, David Shiflet, Charles Gagnon and Alan Ren (SSMS dev team), Dimitri Furman, Mike Weiner and Rajesh Setlem (SQLCAT)
Background
… Continue reading Try and try again: not always a good idea (at least not for SSMS!)
First published on MSDN on Mar 30, 2017
The widely popular
SQLBits
conference will take place April 5-8 2017 in Telford, UK. Several SQLCAT team members will be presenting a number of breakout sessions. Our topics this year … Continue reading SQLCAT at SQLBits 2017
First published on MSDN on Mar 10, 2017
Reviewed by: Pat Schaefer, Rajesh Setlem, Xiaochen Wu, Murshed Zaman
All SQL Server versions starting from SQL Server 2012 SP1 CU2 support
Backup to URL
, which allows s… Continue reading Backing up a VLDB to Azure Blob Storage
First published on MSDN on Feb 23, 2017
Authored by Rajesh Setlem
Reviewed by: Steven Schneider, Sanjay Mishra, Mike Weiner, Kun Cheng, Dimitri Furman, Arvind Shyamsundar,
Mahesh Unnikrishnan, Luis Car… Continue reading SQL Server Availability Groups in Azure VM setup with AAD Domain Services
First published on MSDN on Feb 03, 2017
Written by: Josh Gnanayutham, Program Manager, SQL Engineering
Introduction
As users are increasingly moving their data to the Azure cloud, migration from SQL Serve… Continue reading Migration from SQL Server to Azure SQL Database Using Transactional Replication