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

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

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

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

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

Getting Started with SCOM 2012 beta

System Center Operations Manager (SCOM) 2012 is now in beta along with all of the other System Center 2012 suite, and because it’s a beta the installation process is a little tricky. Having spent a morning on it I thought it would be good if I told you what I did so you don’t have… 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

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