Browse by Tags

SQL Server 2008 Upgrade Technische Referenzhandbuch

Der SQL Server 2008 Upgrade Technische Referenzhandbuch wurde jetzt verfügbar. In diesem 490-Seite Whitepaper behandelt die wesentlichen Phasen und die Schritte aus, um vorhandene Instanzen von SQL Server 2000 und 2005 auf SQL Server 2008 zu aktualisieren, mithilfe von best practices. Dazu gehören Vorbereitung...

Posted to External News (Weblog) by Anonymous on 11-30-2008
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...

Posted to External News (Weblog) by Anonymous on 11-21-2008
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...

Posted to External News (Weblog) by Anonymous on 10-21-2008
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...

Posted to External News (Weblog) by Anonymous on 10-20-2008
SQL Server backup & restore across versions

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 and stored procedures are going to work, so...

Posted to External News (Weblog) by Anonymous on 09-07-2008
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...

Posted to External News (Weblog) by Anonymous on 08-12-2008
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...

Posted to External News (Weblog) by Anonymous on 04-14-2008
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...

Posted to External News (Weblog) by Anonymous on 03-28-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...

Posted to External News (Weblog) by Anonymous on 03-25-2008
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...

Posted to External News (Weblog) by Anonymous on 03-12-2008

Page 1 of 1 (10 items)