Insufficient data from Andrew Fryer

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

Server 4024 part 3 – Networking

Databases are typically bound either by networking or IO and actually this can be two sides of the same coin if you are using remote storage.  So what’s new in Windows Server to improve networking both to improve access to shared storage and access to database workloads from another tier in a service or directly… Read more

Dell and Hyper-V for the smaller business

Over the last month I have been on tour with Dell showing what Hyper-V can do for small/medium businesses,  and later this week I’ll be with them in Falmouth.  The argument they put forward for Hyper-V is really simple: You want use a new server for virtualisation, and now that moderns servers can run ten… Read more

Event: IT Camp Leeds Feb 28th

Back in December Simon and I invited a few friends along to help us beta test a different kind of event, an IT Camp.  The idea is simply to do smaller, more interactive events where discussions and questions are encouraged.  The presenters, (Simon and I) being a bit more in the background.  The first of… 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

SQL Server 2012 and the private cloud

Putting up a marketing slide that says SQL Server is a good private cloud citizen is good marketing, but what’s in the box to back the claim up? My top three would be: Windows Server core.  Patching is a major maintenance problem with lots of virtual machines, and server core cuts that in half.  Getting… Read more

SQL Server HP Appliances & the modern data centre

There is a lot of advice on whether to virtualise SQL Server and many dbas are under pressure to do this.  There’s good advice here from SQL CAT on best practice on hyper-V and if you are in the business of acquiring hardware to run SQL Server virtualised then there are two reference architectures that… Read more

Back to Skool

Getting time, and resources to stay current with technology is always hard for IT professionals even when that training applies directly to your role.  If you are thinking of cross training because for whatever reason you can’t see a future in doing what you are currently doing then you’re probably going to end up investing… 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

Get your own best of the Microsoft Management Summit bits

Many of us couldn’t afford to make it Vegas for the MMS 2011 so in the UK last month the UK TechNet team put together a one day event Best of MMS and we managed to get quite a few of the US speakers over for that.  However that day was quickly sold out, and… 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