Insufficient data from Andrew Fryer

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

Lab Ops 2–The Lee-Robinson Script

In my last post I mentioned how Marcus Robinson & had adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way.  With Marcus’s permission I have put that Setup Script on SkyDrive, however he has a proper day job running his gold partnership… Read more

Microsoft Valuable Penguin

I sometimes think the IT industry is a bit like a load of penguins on the pack ice, each one checking the others out to see who going to brave the ocean first.  In IT it’s nervousness about when to jump onto a new technology and if there is one technology that makes IT professionals… Read more

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

Installing SQL Server in a Virtual World

I do get occasional feedback that SQL Server is hard to install, all those screens all those checkboxes etc. etc.  This is simply a reflection that there is so much in SQL Server aside form the database engine, however if you know what you want and you are doing this regularly then script it, if… Read more

Virtualizing Tier 1 SQL Server

A while back I published a couple of posts on virtualizing SQL Server, and in the light of developments in both the virtualization platform out there and SQL Server itself I feel the need to do a complete rewrite.  The traditional approach to implementing high availability (HA) in SQL Server has been to create a… Read more

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

Server 4024 part 2 – Management

In the second post in this series I wanted to look at how changes to the way you manage things in Windows Server 2012 (WS 2012) affects your management of SQL Server 2012 (SQL 2012). Multi Server Management Traditionally to manage the OS we used to remote desktop onto every server we managed and applied… 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

Evaluate This – Storage Spaces

So far in this series I have used the new storage features of Windows Server 2012 as a  place to run VMs from, but there’s more to it than that.  Shared storage used to mean presenting SAN storage inside a cluster, and you relied on your SAN experts to provision the storage you needed.  However… Read more

MCSE for SQL Server

I have to be honest I gave up getting certified before I joined Microsoft mainly because the exams didn’t keep up with the release of SQL Server specifically the Business intelligence exams. I then had the same problem as an evangelist I was working on the next release of the SQL or Windows Server. However… Read more