Browse by Tags
All Tags »
Reporting Services (RSS)
The first publicly available technical preview of SQL Server 2008 R2 has just been released to TechNet / MSDN subscribers. As with the development of SQL Server 2008 each successive CTP will have more features in. This CTP’s main feature is the
Read More...
Metadata is “data about data” and in the BI world this means two things: Definitions of terms, particularly calculations so that business users can understand what they are looking whether on screen or on paper. Lineage to understand where and how
Read More...
Sometimes when you run a report it’s not going to return any rows, perhaps because the user selected a filter for which there is no data, and that needs to be handled properly. Fortunately there’s a simple way to control the messaging when this
Read More...
Speaking at SQL Bits is a cool thing to do but may terrify many of you. Part of this is that you are on stage for an hour and that means a lot of preparation, both content and rehearsal. So one of the organisers, Martin Bell has come up with
Read More...
Service pack 1 of SQL Server2008 is primarily a combination of the three cumulative updates released so far, and has now been released as a public beta (or CTP to use Microsoft speak). Trying out the public ctp will enable you to apply all of these
Read More...
I have just been following a thread about using reporting services 2005 to produce a 55,000 row excel spreadsheet. The initiator of the thread was concerned that the report was locking up and was looking for a fix. I could suggest migrating to SQL Server
Read More...
Both Standard and Enterprise editions of SQL Server come with a lot more than just a database engine, there’s also a suite of BI tools: Integration Services (SSIS) Reporting Services (SSRS) Analysis Services (SSAS) which you are also licensed to use on
Read More...
As I have mentioned before Reporting Services (SSRS) in SQL Server 2008 has been completely re-architected, but how does that affect its performance. Firstly it’s important to understand what what reporting services is – a web service to render and deliver
Read More...
The idea of letting users design their own BI fills many experts with equal dread and delight. On the one hand users know exactly what they want and the IT professional is freed from the drudgery of endlessly tinkering with content. On the other
Read More...
Day 12 of my virtual advent calendar, about stuff I like in SQL Server 2008.. One of the frustrations I used to have with Reporting Services was to decide whether to use a table or a matrix data control, and if I got too far in to a design and it turned
Read More...
Day 11 of my virtual advent calendar, about stuff I like in SQL Server 2008.. …and I mentioned redesigning charts in my last post and the best answer might be to get your users to do it for themselves in Report Builder 2. Leaving you (the DBA BI expert)
Read More...
Day 10 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I have been using Reporting Services since beta 2 in SQL Server 2000, and for me the weak link was the charts which even then looked pretty basic… Many people resorted to using
Read More...
Notification services is one of the deprecated features in SQL Server 2008, essentially it is supported for now but will not be in the next release of SQL Server. If you are using notification services currently and you are looking to upgrade to SQL Server
Read More...
Typical, you spend a day off line at a team building exercise and then you find that the SQL Server team have released Report Builder 2.0 to a fanfare of silence. To rewind a bit Report Builder 2.0 sort of replaces Report Builder 1.0 that came with
Read More...
As I mentioned a few weeks ago the end user reporting tool for SQL Server 2008, Report Builder v2 didn’t release with SQL Server 2008. There was an RC0 version of it with SQL Server 2008 RC0 and when SQL Server 2008 released this download disappeared
Read More...
Subscribe in a reader" />
