Insufficient data from Andrew Fryer

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

Governance, Risk Management & Compliance

Blog posts which just reference whitepapers etc. can annoy some of you so I try and limit these, but if you are one of the many IT managers or DBA’s worried about compliance then please read on. The IT Compliance Guide   is a comprehensive guide to all of those annoying acronyms that seem to get… Read more

SQL Server 2008 Cluster on Windows Server 2008 in Hyper-V

I remember the old batman shows had a “don’t try this at home” disclaimer after every show, and this came to mind as I started playing with Windows Server 2008, Hyper-V and SQL Server 2008  on my new shuttle PC (4 cores, 8gb RAM, 1TB on three disks) Here’s what I’ve done Installed Windows Server… Read more

SQL Server 2008 Filestream FAQs

I get a lot of questions about how filestream works with the other new features in SQL Server, so here’s what I know. First for those that don’t know, filestream is a new data type in SQL server 2008 that  handles large unstructured data files like they are in the database. The clever bit is… Read more

Security Update MS08-067

There’s no easy way to say this but whatever version of windows you are running, the first thing you want to do today is install update MS08-067.  To quote from the article… This security update (MS08-067) resolves a vulnerability in the Server service that affects all currently supported versions of Windows. Windows XP and older… Read more

Help for Small Business

It’s good to see that the government has noticed that small business are essential to the lifeblood of the British economy and are putting in measures to ensure that they are paid within 10 days of submitting a bill to any public body.  Even the Sun is getting behind small businesses, and encouraging us all… Read more

SQL Server 2008 Notification Services

Notification services is one of the deprecated features in SQL Server 2008, essentially it is supported for now but will not be in the next release of SQL Server. If you are using notification services currently and you are looking to upgrade to SQL Server 2008 then you can get it from here. But why… Read more

Report Builder 2.0 released

Typical, you spend a day off line at a team building exercise and then you find that the SQL Server team have released Report Builder 2.0 to a fanfare of silence.  To rewind a bit Report Builder 2.0 sort of replaces Report Builder 1.0 that came with SQL Server 2005.  The two tools are as… Read more

Barriers to upgrading to SQL Server 2008

Most IT Professionals like to use the latest (stable) version of a product, so what’s holding up your adoption of SQL Server 2008? Hardware. If you are moving from SQL Server 2000 to 2008 that’s probably going to mean a new server as you’ll probably want to move to 64 bit hardware and that could… Read more

SQL for Girls

My good friend James has coined a phrase “Work is what we do, not somewhere we go”, so I have just got off the phone to my niece who asked me to explain databases for her homework.  It reminded that I used to ask my IT dad what he did and he never really exactly… Read more

Virtualization Unplugged Tour

I know many DBA’s have strong opinions on the pros and cons of virtualization especially when applied to SQL Server in a production environment, but I am concerned that a lot of myth and uncertainty surrounds the topic.  If you want to find out from the experts, and form your own opinion then I would… Read more