Insufficient data from Andrew Fryer

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

Report Builder 3.0 SparkLines

As a graphic designer and geek with a masters around cognitive psychology I am intrigued at how little use is made of the wonderful visualisations in many modern BI tools be they from Microsoft, Oracle IBM or SAP. Ignoring this trend, I wanted to show a new visualisation tool in SQL Server 2008 R2 called… Read more

Getting Started with SparkLines in ReportBuilder 3

First you’re going to need the download and install SQL Server 2008 R2 November CTP.  My step by step guide on doing that is here (which stil works with the November CTP) Now you’re going to need to have a copy of the adventure works database  from Codeplex I have used the version designed for… Read more

Reporting on spatial data in SQL Server 2008 R2

Report Builder 3 the latest version of the end user reporting tool in SQL Server 2008 R2  has built in support for Bing Maps and you can try this for yourself in the November CTP. To help you along I have posted a 9 minute screencast to TechNet Edge and published a step by step… Read more

Using SQL Server 2008 R2 Report Builder 3 with Bing Maps

This article shows you how to get started with Report Builder 3 (RB3) and Bing Maps. I could use adventure works to show you this but I thought you might want to see a little bit of our green and pleasant land instead. To do this I have put  the previous SQLBits venues into a… Read more

SQL Server 2008 R2 image preparation

With the rise of the virtual machine, the quick creation of a sandbox in which developers and testers can work without fear of compromising the production environment becomes a much simpler exercise. You will see built in support for this lab management in the ultimate edition of Visual Studio Team System (VSTS) through the use… Read more

SQL Server 2008 R2 Prepare Image Cook Book

This article walks you through the steps to prepare and complete an image installation of SQL Server 2008R2.  I am assuming you’ll be doing this in a virtual machine so that you can make copies of it for development and test. If you are running your virtual machine on Windows Server 2008R2 you should install… Read more

SQL Server MVPs

The best thing about working with SQL Server is working with the other people that use it.  The SQL server experts who do most for their colleagues in the community are recognised as MVPs, so not only do they know their stuff they are willing to share their knowledge. Of course you could argue that… Read more

SQL Bits Friday session

I promise this is the last time I mention SQL Bits this week, but I wanted to let you know I have got 25 free tickets for the paid for event this Friday which would normally cost £149 to attend.  The venue is the Celtic Manor in Newport… and is probably the next best thing… Read more