Insufficient data from Andrew Fryer

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

Application Platform Knowledge Hub

Albert Einstein once remarked that you don’t need to remember everything, you just needed to remember where to look.  When it comes to learning about Microsoft products this can sometimes be harder than it ought to be and what resources there are can be fragmented so you do have to remember where to look.  That’s… Read more


Data Transformation Services is the bit of SQL Server that helped pay for my house, car and some really nice holidays.  I first got to use it some 12 years ago and after working with BCP (bulk copy program) it was just so easy, I was sucking data out of AS400/RPG, Oracle and Sybase to… Read more

Some SQL Server 2012 upgrade advice for ISVs

I have spent a lot if time recently briefing Independent Software Vendors (ISVs) on SQL Server 2012,so I thought a consolidated post on the subject might be useful for those planning to develop solutions on top of SQL Server 2012.  New Features that will just work By this I mean there are some new things… Read more

NO SQL Server

I spent last Thursday at Black Marble’s Architect Forum and my slot was on SQL, NoSQL, some SQL. It went down very well but I used OneNote on my tablet not PowerPoint and like all modern art my drawing needs a bit of explaining.. Databases were originally used to  store transactions which are highly structured, … Read more

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… Read more

Gone Critical

Many of us would associate the the term critical with the Register, so when I was asked by Tim Phillips their broadcast and commercial editor to join a discussion titled “Going Critical” I was a little nervous.  The title refers to some Register commissioned research by Andrew Buss at Freeform Dynamics on what Register subscribers… Read more

Reach for the Cloud – System Center 2012

  For me the most interesting stuff in the System Center 2012 is the cloud stuff.  Some of this is obvious there’s cloud button in Virtual Machine Manager (VMM)  2012, and there’s even a new product in the line up, currently called Concero that is totally cloud focused as you can see from this preliminary… Read more

SQL Server developer training kit–to useful to be just for developers

One of the few niggles I have about working at Microsoft is the way we try and put you the reader into pigeon holes, and an area where this fails for me is when it comes to SQL Server.  My developer friends won’t go near SQL Server unless they have to and this things like … Read more

OLTP performance in Denali – Less is more

I get the occasional criticism about SQL Server that all then new stuff is related to BI, and there isn’t anything for the traditional or grumpy DBA (aka Colin Leversutch Roberts).  Listening to Tom Casey  (corporate vice president within the Microsoft Business Platform Division)of  at the SQL Social last week, the only way to make… Read more

The 7P’s of projects

Proper Preparation & Planning Prevents Pathetically Poor Performance I mention this because the process of working out how to make changes to your data centre can and should take longer than doing the actual work.  For example if you are going to dive into virtualisation or do more with it, upgrade or migrate your database… Read more