Insufficient data from Andrew Fryer

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

Browse by Tags

Related Posts
  • Blog Post: End of the Road for SQL Server 2000

    Microsoft will be turning off mainstream support for SQL server 2000 for most editions of the product in April 2008: Products Released General Availability Date Mainstream Support Retired Extended Support Retired SQL Server 2000 64-bit Edition 30/11/2000 08/04/2008 09/04/2013 SQL Server 2000 Developer...
  • Blog Post: SQL Server 2008 not just for DBAs

    I am sure SQL Server is administered by many ‘accidental’ DBAs i.e. IT Professionals who get saddled with looking after databases, while performing a bunch of other infrastructure management tasks.  One of my good friends Jonathan Noble at Newcastle University is one of these and so I thought it...
  • Blog Post: Must have tool for Migrating Access to SQL Server

    I have a love hate relationship with Access for the same reason, it’s seductive simplicity.  You can knock up an application in no time, which my wife did recently to learn the tool and to keep track of our extensive book collection.  That quick start and get going appeal, starts to pail as...
  • Blog Post: Farewell old friend–time to say goodbye to SQL Server 2005

    It always nice to see historic aircraft , and vintage cars out and about rather than stuck in museums, the noise and even the smell of castor oil add to this nostalgia. However keeping them going requires a lot of effort  and keeping them current with modern rules means that a Fokker triplane will...
  • Blog Post: SQL Server versions side by side

    There are occasions where you need multiple versions of SQL Server running at the same time and you may not have sufficient hardware to run them on separate machines. The traditional approach to this is to run an instance of each version, in fact I have one demo rig which has an instance of SQL Server...
  • Blog Post: Moving to Hyper-V

    I am being asked more and more often about how to move virtual machines onto Hyper-V and so I wanted to do a definitive post on the tools and techniques to do this.  Whatever your reasons for doing this you’ll want to ensure your users have a good experience post migration and the secret to this...
  • Blog Post: SQL Server, Lies Damn Lies and Statistics

    I see Oracle have published a couple of papers recently on how easy it is install, configure and manage Oracle 11g vs SQL Server and DB2. The work was commissioned from the Edison Group and the paper on the Oracle / SQL Server comparison is available here .  When I read this I was reminded of one...
  • Blog Post: SQL Server Migration

    I knew that there was a toolkit to help move an application from Oracle to SQL Server, but I hadn’t appreciated that there was one for Sybase and Access these also now come in two flavours, one to move you to SQL Server 2005, and one for SQL Server 2008: SQL Server 2005 Migration Assistant for: ...
  • Blog Post: 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,...
  • Blog Post: 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...
  • Blog Post: Just the Facts

    I spent the first part of my career working IT for various UK government departments, and in every case we had exacting methods for working out the total cost of ownership (TCO) of any IT system we acquired, the point being it was our model based on the way IT is run in our organisations.  This...