See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Application Lifecycle Management
Data Protection Manager
Essential Business Server
Full Text Search
Microsoft Security Essentials
Performance Point Server
Read Only Domain Controller
Remote Desktop Services
Slowly Changing Dimensions
Software + Services
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server Express
TechNet Road Show
Windows Phone 7
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
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...
10 Aug 2011
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...
20 Jul 2011
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...
8 Feb 2011
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...
17 Sep 2010
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...
5 Feb 2010
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...
1 Dec 2009
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...
10 Aug 2009
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...
20 Apr 2009
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...
4 Feb 2009
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...
3 Feb 2009
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...
16 Jan 2009
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...
11 Dec 2008
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...
10 Dec 2008
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...
20 Oct 2008
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. ...
26 Aug 2008
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...
8 Aug 2008
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...
31 Jul 2008
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...
27 May 2008
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...
28 Mar 2008
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. ...
6 Dec 2007
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...
4 Dec 2007
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...
1 Dec 2007
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...
24 Oct 2007
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...
12 Oct 2007
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...
6 Aug 2007
© 2013 Microsoft
Manage Your Profile