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

Virtualisation and Interoperability

I often think that Microsoft is a bit like the English language, a lot of people speak it, a lot of people don’t and for many people it’s a second or third language they need for work e.g. air traffic controllers.  In technology few of us run a totally Microsoft environment, a few more will… 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

Microsoft Free Software – a personal top ten

You might think this will would make for a really short article post but actually  there’s a  huge amount of free tools and resource out there and I have had to restrict myself to a top ten across the server and client,  based on what Simon and I have used.  So please feel free to… Read more

HD Insight

Despite common misconceptions Microsoft now has extensive interoperability with open source technologies for example you can run a php application on Azure, get support from us to run RedHat, SUSE or CentOs on Hyper-V and manage your applications from System Center. ,  So extending this approach to the world of big data with Hadoop is… Read more

Microsoft, and Hadoop for Big Data

Despite common misconceptions Microsoft now has extensive interoperability with open source technologies for example you can run a php application on Azure, get support from us to run RedHat, SUSE or CentOs on Hyper-V and manage your applications from System Center. ,  So extending this approach to the world of big data with Hadoop is… Read more

Business Intelligence for the Private Cloud part 1

If you have looked at any of the new components of System Center 2012 you may have noticed that everyone seems to have a bunch of reports, some of them have data marts or data warehouses and some of them have analytics in the form of analysis services cubes.  Apart from the confusion over when… 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