Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Browse by Tags

Related Posts
  • Blog Post: Using Shared Web Parts in Report Builder 3

    Introduction Report Builder 3 is built into SQL Server 2008 R2 report manager and is a click once application. It is also available as a separate download in the feature pack. At the time of writing the November ctp is the latest verison which can be downloaded from here , and the relevant feature...
  • Blog Post: SQL Server 2008 reporting takes off!

    CTP5 has only been out for a week and so I was amazed that I got a comment on my blog from a specialist data and planning company operating in the aviation industry in the US.  The company, US Aviation Data and Planning Corp  (USADAP) are migrating their reports to SQL Server 2008 as I write...
  • Blog Post: 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 Report Builder 3, and also included multiple machine...
  • Blog Post: SQL Server 2008 Webcasts

    If you want to get an insight of what's hot on the next version of Reporting Services, you can't really do better than get it straight from one of the product managers. So checkout Jason Carlson the Principal Product Manager for reporting services who is presenting a webcast on 1 November. Of course...
  • Blog Post: 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 add-ons including the ubiquitous Dundas...
  • Blog Post: Query Across the Mersey

    SQL Bits 9 , Adelphi Hotel Liverpool 29th September to 1 October 2011, what else do you need to know? Well possibly a few things if you are now reading the second line of this post or you haven’t been to them before.. It’s the biggest and best SQL event in Europe, I know this because we get people coming...
  • Blog Post: Spatial and OLAP data in Reporting Services

    I spent a very interesting afternoon last week with the IT team at the RSPB to explore what they could do to combine their mapping data with the olap cubes they have in analysis services. The only out of the box solution in SQL Server for spatial data is the map control in reporting Services (in SQL...
  • Blog Post: SQL Server 2008 Reporting Services no longer depends on IIS

    It sometimes seems impossible to keep everyone happy all the time.  The Reporting Services predict team thought it would be a good idea to remove the dependency on IIS in SQL Server 2008, to make it easier to configure and to reduce the attack surface of the report server. However, there have been...
  • Blog Post: 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) to concentrate on getting them the data they need...
  • Blog Post: Deprecated Features in SQL Server 2008

    My first ever post was about the features in SQL Server 2000 that were deprecated in SQL Server 2005 i.e. they wouldn’t be available in the next release (SQL Server 2008). In the same way there are SQL Server 2005 features that will be deprecated in SQL Server 2008, they will still work and be supported...
  • Blog Post: PowerPivot Installation

    I hope my PowerPivot posts and videos are proving useful, and continuing this them I want to cover off installation. PowerPivot for Excel is a free download for Excel 2010 and simply doesn’t need any edition of SQL Server behind it. It comes in 32 bit and 64 bit depending on which variant of Excel...
  • Blog Post: Reporting Alerting in SQL Server Denali ctp3

    The installation experience for SQL Server Denali is very similar to SQL Server 2008 R2 but there are some important differences because of the new services.  I would also add that this is the install of the beta and I daresay I’ll need to do another post when it is released. The options for the...
  • Blog Post: Heat maps in SQL Server Reporting Services 2005

    Warm up your users this winter with heat maps in SQL Server 2005: This report was created by one of our testing gurus, Patrice Brassard, and uses a to show up a dll he has written in c#. The code was used to simplify the process of applying conditional formatting in every cell of the report. ...
  • Blog Post: Reporting Services drill-through for a matrix report

    One of the great things about working in Microsoft is the huge e-mail threads with where we share problems and resolve them, as you get to learn loads of tips and tricks. One of the nightmares of working at Microsoft is the huge e-mail threads with where we share problems and resolve them, as you have...
  • Blog Post: 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 the same server as the database engine.  That...
  • Blog Post: 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 the data in a report was derived. There are a number...
  • Blog Post: 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 causing some confusion and scratching of heads. ...
  • Blog Post: Getting Started with SharePoint and SQL Server Reporting Services – a guest post by Jess Meats

    One of the capabilities of SQL Server is the ability to create and publish rich reports on your data. One of the capabilities of SharePoint Server is the ability to store, manage and provide a portal to documents. Those documents could be your reports. So you have one system letting you create reports...
  • Blog Post: 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 SQL Server 2005.  The two tools are as different...
  • Blog Post: 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 end users don’t really understand the intricacies...
  • Blog Post: What's the Killer Feature in SQL server 2008?

    After the bad news about what's missing in SQL Server 2008, I thought it would be good to talk about what the most exciting bit is in the new release. For me this is the next version of Reporting Services. Reporting Services in SQL server 2005 can do amazing things and has already shaken up the reporting...
  • Blog Post: Who stole my Report Builder

    Anyone who has tried Report Builder v2, aka Report designer Preview, blue etc. will have noticed that it isn’t fit for purpose yet.  By this I mean it is not in a state in which you could give it to a what Microsoft calls an information worker i.e. business user and get them to to generate their...
  • Blog Post: SQL Server Reporting Services

    Reporting Services can be a bit of a pain to configure so here's a top tip from Saleem Hakani who often sees this issue with his customers: Did you know that when SQL Server service account is configured with a Windows NT account, SQL Server sets various Windows user rights and permissions on several...
  • Blog Post: Upgrading SQL Server Business Intelligence

    Continuing my series of posts on upgrade, I thought it might be good to have a look at the business intelligence components of SQL Server, so here’s a simple grid that I have adapted from Scalability Experts for use in the upgrade workshops and presentations I give: Along the top is the upgrade...
  • Blog Post: 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 2008 as it has much better memory management and...