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: Event: IT Camp Leeds Feb 28th

    Back in December Simon and I invited a few friends along to help us beta test a different kind of event, an IT Camp .  The idea is simply to do smaller, more interactive events where discussions and questions are encouraged.  The presenters, (Simon and I) being a bit more in the background...
  • Blog Post: SQL Server and Data Protection Manager

    I was busy recording session movies last week for a big TechNet event, hence the slip in blogging regularly. One of these was on the little known Data Protection Manager (DPM) a comprehensive archive and backup solution for the whole Microsoft platform including SQL Server 2008. But why a separate backup...
  • Blog Post: Dell and Hyper-V for the smaller business

    Over the last month I have been on tour with Dell showing what Hyper-V can do for small/medium businesses, and later this week I’ll be with them in Falmouth. The argument they put forward for Hyper-V is really simple: You want use a new server for virtualisation, and now that moderns servers...
  • Blog Post: 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 be tricky...
  • Blog Post: Some SQL Server 2012 upgrade advice for ISVs

    I have spent a lot if time recently briefing Independent Software Vendors (ISVs) on SQL Server 2012,so I thought a consolidated post on the subject might be useful for those planning to develop solutions on top of SQL Server 2012. New Features that will just work By this I mean there are some new...
  • 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: SQL Server 2000 upgrade follow up

    I just wanted to make sure that anyone watching my TechNet webcast last night has all the resources they need, but before I do that I also wanted make the point that Upgrade is a simple task for many environments provided you follow the advice in the resources below: The deck should be on the post events...
  • Blog Post: IE 9 it’s not an upside down IE6

    My first love is art and the great thing about my current role is that I can use my creativity to help explain what can be done with Microsoft technology.Just last week our marketing team decided to give me a whole stand to draw all over at the Web Directions event last week at the Southbank Centre in...
  • Blog Post: Farewell old friend – how to say goodbye to SQL Server 2000 Rescheduled

    My TechNet Live Webcast on upgrading from SQL Server 2000, has now been rescheduled for 3 March from 4-5pm.  If you can catch it live you can ping me and the TechNet team with questions during the webcast, but it will be available off-line (together with the inevitable slide deck) if you have other...
  • Blog Post: SQL Server Upgrade Advisor

    One of the things that made me smile at my launch presentation on upgrading SQL Server was that when I asked if everyone had heard of the upgrade advisor everyone in the room put their hands up. This is because most of the support issues raised by customers about upgrade use this template… DBA...
  • 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: Upgrading Data Transformation Services (DTS)

    One of the biggest headaches in migrating away from SQL Server 2000 is Data Transformation Services (DTS). The tool is very widely used and its initial simplicity no doubt contributed to that. A good example is of several Oracle sites where SQL Server was sat in a corner simply to move data between Oracle...
  • Blog Post: SQL Server Advent Calendar 24 – Upgrade

    It’s Christmas Eve and the last day of my virtual advent calendar on SQL Server 2008.. Hopefully the last 23 posts have given you some idea of what’s in SQL Server 2008 so I thought it might be useful to conclude with a word on upgrade. Firstly SQL Server 2008 has a lot in common with SQL server 2005...
  • 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: End of mainstream support for SQL Server 2000

    My first ever blog post was about the features of SQL Server 2000 that won’t work in SQL Server 2008, and as I have mentioned before , SQL Server 2000 will come out of Mainstream support today! What this means is that SQL Server 2000 will still be the subject of security fixes, and you can still get...
  • Blog Post: Saying Goodbye to SQL Server 2000

    I have published quite a few posts on how to upgrade from SQL 2000 to 2005/8 since I started blogging, but I still get asked a lot of questions about how and why so Alex (Editor of the TechNet Newsletter ) and I though an event might be in order. However this is a TechNet event with a difference in that...
  • Blog Post: Upgrading to SQL Server 2008

    Back on 19th March I did a presentation on upgrading to SQL Server 2008, as part of the UK Launch event in Birmingham.  I have now got the feedback from this session and I thought it would be interesting to share some of it.  Microsoft’s privacy policy is far more stringent than any organisation...
  • Blog Post: SQL Server Compatibility Mode

    I drew the short straw at the 2008 Launch event last week in Birmingham; speak for one hour on upgrading SQL Server.  I found this very difficult because on the one hand you can usually just do the upgrade, once you have done all the pre-requisite impact analysis and planning and also there isn...
  • Blog Post: SQL Server Lifecycle and Support

    My post announcing the next version of SQL Server picked up a couple of comments and rather than squeeze my reply in another comment I thought i would make it into a post. Most customers started adopting SQL Server 2000 in 2001/2. Back in those days my laptop had 256Mb RAM coupled with a Pentium P3 running...
  • Blog Post: Upgrading SQL Server Business Intelligence

    Continuing my series of posts on upgrade, I thought it might be good to have a look at the business intelligence components of SQL Server, so here’s a simple grid that I have adapted from Scalability Experts for use in the upgrade workshops and presentations I give: Along the top is the upgrade...
  • Blog Post: SQL Server upgrade perception and reality

    I had two contrasting conversation about upgrade to SQL Server 2008 yesterday. A good friend of mine Darren is keen to use SQL Server 2008 for his new projects because he understands how it makes much better use of the many cores available on his new servers and works well with Windows Server 2008. ...
  • Blog Post: 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...
  • Blog Post: Windows Server 2008 R2 Active Directory - Offline Domain Join

    I was in Leeds yesterday at the Virtual machine User Group.. Alan and I were handing out a few Windows Server 2008 R2 architecture posters, when Tom Howarth   a well known virtual machine expert, spotted the Offline Domain Join feature.  He thought this would be really useful in provisioning...
  • Blog Post: SQL Server 2012 editions and dependencies

    You may have seen that there are going to be some changes to the way SQL Server 2012 is licensed and the editions available, if you haven’t then the detail is here . What I want to cover off in this post is what the various new features depend on so you are clear on what else you need besides the...
  • Blog Post: When to Upgrade to SQL Server 2008

    Among the interesting stuff discussed at last nights SQL community meeting at the Microsoft Campus,was a lively debate on whether to wait for SQL Server 2008 sp1.  The traditional view has been to wait until sp1 because that is the stable release.  One wit in the audience suggested that SQL...