Subscribe in a reader" />
Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

Insufficient Data

News

Browse by Tags

All Tags » Reporting Services   (RSS)
SQL Server 2008 R2 CTP1 released
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 in the Microsoft BI stack
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...
Reporting Services - Nothing to see please move along
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...
Five Minutes of Fame
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...
SQL Server 2008 sp1 CTP
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...
Exporting Data, the Right tool for the Right job
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...
Licensing and Scaling up SQL Server BI
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...
Reporting Services, the Need for Speed
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...
End User/ Self Service BI
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...
SQL Server Advent Calendar 12 - Tablix
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...
SQL Server Advent Calendar 11 – Report Builder v2
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...
SQL Server Advent Calendar 10 – Reporting Services Charts
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...
SQL Server 2008 Notification Services
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...
Report Builder 2.0 released
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...
SQL Server 2008 Report Builder v2.0 RC1
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...
More Posts Next page »
Page view tracker