Insufficient data from Andrew Fryer

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

Getting Started with Multi-Server Management

In SQL Server 2008 R2 multi server management is expanded by the use of a Utility Control Point.  This article shows you how to set it up from a clean install of SQL Server. Open SQL Server Management Studio (SSMS) and go to the menu -> view –> utility explorer…  From here you can sit… Read more

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 pack is… 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

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 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 2008 R2 August Technical preview Installation Guide

I have decided to install the SQL Server 2008 R2 August technical preview (aka CTP2) on Windows Server 2008 R2.  On this new OS there is a specific role the application sever role that you should setup before installing SQL Server This role adds in the .Net framework 3.5 sp1 that SQL Server needs as… Read more

SQL Server 2008 – Hierarchy ID Data Type

To show this we need to create a table with the new data type.. create table [dbo].Organisation (   DepartmentID int primary key nonclustered,   DepartmentName varchar(100) not null,     DepartmentHierarchyNode hierarchyid not null,   DepartmentHierarchyLevel as DepartmentHierarchyNode.GetLevel() persisted   — plus any other columns you need ) Note the level is a derived function of… Read more

IT Pro Momentum

  1.       Are you an IT Professional trying to get the latest Microsoft technologies to work in your organisation? 2.       Are you working in a small organisation that has no direct relationship with Microsoft? Then we have the answer for you with our Momentum program.  Simply put we give you a TechNet subscription and PSS… Read more

TechNet on the Road

We will again be stepping away from PPT and concentrating on a demo-packed full day. We will be visiting 5 locations (Reading, London, Manchester, Newcastle and Falkirk)   There are 3 separate sessions:1) Beyond SharePoint – a look at Microsoft Office Performance Point 2007 and Enterprise Search2) Windows Server 2008 Terminal Services and System Center3)… Read more