jetlounge

Browse by Tags

• MS Access
• Reporting Services
• Sharepoint
• SSAS
• SSIS
• SSRS
• WSS

• HOW TO: Uninstall SQL Server Embedded (from SharePoint or WSS)

  by David Leibowitz | April 29, 2009 | Comments: 148

  So you installed WSS or MOSS and let it install SQL Server Embedded by default. Then you upgraded to SQL Standard, Enterprise or maybe you ran the uninstall for SharePoint and realized that the SQL Express database wasn't removed. Here's how to remove it from the Run command: (on 32-bit platforms) msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB... Read More... : SQL Server, Sharepoint, WSS

• FIX: SSIS Script Component Error "The value is too large to fit in the column data area of the buffer"

  by David Leibowitz | February 03, 2009 | Comments: 148

  Received an error in an SSIS Package with a Script Transformation. The error was "The value is too large to fit in the column data area of the buffer." and Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException. The Script Component in the Data Flow was taking a large column of data (about 180 characters in width) and parsing it to multiple... Read More... : SQL Server, SSIS

• Creating a Data Mining Reporting Services Report - Quick Demo

  by David Leibowitz | September 04, 2008 | Comments: 148

  Good Demo on using the SQL Server 2005 Reporting Services Wizard to create a report based on a data mining model from SSAS http://www.sqlservercentral.com/articles/Video/64190/ Read More... : SQL Server, SSRS, SSAS

• Features Supported by SQL Server 2005 Versions

  by David Leibowitz | September 03, 2008 | Comments: 148

  Concise matrix of features by SQL Server 2005 version (Standard, Enterprise, Developer) http://msdn.microsoft.com/en-us/library/ms143761.aspx Read More... : SQL Server

• SQL Server 2008 Katmai Performance

  by David Leibowitz | June 10, 2008 | Comments: 148

  I have an article on DevX that compares SQL Server 2008 Reporting Services performance to SSRS in SQL Server 2005, from an execution perspective as well as development. As it is currently in CTP, these things may change. Link to the article: SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back? http://www.devx.com... Read More... : SQL Server, SSRS

• SQL Server 2005 SP3 Announced

  by David Leibowitz | May 09, 2008 | Comments: 148

  SQL Server 2005 Service Pack 3 (SP3) has been officially announced for release. The good news: sometime in 2008. The bad news: it won't be released until GA of SQL Server 2008. More here: http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx Read More... : SQL Server

• Error During Install of SQL Server 2005 : Transaction Manager is not available

  by David Leibowitz | January 18, 2008 | Comments: 148

  I was installing SQL Server 2005 with all the trimmings (including Notification Services) onto my WinXP Pro machine. During the install step for Notification Services I received a nasty error that looked exactly like this (only less blurry): The text of the error message is: Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server... Read More... : SQL Server

• Custom Totals in Reporting Services Matrix Reports

  by David Leibowitz | December 11, 2007 | Comments: 148

  I've got an article titled "Advanced Matrix Reporting" over at Simple-Talk that was just published. The biggest issue I find with the Matrix control in SSRS is the difficulty in doing complex aggregates other than SUM. Sometimes you'd like to do variances of year over year totals. Check out the article for dynamic dataset creation... Read More... : Reporting Services, SQL Server

• Merge Replication with SQL Server (from MS Access)

  by David Leibowitz | December 09, 2007 | Comments: 148

  Originally appeared in SQL Server Magazine If your mobile users aren't already demanding access to SQL Server data while they're on the road, they soon will be. Mobile users might need to add and edit records that they'll synchronize with the database when they return to the office. Or to get goods and services to customers faster, your... Read More... : SQL Server, MS Access

• SQL Reporting Services: Advanced Grouping

  by David Leibowitz | October 26, 2007 | Comments: 148

  I've got an article titled "Reporting at the Top" over at Simple-Talk that was just published. This is the article abstract: Often, when developing reports in Reporting Services (SSRS), one has to mix summary information with the details. In Reporting Services, It is not difficult to provide flexible grouping and to display the detail... Read More... : Reporting Services, SQL Server