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

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 database whose fileshad been copied from another server. This blog talks about the situation and the solution.  Here are the steps he went through to arrive at his situation. DBA #1 logs into a remote… 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

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

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 Server 2008 R2 RTM.  As noted in the SQL Server Data Platform Insider blog posting, this release has a lot of interesting features and is a major release.  We have spent a lot of time… Read more