Insufficient data from Andrew Fryer

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

SQL Server Spruce up

Landrovers, will take a lot of pounding and neglect, but when my wife drove hers to Australia she made very sure it was properly set up for 2 years on the road Similarly SQL Server is also often out in the wild far from DBA’s and inspection from maintenance tools, like System Center.  However now… Read more

Server 4024 part 1 – Virtualisation

A database is only as good as the operating system it resides on. SQL Server only runs on Windows and given that Windows Server 2012 (WS2012) is a huge change from what there was in Server 2008 R2 what does this new OS mean for the DBA.  The reference to Server 4012 is because that… Read more

Dear Diary

Good diary management is career mission critical at Microsoft and may well be the same for you and if it is I have some free stuff for you to try. The Microsoft BI team have issued a calendar analytics spreadsheet that shows you how you are spending your time. It works by connecting to exchange… Read more

Project Atlanta part 1 – Introduction

In the post Christmas rush to get fit the well off will have personal trainers assigned to them to help get back into shape. Similarly in the world of SQL there is an abundance of experts to help ensure that SQL server is as lean and mean as possible, however not everyone can afford that… Read more

Just because you can doesn’t mean you should, mixing Hyper-V and other applications in Windows Server

I have got the highest respect for Hyper-V. It’s simple to use I don’t need to learn any new interface (it’s just another mmc snap-in)  in which to mange the virtual world.  However when someone asks me if they can install other roles alongside hyper-V in production I say “Oi mate NO don’t do it”…. Read more

Thanks for the (dynamic) memory – Windows Server 2008 R2 sp1 beta

Although 16Gb laptops are out there I am making do with 8Gb, so any chance to get a bit more oomph out of it is always welcome and so I wanted to try the new dynamic memory capabilities in Windows Server 2008 R2. I am going out on a limb here because you shouldn’t use… Read more

SQL Server 2008 Performance Tuning

In an ideal world a database engine would self heal and self tune, and the SQL Server product team work long and hard on each release to try and realise this.  However in parallel with this they recognise that they can’t cater for every eventuality and so have provided more and more diagnostics and tools… Read more

SQL Server scalability?

Is SQL Server is only as good as the operating system – discuss The ability of SQL Server to make use of underlying hardware is often held up by the operating system, or to put it another way, pretty much as soon as there is support for some new thing the SQL Server team have… Read more

SQL Server upgrade perception and reality

I had two contrasting conversation about upgrade to SQL Server 2008 yesterday. A good friend of mine Darren is keen to use SQL Server 2008 for his new projects because he understands how it makes much better use of the many cores available on his new servers and works well with Windows Server 2008.  Conversely… Read more

SQL Server Advent Calendar 21 – Consolidation

Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Consolidation has become synonymous with virtualization, but even hardcore VMWare addicts and VMWare themselves advise that databases are one of the last targets of a virtualisation strategy.  Nonetheless SQL Server 2008 is being increasingly virtualised and for those interested in… Read more