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...
Author: Dimitri Furman 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,...
Author: Denzil Ribeiro 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...
Author: Dimitri Furman 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...
Author: Arvind Shyamsundar 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...
Author: Denzil Ribeiro 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...
Author: Dimitri Furman 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...
Author: Dimitri Furman 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...
Author: Dimitri Furman 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...
Author: Rajesh Setlem 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...
Author: Kun Cheng (SQLCAT) 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...
Author: Dimitri Furman 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...
Author: Arvind Shyamsundar 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...
Author: Arvind Shyamsundar 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...
Author: Kun Cheng (SQLCAT) 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...
Author: Denzil Ribeiro 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,...
Author: Rangarajan Srirangam (AzureCAT) 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...
Author: Dimitri Furman Date: 09/11/2017
Common ISV application patterns using Azure SQL Data Warehouse
Author: John Hoang Technical Reviewers: Dimitri Furman, Murshed Zaman, Sanjay Mishra Overview This...
Author: John P Hoang - AzureCAT 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...
Author: Denzil Ribeiro 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...
Author: Steven.Schneider 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...
Author: Denzil Ribeiro 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...
Author: John P Hoang - AzureCAT 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,...
Author: Arvind Shyamsundar 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...
Author: Dimitri Furman 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...
Author: Dimitri Furman 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...
Author: Rajesh Setlem 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...
Author: Dimitri Furman 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...
Author: Dimitri Furman 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...
Author: Murshed Zaman_MSFT 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...
Author: Denzil Ribeiro Date: 12/08/2016
Oops Recovery with Temporal Tables
Reviewed by: Kun Cheng, John Hoang, Sanjay Mishra, Borko Novakovic, Denzil Ribeiro, Murshed Zaman...
Author: Dimitri Furman 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)....
Author: Mike Weiner - SQLCAT 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...
Author: Dimitri Furman 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...
Author: Arvind Shyamsundar 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...
Author: Sanjay Mishra Date: 10/19/2016
SQLSweet16!, Episode 9: Scripting Always Encrypted operations
Authors: Arvind Shyamsundar, Sanjay Mishra, Subodh Patil (iCertis), Mukesh Singh (iCertis), Ravi...
Author: Sanjay Mishra 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...
Author: Arvind Shyamsundar 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...
Author: Mike Weiner - SQLCAT 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...
Author: Dimitri Furman 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...
Author: Arvind Shyamsundar 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...
Author: Dimitri Furman 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...
Author: Sanjay Mishra 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,...
Author: Rangarajan Srirangam (AzureCAT) 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...
Author: Sanjay Mishra 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...
Author: Sanjay Mishra 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...
Author: Arvind Shyamsundar Date: 08/09/2016