April 2009 - Posts

A new release of Reporting Services Linked Report Generator is now available (1.0.0.8) confirming support for SQL 2008 Reporting Services. Reporting Services Linked Report Generator is a .NET Windows Forms application that enables automatic generation of linked reports to any number of Reporting Services folders based on a single base report. This can be useful where you have a hierachical folder structure and need to deploy the same report to multiple levels of the folder hierachy at the same time. It also preserves report size and margin properties for linked reports.

 Download Linked Report Generator

 

Posted by sqldbatips | with no comments

Judging by the increasing volume of emails I have recieved over the last few months asking about SQL 2008 support in Reporting Services Scripter there is a definate increase in the uptake of SQL Server 2008 Reporting Services and so I'm happy to say I've released a new build to confirm support for SQL 2008. This is mainly a documentation update but also includes some fixes that were added in private builds for specific customers. As the Report Server endpoint has not changed in SQL 2008 (as far as the methods the tool uses) the older versions did work fine but I wanted to do some thorough testing before confirming support and with the release of SP1 for SQL 2008 now seems like a good time. As always feedback and suggestions for enhancements are always welcome.

Download Reporting Services Scripter

 

Posted by sqldbatips | with no comments

Cumulative update package 1 for SQL Server 2008 Service Pack 1 KB Article

Cumulative Update 1 for SQL Server 2008 Service Pack 1 (SP1) contains only hotfixes that were released in Cumulative Update 4 for SQL Server 2008. These hotfixes are not included in SQL Server 2008 Service Pack 1. Cumulative Update 1 for SQL 2008 SP1 is only intended as a post-service pack rollup for Cumulative Update 4 for the release version of SQL Server 2008 customers who plan to upgrade to SQL Server 2008 SP1 and still keep the hotfixes from Cumulative Update 4 for the release version of SQL Server 2008. No new hotfixes have been included in this cumulative update other than the hotfixes that were already released in Cumulative Update 4

Posted by sqldbatips | with no comments
Filed under: ,

Service Pack 1 for SQL Sevrer 2008 is now available (download link below). Two of the key features in this are the ability to slipstream the service pack with the RTM media to provide a prepatched install (which I tested during the CTP and seems to work great although it's a bit manual) and the ability to uninstall the service pack (will try this soon and report back) which should hopefully provide a quicker backout than the previous uninstall/reinstall route.

Download SQL 2008 SP1

Instructions for creating a slipstreamed SP1 install

 

Posted by sqldbatips | 1 comment(s)
Filed under: ,

An updated build of the ExpressMaint utility for SQL 2005/2008 is now available. This release contains the following changes

  • Added support for SQL Authentication
  • Fixed an issue with databases that have not started being filtered out in Express Edition

 Download links below

Download ExpressMaint from Codeplex

Download ExpressMaint from sqldbatips.com

 

Posted by sqldbatips | with no comments
Filed under: , ,