Insufficient data from Andrew Fryer

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

Merry Christmas and a Happy 2012

My Christmas card for 2011 is inspired by a frequent visitor to my back garden the Goldcrest.  The trick to seeing them is to resist the temptation to tidy up and dead head too much, whereas that’s exactly the sort of thing you should be thinking about in your data centre to keep it clean… Read more

Virtual machine density in your data centre

I can only run 11 server based  Virtual machines on my laptop, but all bar three of them are running SQL Server: 3 x VMs running SQL Server 2012 beta and the new AlwaysOn Cluster. Note one of these is running SQL Server 2012 on Windows Server Core 1 x VM running  SQL Server 2012… Read more

IT Camps

We aren’t all the same, we learn differently, we work in a wide range of business that have very different needs, and we learn at different speeds.  So spending a day being lectured to on technical stuff,  isn’t going to be the right answer for everyone and no matter how good the speaker is he… 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

Private Cloud–Nothing to see please move along

One of the reasons the term Private Cloud is getting a bad press is that it’s all marketing fluff and isn’t real. In any data centre you are going to be doing thing like.. deploying applications fixing applications performance tuning load balancing resource planning decommissioning applications patching and maintenance backup! …and you might also need… Read more

SQL Server 2012 – TSQL

I have to confess I hadn’t paid too much attention to the changes to T-SQL in SQL Server 2012, and it was only a question at NextGenUG in Abingdon last night that prompted me to have a look.  It turns out there are some really useful new commands, which I could certainly have done with… Read more

SQL Server 2012 – Always On

There have always been several ways to do high availability in SQL Server, but choosing the right one has always been difficult as each approach has obvious benefits coupled with unavoidable limitations: Clustering looks after a whole instance of SQL Server containing many databases and is completely transparent to an application. However shared storage adds… Read more

Anti-Virus and Hyper-V, Yes or No?

The parent operating system in Hyper-V is windows server and it’s a relatively simple matter to install your standard anti-malware tools on it, but is this a good idea? You can in fact install all sorts of applications and roles in the parent/physical operating system, and the guidance from Microsoft for production environments is not… Read more

SQL Server 2012 editions and dependencies

You may have seen that there are going to be some changes to the way SQL Server 2012 is licensed and the editions available, if you haven’t then the detail is here.  What I want to cover off in this post is what the various new features depend on so you are clear on what… Read more