Report Builder in SQL Server 2014

Monday, February 9, 2015

If you've been reading this blog over time, you probably noticed quite a bit of my development was done with Report Builder. Yes, that's the report model shipped with SQL Server 2005. Though my team is currently working on SQL Server 2008 R2, we're only now starting to develop BI solutions with other tools. We're set for a bit of a headache with our Report Builder 1.0 in SQL Server 2014. Report Model has been one of a set of deprecated features on SQL Server 2012 (and obviously also on SQL Server 2014). SQL Server has released PowerView in SQL Server...

Free eBooks on SQL Server, SharePoint, Office and more

Wednesday, August 8, 2012

So the price is still right - and yes, it's free! Marina my colleague from work sent me a really great link so obviously I had to share it with all of you. In his blog about Microsoft SMS&P Partner Community Blog, Mr. Eric Ligman has published a very extensive list of free Microsoft eBooks on SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more. The list is very comprehensive and I recommend you go over it and also look at the additional post he's linking to for even more eBooks...

SQL Server 2008 R2 SP1 download released

Tuesday, July 12, 2011

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 supportabilityDAC Framework for improved database upgradesDisk 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 hell in that team lately ;))
no comments

Problem updating Report Builder 1.0 Model in SQL Server 2008 R2

Thursday, January 6, 2011

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 on the Report Model...

Error Message When Using a New Feature in SSRS 2008 R2

Tuesday, January 4, 2011

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 the errors, warnings and messages in...

Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot

Monday, June 14, 2010

If you're following this blog, then you know that Sunday, May 30th 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 in Israel, I was like "What? Really? Like, Donald Farmer? Like THE...

Report Builder 1.0 vs. Report Builder 3.0

Tuesday, May 4, 2010

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 1.0 obsolete? Maybe there's no point in continuing to develop...

Win a free pass to the SQL & BI convention

Monday, May 3, 2010

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...

SQL Server 2008 R2 Released

Wednesday, April 21, 2010

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 dears as it is also available for download...

Microsoft All UP BI Demo version 9.2

Thursday, March 25, 2010

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 to run from that site and download the demo script. After that,...