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

Troubleshooting with the Microsoft 2008 R2 Tools

Tuesday, November 30, 2010

This is a live post from the session of Guy Glantser at Tech Ed Israel 2010 . Top - Down: Performance Monitor:%Processor Time% Disk TimePage faults \ secBuffer cache hit ratioFull scans \ secSQL complications \ sec Resource Governor:Managing SQL server workload and system resource consumptionIn essence, we check how much each query, application etc. require from our different resources. We can check by groups, resources and so on.We can then decide how to limit the use of the resource. Dynamic Management Objects:Querying DMVs to check query statistics, usage of buffers, partitions, indexes.All the data we get is from the last time we...

Free SQL Server and BI webinars from PASS

Monday, August 10, 2009

Via Dan English’s blog, I’ve learned that Pass is offering a day of BI webinars for free! The Pass Convention itself is scheduled for November in Seattle. As this year there will no dedicated BI conference from Microsoft, Pass is the conference for you to get updated on all your BI needs. This is also why I was very happy to hear they’re also offering a day of free sessions with very well known speakers.The sessions are mostly SQL Server 2008 oriented, but I believe you’ll find more than enough information there even if you’re using SQL Server 2005....

More News on SQL Server 2010 Madison

Tuesday, May 12, 2009

You know how they say “time just flies by you”? I think the year 2010 is coming quicker than I thought, and with it the new SQL Server 2010, code named Madison. Microsoft has announced that it is planning a Technology Preview for Madison in early July, so if you have a petabyte size DW then you might be one of the lucky customers invited to take project Madison for a test drive.Other announcements (coinciding with TechEd 2009), are of new features available in SQL Server 2008 R2 such as Master Data Services which should serving as a central...

Free training for SQL Server 2008

Friday, April 3, 2009

Microsoft continues in helping you learn SQL Server 2008, this time in collaboration with AppDev. You can download up to three hours of training. If you haven't used AppDev courses till now then you should know that they really walk you through the subject they're covering, also giving you an exam at the end of each part. It really makes for a great way to learn on whatever it is you're interested in. The courses offered are:  SQL Server 2008 for Developers, SQL Server 2008: Installing, Querying, and Security and Exploring SQL Server 2008. You can also choose to...
one comment

Free E-Book on SQL Server 2008

Monday, February 23, 2009

Site stats have shown me that you like free e-books, which is fine - because I like them too! :)...So following their free SSIS 2005 book, Microsoft is offering a few more books for free. First and foremost is Introducing Microsoft SQL Server 2008. Yes, they have offered the book before, but only a few chapters out of it. This time, we're talking about the whole book! Most of the book handles what's new with the product in general like Performance and Programmability, but chapter 7 is dedicated to everything that's new specifically for the part of BI. Another...
one comment

Free SSIS SQL Server 2005 Book

Tuesday, January 27, 2009

In celebration of Microsoft Press 25th Anniversary, they are going to offer a monthly free e-book. Till January 28th 2009, they are offering SQL Server 2005 Integration Services Step by Step by Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman for free. Yes, not just a chapter or two, but the entire book! I think you can find the book useful even if you're using SSIS in SQL Server 2008. Though I know they are some changes made to SSIS from SQL Server 2005 to SQL Server 2008, I think that quite a big part of...

Impact SQL Server 2010 Kilimanjaro

Sunday, December 21, 2008

Do you want to influence how SQL Server 2010 Kilimanjaro will look like? Do you submit issues to Microsoft Connect? Well this is the post for you... When I first saw Anthony Carrabino's post about a free hosted SQL Server 2008 offer I thought to myself that maybe I shouldn't have bothered putting up a virtual machine with SQL Server 2008 on it, when Microsoft is already offering me one all ready and for free... but that's not the exact case. Reading the page for the free SQL Server 2008 hosted account, one of the first things mentioned is actually...

Great Training and a Free Copy of SQL Server 2008

Thursday, December 18, 2008

Did you ever have a problem where you went to a course, studied something, but then didn't use it, so you ended up forgetting what you've learned?... Well Microsoft is going to see to it that it won't happen when you study SQL Server 2008. So, if you're interested in taking a course about the different parts of SQL Server 2008 (be it maintaining a DB, SSAS 2008, SSRS 2008 etc.), then you'll also get a fully licensed copy of SQL Server 2008 Standard Edition with one client access license. If you're interested in using the offer (which is...
2 comments

SQL Server SP3 Beta and more news

Tuesday, October 28, 2008

Well apparently, you can miss out on a lot of things during a two weeks vacation. Luckily I came back in time to see SP3 Beta for SQL Server 2005 get released! But I'll talk about that in a bit... The announcement of Project Gemini in SQL Server 2010 sparked a very heated debate in the BI Community, over how much it might be abused by users as an alternative to an organized DW \ OLAP solution. The discussion did not go unnoticed by Microsoft. I guess I can only sum up by saying that we'll see what happens in...