November 24, 2008 at 9:30 am
Hi there,
I'm starting to look @ moving from SQL 2000 to SQL 2005, I'm afraid not SQL 2008 due to 3rd party apps.
Can anyone recommend and good books which deal with SQL 2005 best practise, design and implementations that whey have used or currently using.
Thanks
November 24, 2008 at 10:59 am
November 24, 2008 at 11:13 am
There are a ton of SQL 2005 books ranging across many topics. The Inside series are some of the best. Are you looking for info on the new features in SQL 2005 or actually wanting a SQL Server 2005 DB Design booK?
SQL Server 2008 is not that much different than 2005 from an engine perspective, so I would be surprised if an app could run on SQL 2005, but not 2008. In fact, I think many would agree that SQL 2008 is probably better than 2005 in many regards based on its additional features.
For SQL 2005 books, check out the Inside Microsoft SQL Server 2005 series. For a good DB design book, look for Louis Davidson's book on SQL Server 2008 (or 2005) Relation DB Design and Optimization.
November 24, 2008 at 11:17 am
Another vote for the Inside series of books. Fantastic stuff in there. Other than that, no other books come to mind as absolute must reads. You start to get into, what do you need? For example, for Reporting Services, I enjoyed Brian Larson's book.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
November 24, 2008 at 11:21 am
Jared Hunt - SQLAddict (11/24/2008)
SQL Server 2008 is not that much different than 2005 from an engine perspective, so I would be surprised if an app could run on SQL 2005, but not 2008. In fact, I think many would agree that SQL 2008 is probably better than 2005 in many regards based on its additional features.
The issue would be support by the vendor, going to SQL Server 2008 before they say their app will work properly with that version, you could lose support. We didn't move our PeopleSoft applications to SQL Server 2005 until they supported SQL Server 2005 for the database server.
November 24, 2008 at 11:30 am
Lynn Pettis (11/24/2008)
The issue would be support by the vendor, going to SQL Server 2008 before they say their app will work properly with that version, you could lose support. We didn't move our PeopleSoft applications to SQL Server 2005 until they supported SQL Server 2005 for the database server.
Agreed. We've had the same issue all over the place. It's a shame though, 2008 really is a bit better than 2005. We're going to skip over 2005 with as many of our 2000 upgrades as we possibly can from here on out.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
November 26, 2008 at 7:44 am
Hi there, thanks for your comment, I'm looking for a SQL 2005 book that looking into database migration ( upgrade & side by side upgrade from version 7 & 2000) also initial database setup, ie database size and log size plans.
November 26, 2008 at 9:43 am
Wilko (11/26/2008)
Hi there, thanks for your comment, I'm looking for a SQL 2005 book that looking into database migration ( upgrade & side by side upgrade from version 7 & 2000) also initial database setup, ie database size and log size plans.
In that case the Technical upgrade reference guide should be exactly what you need. And with 300+ pages you might call it a book.
[font="Verdana"]Markus Bohse[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply