Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 files had 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 THE event for developers and IT Professionals. And if you want to know more about PowerPivot, here’s yet another reason why you need to go. There will be a raffle to win a signed copy of...
  • Blog Post: 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 with many TAP customers...
Page 1 of 1 (8 items)