Insufficient data from Andrew Fryer

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

How to train your MAML – Looking at the data in SQL Azure

In my last post we saw how to clean, transform and join datasets. I also mentioned I had trouble doing the join at all and even now it’s not quite right so how can we look at the data and find out what’s going on.  The visualisation option only shows a few rows of the… Read more

System Center Advisor– now live

I remember hearing about a Project Houston about a year ago, a cunning plan to allow Microsoft to check the heath of your SQL Server databases and the operating system it sits on. It is now live and it’s called System Center Advisor. It works by using an internet gateway server you setup which in… Read more

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

SQL Relay

I am in the middle of SQL relay this week, but I just realised that you might like to have a copy of my Denali slide deck, which I have now posted to SkyDrive. You are welcome to have a look at it even if you couldn’t make one of the four venues I am… Read more

SQL Bits 11 – Notes & Queries

If you didn’t manage to fight your fight your way through the Everton & Liverpool fans to SQL Bits I thought you might like to see some of the random questions I got asked.. How do I manage SQL Azure? I think the key thing about developing for the cloud is to ensure that your… 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

Notes & Queries from TechDays 2011

I have been at TechDays Live all last week and although I did a bit of presenting, I was mainly there to listen and keep the week running smoothly.  I scribbled down a few notes during the various sessions I was in which I thought might be of interest: Easyjet have an amazing set of… Read more

SQL Azure Update

The annoying thing about cloud services like SQL Azure is that they keep changing as more features are added. The great thing about cloud services like SQL Azure is that they keep changing as more features are added. So if I write post about version x of SQL Server that has some value while that… Read more

Help stamp out SQL Server neglect

eI am thinking of starting a new royal society the for the protection of cruelty to SQL Server as I am seeing my favourite database suffering a lot of abuse out there as part of the blind rush to virtualisation.  A good example is, Gillian,  a dba I met at SQL Bits who was nearly… Read more

Event Handling for the IT Professional

My diary is solid for the next few weeks as there seem to be a lot of events on. This is good for me as the best bit of my job is swapping ideas and stories with like minded individuals, not to mention the odd lively debate.  I also get the impression that many of… Read more