Insufficient data from Andrew Fryer

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

TechReady – Vista sp1 Testing

The geeks in Microsoft have taken over down town Seattle for the week as we all get our six monthly fix of the latest stuff that’s coming out.  This is one of the ways that Microsoft has to keep it’s technical people happy and it certainly works for me.  We get to meet the product… Read more

Analysis Services and Excel Pivot Tables

Excel is the number one business intelligence tool;  It fronts Hyperion, Cognos Financial Planning, and of course SQL Server Analysis Services and Performance Point Server Planning. In Office 2007 there is now excel services so that information workers can park their work on SharePoint where it can be properly secured.    One issue I have seen… Read more

SQL Server 2008 BI, Perception & Reality

Following all the acquisition mania in the BI marketplace last year, it’s interesting to see that the Microsoft approach of growing your own BI platform seems to be paying off according to this article by Gartner in Information Week. It has taken a while though – I well remember my first foray into olap services… Read more

SQL Server 2008, 9 or 10?

I am in soggy Seattle this week with a bunch of like minded SQL squirrels, so our super Tuesday was watching the product teams including, Ted Kummert, Donald Farmer and  Christian Kleinerman putting the latest refresh of SQL Server 2008 through its paces. One thing that made me smile as Ted was going through the… Read more

SQL Server 2008 Resource Governor in action

One of the biggest headaches in SQL Server 2005 is trying to manage resources where there are competing workloads on a shared server. A typical approach is to use instances, but this completely hides memory and CPU from other instances which are then not available to an instance under stress whether the other instances are… Read more

SQL Server 2008 Geo-Spatial functions and indexes

SQL Server 2008 enables the use of geo-spatial data or location intelligence in four ways: a new geography data type (there’s another one for 2D geometry), which can store points, lines, line segments and polygons A rich set of functions to make use of them, e.g. whether they intersect, how far are they away etc…. Read more

SQL Server 2008 Geometry Data

One of the problems with our TechNet road shows is getting at the content after the event.  Of course we do provide the slide decks, but these can be abut thin as many IT Pro’s (including us!) are power point averse, preferring see stuff in action.  We can record it all but I am not… Read more

SQL Server 2008 & Virtual Earth

There’s a lot of buzz around Software plus Services (S+S) from Microsoft and others.  It’s all very simple as Eileen will tell you -  it’s when you use a service like GPS that’s remote and public and combine it with some software like CoPilot or TomTom on your GPS to find directions.  In a similar… Read more

SQL Bits Conference Calling

This is a short post to say thanks to all the MVP’s working hard to organise the next SQL Bits conference on 1 March (register here). Tony, Chris, Simon Darren, Allan and Martin and the rest of the SQL Server Community know exactly what’s like to plan this when they’re scattered across the UK and… Read more