Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

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-protected. Among other things, it fixes the...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 11-19-2008
Filed under: 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 as much possible. Rephrased to Adventure Works...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 10-23-2008
Filed under: 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 of Reporting Services 2008 as it bridges the...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 10-17-2008
Filed under: 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 to Prologika (Teo Lachev's Weblog) by tlachev on 09-23-2008
Filed under: 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 change the captions of certain calculated members...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 09-01-2008
Filed under: 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 and Report Builder 2.0 share the same design surface...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-31-2008
Filed under: 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 for official release in October. IMO, Report...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-25-2008
Filed under: 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 the SUM function to display empty. Steps to repro...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-15-2008
Filed under: 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 and is planning to add a release candidate page for...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-13-2008
Filed under: 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 since the RC0 page has been taken offline. Update...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-07-2008
Filed under: 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 my previous posts. Note that if you have Visual Studio...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-06-2008
Filed under: 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 the report sample I posted. What makes it interesting...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-05-2008
Filed under: 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 sites and brick and mortar stores around the publication...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 07-20-2008
Filed under: 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 deploys the solution using the settings of the...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 07-12-2008
Filed under: 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 than likely, SQL Server 2008 will be released in...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 07-09-2008
Filed under: Filed under: SQL Server 2008

Page 1 of 3 (33 items) 1 2 3 Next >