SQL Server Customer Advisory Team
Performance Guidance for SQL Server in Windows Azure Virtual Machines
Authors: Silvano Coriani, Jasraj Dange, Ewan Fairweather, Xin Jin, Alexei Khalyako, Sanjay Mishra,...
Author: Sanjay Mishra Date: 06/17/2013
Access Azure Blob Stores from HDInsight
One of the great enhancements in Microsoft's HDInsight distribution of Hadoop is the ability to...
Author: Cindy Gross Date: 04/25/2013
Self-Service BI Works!
When I talk to people about adding self-service BI to their company's environment I generally get a...
Author: Cindy Gross Date: 04/16/2013
Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View
For my #SQLPASS Summit 2012 talk SQLCAT: Big Data – All Abuzz About Hive (slides available to...
Author: Cindy Gross Date: 02/01/2013
New version of Partition Management Utility supports SQL2012, ColumnStore Indexes
A new version of the Partition Management Utility for SQL Server is now available on Codeplex at...
Author: Stuart Ozer MSFT Date: 12/03/2012
Review a working option to setup a SQL Server 2012 BI solution using Azure’s IaaS VMs
By: Nicholas DritsasReviewers: James Podgorski, Olivier Matrat, Sanjay MishraOverviewAzure’s...
Author: ndr Date: 07/17/2012
AlwaysOn Availability Groups Generate Network Traffic with No User Activity
Author: Kevin CoxContributors: Min He,Steve LindellReviewers: Sanjay Mishra, Juergen Thomas, Jimmy...
Author: Kevin Cox SQL Server Date: 06/21/2012
Always On Availability Group: Connection to readable secondary fails when login SIDs are different or missing
When using ApplicationIntent=ReadOnly to access a readable secondary via the Availability Group...
Author: Kevin Cox SQL Server Date: 04/23/2012
Tuning Spatial Point Data Queries in SQL Server 2012
Written by: Ed Katibah, Milan Stojic, Michael Rys, Nicholas DritsasTechnical reviewers: Chuck...
Author: ndr Date: 04/17/2012
Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available
The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and...
Author: Prem Mehra Date: 03/06/2012
A Computed Column Defined with a User-Defined Function Might Impact Query Performance
Author: Kun Cheng Reviewers: Shaun Tinline-Jones, Silvano Coriani, Steve Howard, Thomas Kejser,...
Author: Kun Cheng (SQLCAT) Date: 11/28/2011
Writing New Hash Functions for SQL Server
Author: Thomas Kejser Contributors/Reviewers: Alexei Khalyako, Jerome Halmans, Fabricio Voznika,...
Author: Thomas Kejser Date: 11/28/2011
Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
Author: Shaun Tinline-Jones Reviewers: Mike Ruthruff, Sanjay Mishra, Alexei Khalyako Not too long...
Author: shauntj Date: 10/17/2011
SQLPASS 2011 SQLCAT Track
The SQLPASS 2011 summit is upon us again and all of our flocking to our fair city Seattle for our...
Author: Denny G Lee Date: 10/08/2011
Maximizing SQL Server Throughput with RSS Tuning
Author: Kun Cheng Reviewers: Thomas Kejser, Curt Peterson, James Podgorski, Christian Martinez, Mike...
Author: Kun Cheng (SQLCAT) Date: 09/26/2011
“QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query
Author: Shaun Tinline-Jones Technical Reviewers: Thomas Kejser, Steve Howard, Jaime Alva Bravo, Kun...
Author: shauntj Date: 08/31/2011
SSAS Maestros August 2011 Update
As noted in our blog post Announcing SSAS Maestros v1.2, we had a great Analysis Services Level 500...
Author: Denny G Lee Date: 08/23/2011
Unintended Consequences of Scalar-Valued User Defined Functions
Author: Chuck HeinzelmanReviewers: Kevin Cox, Dan Jones, Lara Rubbelke During a customer engagement,...
Author: ChuckHeinzelman Date: 06/24/2011
Why can't I attach a database to SQL Server 2008 R2?
Recently, a problem was presented to me by a DBA using SQL Server 2008 R2. He could not attach a...
Author: Kevin Cox SQL Server Date: 06/20/2011
Unexpected Consequences of Multiple Result Sets
Author: Chuck HeinzelmanReviewers: Kevin Cox, Kun Cheng, Michael ThomassyIn a recent customer...
Author: ChuckHeinzelman Date: 05/31/2011
SQL Server Migration Assistant (SSMA) v5.0 just released!
Exciting news as earlier this week the SQL Server Product Group announced the release of SQL Server...
Author: Mike Weiner - SQLCAT Date: 04/30/2011
Optimize Recursive CTE Query
Author: Shaun Tinline-Jones Reviewers: Lubor Kollar; Conor Cunningham; Steve Howard; Kun Cheng;...
Author: shauntj Date: 04/28/2011
32- and 64-Bit Connectivity from the Same Machine
Author: Chuck HeinzelmanReviewers: Steve Howard, Carl Rabeler, Shaun Tinline-Jones, Mike Weiner,...
Author: ChuckHeinzelman Date: 03/31/2011
Linked Servers to SQL Azure
Authors: Kevin Cox & Michael Thomassy Contributors: Lubor KollarTechnical Reviewers: Shaun...
Author: Kevin Cox SQL Server Date: 03/07/2011
Comparing Different Results with RCSI & Read Committed
Author: Kun ChengReviewers: Sunil Agarwal, Steve Howard, Shaun Tinline-Jones, Prem Mehra, Sanjay...
Author: Kun Cheng (SQLCAT) Date: 03/03/2011
Why the obsession with random I/O within the context of SSAS?
by Denny LeeAs many of you know from the various blogs, whitepapers, and conferences from SQLCAT,...
Author: Denny G Lee Date: 03/01/2011
Concurrency Series: My application was running fine yesterday but why is it blocking today?
Author: Sunil AgarwalReviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra, And...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Minimizing blocking between updaters
Author: Sunil AgarwalReviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra, And...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried?
Author: Sunil AgarwalReviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra,...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
Author: Sunil AgarwalReviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra,...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Basics of Transaction Isolation Levels
Author: Sunil AgarwalReviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra,...
Author: Sunil Agarwal Date: 02/20/2011
Watch out those prepared SQL statements
Author: Kun Cheng Reviewers: Sunil Agarwal, Chuck Heinzelman, Shaun Tinline-Jones, Prem Mehra...
Author: Kun Cheng (SQLCAT) Date: 12/21/2010
Transaction Log size does not match the size of the data being loaded.
I was working with one of our ISV partners recently and they mentioned some very unusual SQL Server...
Author: Peter Scharlock Date: 10/29/2010
How to tell which version of SQL Server data access driver is used by an application client
In a recent engagement with an ISV, we’ve run into a sporadic application failure problem when...
Author: Kun Cheng (SQLCAT) Date: 10/25/2010
Optimizing CREATE SET in Cube Calculation Scripts
Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin...
Author: Thomas Kejser Date: 08/31/2010
New Release of SQL Server Migration Assistant (SSMA) includes migration from MySQL and to SQL Azure
Wanted to let the community know the SQL Server Product Group just released version 4.2 of the SQL...
Author: Mike Weiner - SQLCAT Date: 08/13/2010
Loading data to SQL Azure the fast way
Introduction Now that you have your database set up in SQL Azure, the next step is to load your data...
Author: Lubor Date: 07/30/2010
Identifying query compile/runtime parameter values using XML SHOWPLAN output.
I recently returned from Convergence 2010; the annual North American Microsoft Dynamics User...
Author: Peter Scharlock Date: 06/09/2010
Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010!
There are many reasons to go to TechEd North America 2010 in New Orleans this year. After all, it is...
Author: Denny G Lee Date: 06/06/2010
SQL Azure Customer Best Practices
The SQLCAT team and the SQL Azure team have been working closely together with a number of customers...
Author: Michael Thomassy Date: 05/27/2010
Now that SQL Server 2008 R2 has RTM'ed...
We have been pretty excited about the last few weeks where there has been a lot of buzz about SQL...
Author: Denny G Lee Date: 05/13/2010
Resolving DTC Related Waits and Tuning Scalability of DTC
Author: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May,...
Author: Mike Ruthruff Date: 05/11/2010
Character data type conversion when using SQL Server JDBC drivers
Author: Kun ChengReviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter ScharlockIn a recent...
Author: Kun Cheng (SQLCAT) Date: 04/05/2010
Moving the Transaction log file of the Mirror Database
Author: Sanjay MishraReviewers: Prem Mehra, Mark Souza, Kun Cheng, Nicholas Dritsas, Thomas Kejser...
Author: Sanjay Mishra Date: 04/05/2010
Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
In SQL Server 2005, 2008 and 2008 R2 Database Mirroring works at the individual database level. One...
Author: Kevin Cox SQL Server Date: 04/01/2010
How to Enable RCSI for a Database with Database Mirroring
Author: Sanjay MishraReviewers: Prem Mehra, Alexei Khalyako, Kun Cheng, Mike Ruthruff, Thomas...
Author: Sanjay Mishra Date: 03/16/2010