Tuesday, August 19, 2008

SQL Server 2005 SP2 Cumulative Update 9

Microsoft has released cumulative update 9 for SQL Server 2005 SP2. The details are published in KB article 953752.

To download the hotfix simply click on the "View and request hotfix downloads" link at the top of the article. Your platform is automatically detected so if you need the x64 build make sure to go to the link from an x64 machine, and vice-versa for x86.

Standard disclaimer applies here: Only apply if you're experiencing one of the issues specifically mentioned in the article.

Tuesday, August 12, 2008

SQL Server 2008 Feature Pack (August 2008)

If you've downloaded SQL 2008 you will also want to have a look at the August 2008 Feature Pack. The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

Redistributable components for SQL Server 2008

  • Microsoft SQL Server 2008 Command Line Utilities
  • SQL Server Compact 3.5 SP1
  • Microsoft Core XML Services (MSXML) 6.0
  • Microsoft SQL Server 2008 Management Objects
  • SQL Server Remote Blob Store
  • Microsoft SQL Server 2008 Native Client
  • Microsoft SQL Server 2008 Policies
  • Microsoft SQL Server System CLR Types
  • Microsoft Sync Framework

Add-on providers for SQL Server 2008

  • Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider
  • Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007
    • Table Analysis Tools for Excel
    • Data Mining Client for Excel
    • Data Mining Templates for Visio
  • Microsoft SQL Server Driver for PHP 7
  • Microsoft SQL Server 2005 JDBC Driver 1.2
  • Microsoft OLEDB Provider for DB2
  • Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

Backward compatibility components for SQL Server 2008

  • Microsoft SQL Server 2005 Backward Compatibility Components
  • Microsoft SQL Server 2008 Upgrade Advisor


Download: Microsoft SQL Server 2008 Feature Pack, August 2008

Friday, August 8, 2008

How To Script Replication Stored Procedures

If you use stored procedures to replicate commands there's a very useful procedure in SQL 2000 SP1 and up which will generate the custom insert, update, and delete procedures for all articles in a transactional publication: sp_scriptpublicationcustomprocs. It takes only one parameter - the name of the publication - and is run at the publisher. Details are available in BOL here.

sp_scriptpublicationcustomprocs relies on other stored procedures to create the scripts, some of which have been around since the SQL Server 7.0 days. These procedures are used to script individual articles and take an article ID as their only parameter (Article IDs are found by querying sysarticles in the published database). For CALL syntax the procedures sp_scriptinsproc, sp_scriptdelproc, and sp_scriptupdproc will generate the insert, delete, and update procedures, respectively. For XCALL syntax use sp_scriptxupdproc to generate the update procedure and sp_scriptxdelproc to generate the delete procedure. For MCALL and SCALL syntax use sp_scriptmappedupdproc to generate the update procedure. (Side note - if you don't understand the differences between CALL, SCALL, MCALL, and XCALL check out Specifying How Changes Are Propagated for Transactional Articles in BOL)

The ability to script some or all of the procedures necessary for a publication is very useful for many reasons. The obvious is when you already have the data at the subscriber and set up a subscription without synchronization. Or you may want to modify the scripts to do something special at the subscriber. The not so obvious situations are the ones that make life as a DBA interesting. I've had developers who didn't recognize "what all those sp_MS stored procedures were" in their database and included dropping them as part of their deployments. Oops. To be fair I've also dropped them unintentionally in moments of stupidity. You know that checkbox that says "Connect to Subscriber and delete record of this subscription at the Subscriber also" when you delete a subscription? Leave that checked next time you drop a subscription in a central subscriber topology and you'll find out why sp_scriptpublicationcustomprocs is so handy.

Thursday, August 7, 2008

SQL 2008 Is Officially Released!

Microsoft released SQL Server 2008 yesterday (press release available here). A new Web edition has been introduced which sits between the Express and Workgroup editions and is aimed primarily at hosting companies. A feature comparison chart of all editions is available here. Downloads are now available on TechNet and MSDN for subscribers. Express Edition should be available for free download at the end of this month.