Peterson's Ponderings

Technical findings, ideas, thoughts and news directly from me.
in

Browse by Tags

All Tags » Microsoft SQL Server (RSS)
SSRS Export Feature Causes an "Object Moved" Error
I ran into the following issue with SSRS 2005 where some users would run a report and then try to export it into a different format (Excel, PDF, etc) using the SSRS web site tool bar resulting in an "Object Moved" error. Some would see the error...
Microsoft Synchronization Framework - Worth a Look
At TechEd earlier this month I attended some sessions on the new Microsoft Sync Framework that was just released as CTP2. Synchronizing data to a mobile device and between home office and remote locations has been a feature of several systems I've...
SQL Server Reporting Services Subscriptions with custom security
I ran into an interesting 'gotcha' when working with an SSRS site that has a custom security extension implemented (instead of using the built in Windows authentication model, see the MSDN security extension example). The problem was that when...
Data Warehousing Resources
I've had a few requests lately for resources I've used related to data warehouse design and performance tips for SSAS and SSRS for SQL Server 2005. I thought if a few people are interest there must be a lot of others out searching the web for...
Semantic Model Generator Error when creating a report model off of a SSAS cube
I recently experienced a really frustrating error when attempting to build a report model for SQL Server 2005 Reporting Services off of a SQL Server 2005 Analysis Services cube. I kept getting the following error message: w3wp!semanticmodelgenerator!5...
General advice on SQL Server General Network Errors
Arghh, what are these "General Network Error" messages? You know the ones, that randomly with no apparent pattern or reason happen in an application and raise tension between your developer and networking groups on who is to blame? Typically because it...
SQL Server 2005 Integration Service Package - Configuring Connections
I've been porting some DTS packages from SQL Server 2000 into the new Integration Services packages that are supported in SQL Server 2005. For those that are unaware, DTS is no longer a feature in SQL Server 2005 and has been replaced by the Integration...
SQL Server 2005 Book Recommendation
As some of you have noticed my blog has been kind of quiet lately, this is mainly because I've been doing a lot of reading lately and of course it is the holiday season. Well I decided to post some information on a SQL Server 2005 book that I've been...