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

Azure SQL Data Warehouse Workload Patterns and Anti-Patterns

Reviewed by: John Hoang, Dimitri Furman, Mike Weiner, Sanjay Mishra We often get questions from...

Author: Murshed Zaman_MSFT 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

Try and try again: not always a good idea (at least not for SSMS!)

Contributions from, and reviewed by: Ken Van Hyning, David Shiflet, Charles Gagnon and Alan Ren...

Author: Arvind Shyamsundar Date: 04/06/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

SQLCAT @PASS Summit 2016

Are you coming to the PASS Summit 2016 in Seattle? SQLCAT will be in full force at the PASS Summit...

Author: Sanjay Mishra Date: 10/13/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

Connect to Azure SQL Database V12 via Redirection

Reviewed by: Vince Curley, Saurabh Singh, Joe Ponce-Galindo, Murugan Ayyappan, Dimitri Furman,...

Author: Kun Cheng (SQLCAT) Date: 09/08/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

Next>