Browse by Tags
All Tags »
Upgrade (RSS)
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
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
Read More...
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
Read More...
This may be a short post in stating the [insert your favourite expletive here] obvious, but you can restore a SQL Server 2000 backup on a SQL Server 2008 database and that’s a good way to do a version migration. However that doesn’t mean your functions
Read More...
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
Read More...
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
Read More...
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
Read More...