Browse by Tags
All Tags » SQL Server » upgrade ( RSS)
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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 tomorrow! What this means is that SQL Server...
|
-
|
I want to mention another tool for obtaining a more thorough analysis of upgrade issues developed in conjunction with Scalability Experts and Microsoft, The SQL Server Upgrade Assistant (SUA). This tool is free but expensive. By that I mean that...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
|
|