Share via


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

Next>