SQL Server Customer Advisory Team
Changes in SQL Server 2016 Checkpoint Behavior
Reviewed by: Denzil Ribeiro, Mike Weiner, Arvind Shyamsundar, Sanjay Mishra, Murshed Zaman, Peter...
Author: Mike Ruthruff Date: 08/03/2016
Installing SQL Server 2016 RTM? You must do this!
Arvind Shyamsundar, Lee Woods Reviewed by Jeff Papiez, Mike Weiner, Troy Moen, Suresh Kandoth It has...
Author: Arvind Shyamsundar Date: 07/28/2016
Real World Parallel INSERT...SELECT: What else you need to know!
Arvind Shyamsundar Reviewed by: Gjorgji Gjeorgjievski, Sunil Agarwal, Vassilis Papadimos, Denzil...
Author: Arvind Shyamsundar Date: 07/21/2016
Transaction dependency limits with memory optimized tables – Error 41839
Reviewed by: Jos de Bruijn,Mike Weiner, Mike Ruthruff , Kun Cheng As we discussed in a prior blog on...
Author: Denzil Ribeiro Date: 07/11/2016
SQLSweet16!, Episode 3: Parallel INSERT … SELECT
Sanjay Mishra, with Arvind Shyamsundar Reviewed By: Sunil Agarwal, Denzil Ribeiro, Mike Ruthruff,...
Author: Sanjay Mishra Date: 07/06/2016
SQLSweet16!, Episode 2: Availability Groups Automatic Seeding
Reviewed by: Denzil Ribeiro, Murshed Zaman, Mike Weiner, Kun Cheng, Luis Vargas, Girish Mittur V,...
Author: Sanjay Mishra Date: 06/28/2016
PolyBase Setup Errors and Possible Solutions
Blog Authors: Murshed Zaman and Sumin Mohanan Reviewer(s): Barbara Kess Prologue PolyBase is a new...
Author: Murshed Zaman_MSFT Date: 06/21/2016
SQLSweet16!, Episode 1: Backup Compression for TDE-enabled Databases
Sanjay Mishra, with contributions from Aasav Prakash Reviewed by: Denzil Ribeiro, Murshed Zaman,...
Author: Sanjay Mishra Date: 06/20/2016
Early Customer Experiences with SQL Server R Services
Reviewers: Dotan Elharrar, Sanjay Mishra, Mike Ruthruff, Umachandar Jayachandran, Jeannine...
Author: Joseph Sack Date: 06/16/2016
Should you upgrade to SQL Server 2016? Yes. Today. Now!
SQL Server 2016 became generally available starting June 1st, 2016. And you should be upgrading to...
Author: Sanjay Mishra Date: 06/14/2016
Checkpoint process for memory-optimized tables in SQL 2016 and implications on the log
Reviewed by: Alejandro Saenz, Jos de Bruijn; Joe Sack, Mike Weiner,Kun Cheng, Raghavendra TK A...
Author: Denzil Ribeiro Date: 05/20/2016
SQLCAT @ SQL Nexus conference
SQLCAT is coming to SQL Nexus in Copenhagen on May 2nd-4th and running a full day pre-conference...
Author: Denzil Ribeiro Date: 04/19/2016
Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys
Reviewed by: Jos de Bruijn; Joe Sack, Mike Weiner, Mike Ruthruff, Kun Cheng Transactions on memory...
Author: Denzil Ribeiro Date: 03/24/2016
SQL Server 2016 SSIS Data Flow Buffer Auto Sizing capability benefits data loading on Clustered Columnstore tables
Reviewers: Joe Sack, Arvind Shyamsundar, Murshed Zaman, Sanjay Mishra The focus of this blog is to...
Author: Denzil Ribeiro Date: 02/29/2016
Assigning surrogate key to dimension tables in SQL DW and APS
Reviewed by: James Rowland-Jones, John Hoang, Denzil Ribeiro, Sankar Subramanian This article...
Author: Murshed Zaman_MSFT Date: 02/18/2016
Soften the RBAR impact with Native Compiled UDFs in SQL Server 2016
Reviewers: Joe Sack, Denzil Ribeiro, Jos de Bruijn Many of us are very familiar with the negative...
Author: Arvind Shyamsundar Date: 02/17/2016
SQLCAT @PASS Summit 2015
Are you coming to the PASS Summit 2015 in Seattle? SQLCAT will be in full force at the PASS Summit...
Author: Sanjay Mishra Date: 10/10/2015
SQL 2016: Columnstore row group Merge policy and index maintenance improvements
A Columnstore...
Author: Sanjay Mishra Date: 08/17/2015
Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service
This topic explains the various Azure SQL Data Warehouse distributed table types, and offers...
Author: Sanjay Mishra Date: 08/11/2015
SQL 2014 Clustered Columnstore index rebuild and maintenance considerations
This article describes the index rebuild process as well as index maintenance for clustered...
Author: Denzil Ribeiro Date: 07/08/2015
SQL Server 2016 CTP2
If you haven’t been on a month-long holiday to a secluded island with no access to phone,...
Author: Sanjay Mishra Date: 06/05/2015
Azure SQL Database Security Features
The Microsoft Azure platform is evolving fast. Azure SQL Database, which is a Relational Database...
Author: Sanjay Mishra Date: 04/20/2015
Simplifying creation of SQL Credentials with Shared Access Signature ( SAS ) tokens on Azure Storage with Powershell
In SQL Server 2014 a new feature was introduced that enables SQL Server Data files to be stored on...
Author: Denzil Ribeiro Date: 03/21/2015
Data Loading performance considerations with Clustered Columnstore indexes
This article describes data loading strategies specific to tables with a Clustered Columnstore...
Author: Denzil Ribeiro Date: 03/11/2015
Large SQL Server database backup on an Azure VM and archiving
Applicable VersionsSQL Server 2014 and lower versions.BackgroundAzure Virtual Machines (VM) allows...
Author: Sanjay Mishra Date: 02/26/2015
Extending AlwaysOn Availability Group to Remote Azure Datacenter (PowerShell)
Author: Steven Schneider Reviewers: Sanjay Mishra, Shep Sheppard, Mike Weiner, Kun Cheng, Rama...
Author: Steven.Schneider Date: 09/22/2014
Windows Azure PowerShell Copy Blob Script
Here is a PowerShell script that can be used to move data in Windows Azure from one subscription to...
Author: Murshed Zaman_MSFT Date: 03/10/2014
AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments
Author: Sanjay Mishra Contributors: Piyush Ranjan, Steven Schneider Reviewers: Cephas Lin, Lori...
Author: Sanjay Mishra Date: 02/04/2014
AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
Author: Sanjay Mishra Reviewers: David P. Smith (Active Network), Mike Ruthruff (Bungie Studios),...
Author: Sanjay Mishra Date: 02/03/2014
AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios
Author: Sanjay Mishra Contributors: Piyush Ranjan, Steven Schneider Reviewers: Ed Muth, Chuck...
Author: Sanjay Mishra Date: 02/03/2014
Scaling-out SQL Server disks and data files on Windows Azure Virtual Machines…a real-world example
Authors: Tim Wieman , Sanjay Mishra Technical Reviewers: Silvano Coriani, Cindy Gross, Chuck...
Author: Tim Wieman (AzureCAT) Date: 01/16/2014
Be aware of the difference in isolation levels if porting an application from Windows Azure SQL DB to SQL Server in Windows Azure Virtual Machine
[One more post recovered from SQLCAT.com archives.] Author: Sanjay Mishra, Tim WiemanTechnical...
Author: Sanjay Mishra Date: 12/26/2013
Automating HDInsight cluster creation with PowerShell
If I have to do some work more than twice I like automating the process (or try to as much as I...
Author: Murshed Zaman_MSFT Date: 11/26/2013
SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns
This is one of the popular blog posts on sqlcat.com. Reposting (with updated links) here after...
Author: Sanjay Mishra Date: 11/20/2013
SQL Server 2014 In-Memory OLTP discussions at PASS Summit 2013
Wow, what a great PASS Summit! Great to see so many old friends and meet so many new ones! At PASS I...
Author: Mike Weiner - SQLCAT Date: 11/12/2013
Forcing NUMA Node affinity for Analysis Services Tabular databases
In the whitepaper, Hardware Sizing a Tabular Solution, we made a reference to Analysis Services...
Author: John Sirmon [MSFT] Date: 11/05/2013
Reporting Services Performance and Optimization
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 10/30/2013
SQLCAT.Com - eBook Downloads
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 10/23/2013
AzureCAT / SQLCAT at PASS Summit 2013
The SQL Clinic is back this year at PASS Summit. This clinic has been a staple of the PASS Summit...
Author: AzureCAT Date: 10/08/2013
Maximizing Throughput with TVP
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 09/23/2013
Report Server Catalog Best Practices
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 09/20/2013
Top 10 SQL Server Integration Services Best Practices
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 09/16/2013
Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 09/16/2013
Diagnosing Transaction Log Performance Issues and Limits of the Log Manager
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 09/10/2013
When To Break Down Complex Queries
As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to...
Author: AzureCAT Date: 09/09/2013
SQL Server Self-Service Kit : Provisioning SQL Server as a Service
Some great work is being done by the Windows Server and System Center CAT related to Hybrid Cloud...
Author: SQLShep Date: 09/06/2013
SQLCAT.com consolidated index of Whitepapers
In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have...
Author: SQLShep Date: 09/05/2013
The Future of SQLCAT.COM
Hello SQLCAT.COM friends:Thanks for your on-going support of SQLCAT.COM website for so many years....
Author: AzureCAT Date: 08/22/2013
SQL Server In-Memory OLTP Internals Overview for CTP1
Are you interested in learning more about SQL Server 2014 In-Memory OLTP (project codenamed...
Author: Mike Weiner - SQLCAT Date: 06/25/2013