Report Builder 2.0 RC1

August 26, 2008

My favorite "toy" in SQL Server 2008 just got a brand new spanking release! Report Builder 2.0 just went RC1 after it didn't appear in the feature pack of SQL Server 2008 RTM. When I tried it out first, as a Report Designer Preview in CTP6, I loved it so much that I even decided to make a webcast out of it (both in Hebrew and in English).  Later, I found out this would become the "next generation" of Report Builder. When I downloaded the feature pack that came with SQL Server 2008 RC0 I admit I was a...

Cumulative Update Package 9 for SQL Server 2005 SP2

August 19, 2008

CU9 for SQL Server 2005 Service Pack 2 has just been released, which I should have guessed as the grounds have also been made for Cumulative Update Package 10 as well. It seems that you may need CU9 to correct a bug caused from installing Cumulative Update Package 7. What's the problem? Apparently you may get an error message after installing CU7, when you explicitly define a slice at a partition and then process the partition by using a query that returns no records. To read more about the problem that may arise from CU7, that was fixed in...

Please drive safely

Today, I understood the difference between reading about a car accident, and witnessing one. I was on my way to work this morning and I had crossed the street to the other side. I even managed to take a few steps towards the office. Suddenly, I heard a screech of breaks from behind me. I turned around to see on the other side of the street, a man flying off in the air and land on the asphalt. I screamed. After a second, I noticed the accident involved two people, the driver of the mini - bike (which I...
3 comments

BIDS Helper for SQL Server 2008

August 17, 2008

I know I had recommended the BIDS Helper for you before, but as a new version of this Visual Studio add – in just got out this Saturday with support for SQL Server 2008, I thought it's a great time to remind everybody they should check it out. Most of the features in this release are available only through their source code, which is there for you to compile and deploy yourself. My personal favorite feature would be the Non-Default Properties Report, which helps you track the settings in your SSIS Package or your SSAS cube and...

SQL Server 2008 Express – Download it!

August 12, 2008

Till now Microsoft enabled you to download SQL Server 2008 for a trial version of 180 days. You could get it from MSDN for the Developers and Architects of you and from TechNet for IT Professionals and IT Managers (you get the same download on both sites, only with differently focused follow – up emails, according to your role). Yesterday however, Microsoft also released SQL Server 2008 Express. Yes, I grant you, it does not have full functionality in it like SQL Server 2008, but I personally would be very happy to play around with what’s...

A Parent Child Dimension for an Unbalanced Hierarchy

August 4, 2008

I found myself revisiting the Parent Child dimension quite unexpectedly. I'm working on a project which involves the division of the city to different statistical areas. The division of the city into these different statistical areas happens once every 10 years or so, according to the changes in population tracked by the municipality itself and the government in the Census of Population and Housing. Up till now, my cube had in it just the statistical areas distribution from one Census onwards and so had just one sort of distribution I needed to connect to in my cube. However, now...