Yes, you read it right, Service Pack 1 to SQL Server 2008 R2 was just released. This service pack (as ever) is a bundle of all the cumulative updates thus far for SQL Server 2008 R2. It includes, amongst others, the following things: DMVs for increased supportability DAC Framework for improved database upgrades Disk space control for PowerPivot And while you're looking into the SQL Server 2008 R2 SP1 download , you can also check out the Denali CTP3 download as well (they've been busy as...

So, as you may have gathered from the previous post, we installed SQL Server 2008 R2 in the municipality not too long ago. And yes, that led to all sort of problems... One of the main problems that all of us encountered, was that we couldn't update our report models. Yes, we could start a new Report Builder 1.0 Project. We could define a DSV and autogenerate a Report Model. But then, if we added a table to the DSV or new columns were added to an existing table, and then we would run an Autogenerate...

We installed SQL Server 2008 R2 about 2 months ago, and I recently tried to use a new feature in Reporting Services 2008 R2 . I used the Business Intelligence Development Studio (BIDS) to open a new Report Server Project. After creating a data source I also defined a shared dataset (a new feature to SSRS 2008 R2). I put some of the fields into a table and tried to run the report (still inside the BIDS). But I failed with an error: The report preview failed because the report could not be built. Read...

BI Key note Lecturers: Ori Weinroth and Frank Sidi What's new in SQL Server 2011 BI Services (Code name "Danali") Integration Services: Better developer experience - simply adding and removing columns. Manageability - easier control (didn't explain what exactly) Zoomx was bought by Microsoft - Integrated data cleansing tool. Analysis Services In-memory mode using the Vertipack engine. Now BI Developers can use MOLAP, ROLAP or Vertipack to implement cubes. This will improve our competitions...

If you're following this blog, then you know that Sunday, May 30 th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer 's seminar on Data Integration in Large Organizations . I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture...

The municipality has been planning to move to SQL Server 2008 R2 . Now obviously I'm happy about it, but it also made me wonder about our Report Builder 1.0 models. I know Report Builder 3.0 doesn't have all the functionality that Report Builder 1.0 has. In some ways Report Builder 3.0 outdoes version 1.0 and in other ways it's lacking. I was deliberating on how the move of upgrading to SQL Server 2008 R2 may affect us in the municipality. I mean, does that make our Report Models from...

As you may have read , I've got a ticket to give away for the first SQL & BI convention which is taking place at the end of this month in Tel Aviv. Yes, I'm going to give you a ticket which will grant you a pass to a day of lectures about all the new features in SQL Server 2008 R2. The lectures in the convention are aimed at helping you learn of the new features and how they can help you in your day to day work. The ticket to a day at the convention is worth 900 shekels - but for the...

שלום לכולם, אני שמח להזמין אתכם למפגש ה -12 של קהילת ה - BI המפגש יתקיים בתאריך ה - 28/4/2010 בשעה 17:30. כתובת: משרדי מיקרוסופט, הפנינה 4 רעננה. חנייה בחניון האורחים של מיקרוסופט. בתוכנית: 17:30 - 17:45 התכנסות 17:45 - 19:15 Performance Point Services 2010 צלילה מלווה בהדגמות אל החידושים/שיפורים ותועלות בגרסה החדשה של Performance Point. מרצה: ערן שגיא 19:15 - 19:30 הפסקה וכיבוד קל 19:30 - 20:45 Reporting Services 2008R2. תשכחו מכל מה שהכרתם עד עכשיו, מפות,KPI, קווים נוצצים (... J) ועוד. מה חדש?מה...

Well I guess the rumors had it right, because the first day of PASS Europe , Microsoft announced the release to manufacturing of SQL Server 2008 R2 . The main attraction, for me at least, will be PowerPivot (and DAX) and Report Builder 3.0 (with its shared datasets, maps and new calculations). Now, if you have a one track mind like me, first thing you would look for is SQL Server 2008 R2 Express editions, or in plain English - the free versions! Well, if you live in the US, then look no further my...

I knew from Russell Christopher's blog that Microsoft All UP BI Demo version 9.2 was released to partners , but as I'm not a registered partner, that didn't help me much... So I was delighted to discover today from the RDA blog that "Microsoft has configured a remote server for general public to get hands on experience with this new BI version 9.2 solution" - so yes, you can take that baby off for a spin! You need to register to the site first, run a .exe to enable the ActiveX...