See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Application Lifecycle Management
Azure M eventsachine Learning
Azure Machine Learning
Data Protection Manager
Essential Business Server
Full Text Search
Microsoft Security Essentials
Performance Point Server
Read Only Domain Controller
Remote Desktop Services
Slowly Changing Dimensions
Software + Services
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server Express
TechNet Road Show
Windows Phone 7
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
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...
1 Feb 2012
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...
5 May 2009
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...
17 Jul 2012
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...
20 Oct 2008
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...
18 Jan 2012
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...
12 Aug 2008
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...
4 Mar 2009
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...
24 Jun 2010
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...
24 Feb 2009
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...
26 Mar 2008
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...
16 Mar 2011
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...
12 Mar 2008
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...
24 Dec 2008
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...
12 May 2009
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...
8 Apr 2008
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...
14 Jan 2009
Upgrading to SQL Server 2008
14 Apr 2008
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...
25 Mar 2008
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...
28 May 2009
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...
28 Mar 2008
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. ...
26 Jun 2009
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...
21 Oct 2008
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...
17 Nov 2010
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...
8 Nov 2011
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...
21 Nov 2008
© 2015 Microsoft Corporation.
Privacy & Cookies