Browse by Tags

• Analysis Services
• Business Intelligence
• Reporting Services

• Cumulative Update 2 for SQL Server 2008

  Microsoft has released the Cumulative Update 2 build (build number 1779) for SQL Server 2008. The update is not publicly available as of now. It has to be released individually based on whether you are running into a bug fixed in the build and it is password... Posted Nov 19 2008, 12:58 PM by tlachev with | with no comments Filed under: SQL Server 2008

• SSAS WHERE vs. Subselect Puzzle

  I've been involved recently in a quest to optimize an SSAS 2008 long-running query that would return the 12-month history of a KPI. Since the KPI was displayed on a dashboard page alongside other KPIs and charts, it was important to optimize the query... Posted Oct 23 2008, 08:53 AM by tlachev with | with no comments Filed under: Analysis Services, SQL Server 2008

• Report Builder 2.0 RTM'ed

  Today, Microsoft released Report Builder 2.0 (build 10.00.1600.60) , as Robert Bruckner announced in his blog. This is a major milestone in the Reporting Services roadmap. In my opinion, Report Builder 2.0 is one of the most important and exciting features... Posted Oct 17 2008, 10:59 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Cumulative Update Package 1 for SQL Server 2008

  Microsoft has released the first for SQL Server 2008 cumulative update package. Among other issues, it fixes the SSAS bug with requesting measures with mixed aggregation functions which I previously reported . Posted Sep 23 2008, 01:20 PM by tlachev with | with 2 comment(s) Filed under: SQL Server 2008

• Personalized Cubes

  Scenario: You need to personalize the captions of calculated members or/and KPIs of an SSAS cube. For example, a solution vendor may need to deploy a cube to multiple clients. Instead of maintaining separate cube definitions, the vendor may prefer to... Posted Sep 01 2008, 09:33 PM by tlachev with | with no comments Filed under: Analysis Services, SQL Server 2008

• Extending Report Builder 2.0

  As I mentioned in my previous blog , Report Builder 2.0 RC1 has arrived. Although perhaps too early in the game, you may wonder how you can get the most out of Report Builder 2.0 and extend it when the built-in features are not enough. As Report Designer... Posted Aug 31 2008, 02:20 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services, SQL Server 2008

• Report Builder 2.0 RC1 is Here

  Thanks to Robert Bruckner's blog , I've learned that the Report Builder 2.0 (previously known as Report Designer Preview) Release Candidate 1 is available for download. This should be a feature-complete build of Report Builder 2.0, which is scheduled... Posted Aug 25 2008, 07:12 PM by tlachev with | with 1 comment(s) Filed under: Reporting Services, SQL Server 2008

• Nasty SSAS 2008 Bug

  There is a nasty known bug with SSAS 2008, where if a query that requests two measures with Sum and LastNonEmpty aggregate functions side by side and the query uses NON EMPTY (which all OLAP clients use by default), the server forces the measure with... Posted Aug 15 2008, 08:11 AM by tlachev with | with 1 comment(s) Filed under: Analysis Services, SQL Server 2008

• Where is Report Builder 2.0?

  With the official release of SQL Server 2008, Microsoft retired the RC0 Feature Pack and added the SQL Server 2008 Feature Pack, August 2008 page . Unfortunately, the Report Builder 2.0 link got dropped along the way. Microsoft is aware of this issue... Posted Aug 13 2008, 09:32 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services, SQL Server 2008

• Microsoft SQL Server 2008 Feature Pack, August 2008

  Microsoft released a Microsoft SQL Server 2008 Feature Pack, August 2008 page which includes a collection of stand-alone install packages that provide additional value for SQL Server 2008. Strangely, Report Builder 2.0 is excluded and nowhere to be found... Posted Aug 07 2008, 10:24 AM by tlachev with | with no comments Filed under: SQL Server 2008

• Microsoft Has Released SQL Server 2008

  Today, Microsoft announced that official release of SQL Server 2008. Build #10.0.1600.22 has been declared as a SQL Server RTM. SQL Server 2008 includes major enhancements to the Microsoft Business Intelligence Stack, some of which I have mentioned in... Posted Aug 06 2008, 01:47 PM by tlachev with | with no comments Filed under: SQL Server 2008

• Rules Have Changed

  An interesting question has pop up on the Katmai RS 2008 discussion list today about how to implement a "green bar" group-level report that alternates background color for all rows in a group instance instead of doing this for each row. I attach... Posted Aug 05 2008, 10:26 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• It's Done

  A quick update on my book Applied Microsoft SQL Server 2008 Reporting Services. I am happy to announce that the work on the manuscript is over and the manuscript RTM'd (released to manufacturing). The paper copy should be available on the reseller... Posted Jul 20 2008, 11:11 PM by tlachev with | with no comments Filed under: Reporting Services, Business Intelligence, SQL Server 2008

• Automating Report Deployment

  Here is an awesome tip courtesy to the Craig Guyer's I Command Thee blog . You probably know that Visual Studio supports project configurations. In BIDS 2008, you can automate report deployment with configurations. For example, the following command... Posted Jul 12 2008, 10:31 AM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• SQL Server 2008 Available on August Price List

  Courtesy to Francois Ajenstat, Director of Product Management for Microsoft SQL Server, we know that SQL Server 2008 is on the August price list. What this probably means according to my interpretation is that the SQL Server 2008 RTM date is close. More... Posted Jul 09 2008, 12:54 PM by tlachev with | with no comments Filed under: SQL Server 2008