The Case of the Missing Date/Time Stamp: Reporting Services 2008 R2 Snapshots

January 25, 2011

This week I stumbled upon an undocumented “feature” in SQL Server 2008 R2 Reporting Services as I was preparing a demonstration on how to set up and use report snapshots. If you’re familiar with the main changes in this latest release of Reporting Services, you probably already know that Report Manager got a facelift this […]


Do-It-Yourself Map Gallery in SQL Server 2008 R2 Reporting Services

August 31, 2010

A common question that I get when introducing the map feature in SQL Server 2008 R2 Reporting Services is why the map gallery is limited to maps of the United States and individual states in the US. The reason as I’ve heard it explained is that the political boundaries for other countries are sometimes in […]


Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

May 23, 2010

Many people like me want (or need) to do their business intelligence development work on a laptop. As someone who frequently speaks at various events or teaches classes on all subjects related to the Microsoft business intelligence stack, I need a way to run multiple server products on my laptop with reasonable performance. Once upon […]


SQL Server 2008 R2 Reporting Services – The World is But a Stage (T-SQL Tuesday #006)

May 11, 2010

Host Michael Coles (blog|twitter) has selected LOB data as the topic for this month’s T-SQL Tuesday, so I’ll take this opportunity to post an overview of reporting with spatial data types. As part of my work with SQL Server 2008 R2 Reporting Services, I’ve been exploring the use of spatial data types in the new […]


Introducing Microsoft SQL Server 2008 R2 – Business Intelligence Samples

April 30, 2010

On April 14, 2010, Microsoft Press (blog | twitter) released my latest book, co-authored with Ross Mistry (twitter), as a free ebook download – Introducing Microsoft SQL Server 2008 R2. As the title implies, this ebook is an introduction to the latest SQL Server release. Although you’ll find a comprehensive review of the product’s features […]