SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

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 consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking.  Hopefully this will… Read more

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 ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the… Read more

Optimize Recursive CTE Query

Author: Shaun Tinline-Jones Reviewers: Lubor Kollar; Conor Cunningham; Steve Howard; Kun Cheng; James Podgorski; Jimmy May; Joseph Sack; Welly Lee; Neeraj Joshi; Keith Bauer Introduction We recently assisted a global ISV to address a performance issue related to a poor performing recursive CTE (Common Table Expression). The ISV wanted the query that was running in… Read more

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 the application is deployed in a mixed environment. It comes down to finding out which version of SQL Server driver the application uses for connection. In the mixed environment, some application server machines have SNAC 9 (shipped with SQL… Read more

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 Server Migration Assistant!  With this version, Microsoft has announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL!   Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access. Brand new… Read more