Compartir a través de


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

<Previous Next>