SQL Server Customer Advisory Team
SQLCAT at PASS Summit 2018
This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years...
Date: 11/05/2018
Real-time performance monitoring for Azure SQL Database Managed Instance
This article was co-authored by Dimitri Furman and Denzil Ribeiro Reviewed by: Danimir Ljepava,...
Date: 09/26/2018
Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)
Reviewed by: Kun Cheng, Borko Novakovic, Jovan Popovic, Denzil Ribeiro, Rajesh Setlem, Arvind...
Date: 07/20/2018
DataCAT team at Data Platform Summit 2018
Team members from Microsoft AzureCAT (a.k.a. DataCAT / SQLCAT) will be presenting a full-day...
Date: 07/16/2018
Turbo boost data loads from Spark using SQL Spark connector
Reviewed by: Dimitri Furman, Xiaochen Wu Apache Spark is a distributed processing framework commonly...
Date: 05/12/2018
CPU and Memory Allocation on Azure SQL Database Managed Instance
Reviewed By: Ajay Kalhan, Borko Novakovic, Drazen Sumic, Branislav Uzelac In the current Azure SQL...
Date: 05/04/2018
Azure SQL DB Managed Instance - sp_readmierrorlog
Reviewed by: Kun Cheng, Borko Novakovic, Arvind Shyamsundar, Mike Weiner Azure SQL Database Managed...
Date: 05/04/2018
SQL Server VLDB in Azure: DBA Tasks Made Simple
Reviewed by: Rajesh Setlem, Mike Weiner, Xiaochen Wu With thanks to Joey D’Antoni (blog) for asking...
Date: 01/22/2018
Recent Updates to setting up SQL Server Availability Groups in Azure VM with AAD Domain Services
Reviewed by: Dimitri Furman, Kun Cheng This blog is an extension to the one that was published in...
Date: 10/30/2017
SQLCAT @PASS Summit 2017
Are you coming to the PASS Summit 2017 in Seattle? SQLCAT will be in full force at the PASS Summit...
Date: 10/30/2017
Top Questions from New Users of Azure SQL Database
Reviewed by: Kun Cheng, John Hoang, Denzil Ribeiro, Rajesh Setlem Over the years, we have been...
Date: 10/23/2017
Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems
Authored by Arvind Shyamsundar (Microsoft) Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun...
Date: 10/19/2017
Performance implications of using multi-Statement TVFs with optional parameters
Authored by Arvind Shyamsundar (Microsoft) Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun...
Date: 10/16/2017
Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses
Reviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh Setlem Most people familiar with Azure...
Date: 10/06/2017
Unattended install and configuration for SQL Server 2017 on Linux
SQL 2017 bits are generally available to customers today. One of the most notable milestones in the...
Date: 10/03/2017
Enterprise Data Pipelines using Azure PaaS Services – An Introduction
Authors: Rangarajan Srirangam, Mandar Inamdar, John Hoang Reviewers: Murshed Zaman, Sanjay Mishra,...
Date: 09/19/2017
Instant Log Initialization for SQL Server in Azure
Reviewed by: John Hoang, Denzil Ribeiro, Rajesh Setlem, Mike Weiner Introduction Instant File...
Date: 09/11/2017
Common ISV application patterns using Azure SQL Data Warehouse
Date: 09/05/2017
Collecting performance data with PSSDIAG for SQL Server on Linux
Reviewed by: Suresh Kandoth,Rajesh Setlem, Steven Schneider, Mike Weiner, Dimitri Furman When...
Date: 08/11/2017
How the SQLCAT Customer Lab is Monitoring SQL on Linux
Reviewed By: Denzil Ribeiro, Dimitri Furman, Mike Weiner, Rajesh Setlem, Murshed Zaman Background...
Date: 07/03/2017
Performance impact of memory grants on data loads into Columnstore tables
Reviewed by: Dimitri Furman, Sanjay Mishra, Mike Weiner, Arvind Shyamsundar, Kun Cheng, Suresh...
Date: 06/02/2017
Azure SQL Data Warehouse loading patterns and strategies
Authors: John Hoang, Joe Sack and Martin Lee Abstract This article provides an overview of the...
Date: 05/17/2017
Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB
Authored by Arvind Shyamsundar and Shreya Verma Reviewed by Dimitri Furman, Joe Sack, Sanjay Mishra,...
Date: 04/21/2017
SQLCAT at SQLBits 2017
The widely popular SQLBits conference will take place April 5-8 2017 in Telford, UK. Several SQLCAT...
Date: 03/30/2017
Backing up a VLDB to Azure Blob Storage
Reviewed by: Pat Schaefer, Rajesh Setlem, Xiaochen Wu, Murshed Zaman All SQL Server versions...
Date: 03/10/2017
SQL Server Availability Groups in Azure VM setup with AAD Domain Services
Reviewed by: Steven Schneider, Sanjay Mishra, Mike Weiner, Kun Cheng, Dimitri Furman, Arvind...
Date: 02/23/2017
Migration from SQL Server to Azure SQL Database Using Transactional Replication
Written by: Josh Gnanayutham, Program Manager, SQL EngineeringIntroductionAs users are increasingly...
Date: 02/03/2017
How to Check Database Availability from the Application Tier
Reviewed by: Mike Weiner, Murshed Zaman A fundamental part of ensuring application resiliency to...
Date: 01/29/2017
Azure SQL DW: Moving to a different region with restore from backup option
Reviewers: Dimitri Furman, John Hoang, Mike Weiner, Denzil Ribeiro, Joe Yong Background: Azure SQL...
Date: 12/20/2016
Improve query performance on memory optimized tables with Temporal using new index creation enhancement in SP1
Reviewed by: Dimitri Furman,Sanjay Mishra, Mike Weiner With the introduction of the Temporal feature...
Date: 12/08/2016
Oops Recovery with Temporal Tables
Reviewed by: Kun Cheng, John Hoang, Sanjay Mishra, Borko Novakovic, Denzil Ribeiro, Murshed Zaman...
Date: 11/10/2016
How bwin is using SQL Server 2016 In-Memory OLTP to achieve unprecedented performance and scale
Written by: Biljana Lazic (bwin – Senior DBA) and Rick Kutschera (bwin – Engineering Manager)....
Date: 10/26/2016
Migrating from SQL Server to Azure SQL Database using Bacpac Files
Reviewed by: Steven Green, Peng Song, Xiaochen Wu, Kun Cheng, Sanjay Mishra Introduction Database...
Date: 10/20/2016
Do it right! Deploying SQL Server R Services on computers without Internet access
Reviewed by: Sanjay Mishra, Umachandar Jayachandran, Dimitri Furman, Jeannine Nelson-Takaki, Joe...
Date: 10/20/2016
SQLSweet16!, Episode 10: "I can eat glass …", but can I load it into a database?
Sanjay Mishra Reviewed By: Dimitri Furman, Murshed Zaman, Kun Cheng If you have tried to use BULK...
Date: 10/19/2016
SQLSweet16!, Episode 9: Scripting Always Encrypted operations
Authors: Arvind Shyamsundar, Sanjay Mishra, Subodh Patil (iCertis), Mukesh Singh (iCertis), Ravi...
Date: 10/07/2016
SQLSweet16!, Episode 8: How SQL Server 2016 Cumulative Update 2 (CU2) can improve performance of highly concurrent workloads
Sanjay Mishra, Arvind Shyamsundar Reviewed by: Dimitri Furman, Denzil Ribeiro, Mike Ruthruff, Mike...
Date: 09/29/2016
SQLCAT at Microsoft Ignite 2016
Hi all, we are looking forward, as we are sure you are, to a great Microsoft Ignite 2016! Three...
Date: 09/24/2016
Determining Database Size in Azure SQL Database V12
A question that is frequently asked by customers using Azure SQL Database is “How can I determine...
Date: 09/21/2016
Using SQL Always Encrypted with Azure Web App Service
Reviewed by: Dimitri Furman, Jakub Szymaszek, Sanjay Mishra, Kun Cheng, Mike Ruthruff Background A...
Date: 09/15/2016
Real-World Azure SQL DB: Unexpected Database Maximum Size Limit
Reviewed by: Kun Cheng, Sanjay Mishra, Denzil Ribeiro, Arvind Shyamsundar, Mike Weiner, and Murshed...
Date: 09/13/2016
SQLSweet16!, Episode 7: Install Option for Instant File Initialization
Reviewed by: Dimitri Furman, Kun Cheng, Denzil Ribeiro Database Instant File Initialization helps...
Date: 08/23/2016
Migrating data to Azure SQL Data Warehouse in practice
Authors: Rangarajan Srirangam, Mandar Inamdar Contributors and Reviewers: John Hoang, Sanjay Mishra,...
Date: 08/18/2016
SQLSweet16!, Episode 6: DBCC CHECKDB with MAXDOP
Reviewed By: Dimitri Furman DBCC CHECKDB is a common database maintenance task. It can take up...
Date: 08/17/2016
SQLSweet16!, Episode 5: TRUNCATE Selected Partitions
Reviewed By: Denzil Ribeiro, Kun Cheng Deleting all rows from a given partition is a very common...
Date: 08/11/2016
Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database
Reviewed by Panagiotis Antonopoulos, Jakub Szymaszek, Raghav Kaushik Always Encrypted is one of the...
Date: 08/09/2016