Ten reasons why you should upgrade to SQL Server 2005

Daily Newsletters

Sign up to ZDNet UK's daily newsletter.

...various front-end applications (C++, VB, Delphi, Access, Crystal Reports, etc.). You can roll this into Reporting Services with enormous advantages. First, you take all of the logic out of the given front end. Then, you can use Reporting Services from virtually any front end, which means that your application developers can remove a lot of code from the applications. There's one report for all possible UIs, which means that if there's a bug in the report, you fix it once and all the UIs inherit the fix.

6. Business Intelligence is built in.
Business Intelligence was not built in previous versions of SQL Server, unless you purchased the Enterprise edition of SQL Server 2000. Even if you could afford this, you had to master a whole new interface. Using SQL Server 2005, you can do everything you could before, using a clean and integrated interface.

7. Bid adieu to DTS and say hello to SSIS.
SQL Server 2005 completely replaces DTS with a new technology called SSIS, which is a quantum leap forward. We think the coolest part of SSIS is that the data transformation is now an SSIS object. Finally, you can really do flow control and error handling by building tasks outside of the extraction, transformation, and load operation.

8. Upgrade wisely using the Upgrade Advisor.
SQL Server 2005 has introduced new features and changed existing features to help improve performance, security, and manageability. These changes may affect your existing applications. This is why Microsoft's SQL Server team developed the Upgrade Advisor, which intelligently guides you through the upgrade process and points out any compatibility issues that might arise.

9. You now have granular security at your fingertips.
With the addition of the proper database schema, and the ability to assign some administrative tasks without making every developer and junior DBA a full Senior Architect, you can greatly increase the security of SQL Server 2005 by giving users only the rights they need to do their jobs. (Admittedly, some developers might not see this as a good reason to upgrade.)

10. Benefit from enterprise scalability.
SQL Server 2000 has issues when it comes to enterprise scalability, but this is now a thing of the past with SQL Server 2005. It looks like SQL Server 2005 is ready to hold its own against Oracle and DB/2 for the enterprise. It is also significantly cheaper than either Oracle or DB/2 no matter how you measure the cost (whether it's per processor or per seat).
Summary

Even if you have no immediate need to migrate from SQL Server 7 or 2000, you should install SQL Server 2005 because the benefits are huge. You can continue to administer SQL Server 2000 databases without converting them, and also enjoy the cool new extensions in SQL Server 2005. An hour into the new SQL Server Management Studio will persuade you to forget all about Enterprise Manager and Query Analyzer. They will seem as old as CP/M.

Talkback

TOP 5 Reasons NOT to UPGRADE to 2k5

1) MS Project Server not Compatible

2) MS MOM not Compatible

3) MS Share Point not Compatible

4) MS Live Communication Sever not Compatible

5) MS WSUS not Compatible


Now I say "NOT Compatible" this is in regards to Microsoft's official response. Sure it "May" work in different secanrios, but if MS will not support it, then it cannot go into production in my network. So what is the point of upgrading?


LCS, MOM, and Share Point will be fixed soon via a service pack. the others are unknown at this time.

via Facebook 13 March, 2006 14:30
Reply

In your point about enterprise scalability, it might be worthwhile to mention Service Broker, a new paradigm for building asychronous, distributed applications. Service Broker adds service orientation, asyc execution, reliable messaging and transactional queueing right into the database engine. It forms the platform for other features like event notifications, query notifications and database mail. See http://www.sqlservicebroker.com/ for more.

via Facebook 15 March, 2006 01:24
Reply

I went through a # of issues with performance when upgrading from SQL Server 2000 to SQL Server 2005.
I compiled them all (and the solutions) here ... hopefully this helps:
http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/28/477.aspx

via Facebook 30 April, 2006 08:36
Reply

Post your comment

In order to post a comment you need to be registered and logged in.

You can also log in with Facebook. Log in or create your ZDNet UK account below

  • Login

Will not be displayed with your comment

By signing up for this service, you indicate that you agree to our Terms and Conditions and have read and understood our Privacy Policy. Questions about membership? Find the answers in the Community FAQ

Get ZDNet UK's daily newsletter

Enter your email address to sign up

ZDNet UK Live

bordero

ike fuelband is great for every healthminded person ! to work out! theres this website called textme4free.com that you can use to text anywhere in...

10 hours ago by bordero on Nike's FuelBand wristband gamifies exercise
BrownieBoy

> I'm told it's somewhat annoying when people have their Macs stolen > and Apple stores treat the thief as the owner, but there you go. Ouch,...

12 hours ago by BrownieBoy on AMD Ultrathins to challenge Intel Ultrabooks
Moley

@kevinmchapman. OK, I acknowledge that 'most' was a gratuitous throwaway comment as an afterthought and too presumptuous. As to proof, as you...

16 hours ago by Moley on A tale of two distros: Ubuntu and Linux Mint
Jack Schofield

@BrownieBoy > Works really well for thieves.... >> Nice attempt to deflect the argument by tossing in a point that's totally >> irrelevant, even...

18 hours ago by Jack Schofield on AMD Ultrathins to challenge Intel Ultrabooks
raskolnikof

fantastic that the so called piracy bills have been withdrawn. however, these anti-democracy supporters are still in the shadows so lets be alert...

18 hours ago by raskolnikof on SOPA, Protect IP support wavers in face of online protest
Tony Douglas

Please God no; teach them anything you like - thinking rationally, the uses and misuses of data, what data is and what it's not - but leave the...

21 hours ago by Tony Douglas via Facebook on Kids are the future. Teach ’em to code.
BrownieBoy

@Jack, > Works really well for thieves.... Nice attempt to deflect the argument by tossing in a point that's totally irrelevant, even it were...

1 day ago by BrownieBoy on AMD Ultrathins to challenge Intel Ultrabooks
bootlegger

Make that 13 people now - I got refused today at Manchester airport. I thought I was up to date on this legislation - I knew of the EU ruling from...

2 days ago by bootlegger on UK airport body scans will not be opt out
tinycg

Don't forget to check out apps like GoodReader or SlideShark either, they're indispensible for people on the go in presentation situations. Best...

2 days ago by tinycg on Four top iPad apps for people on the move
TerryRK

Well it seems there is something a number of us agree on. Why is the Ubuntu Unity launcher so ugly? I thought perhaps it was something to do with...

2 days ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
Freebies202

Duplicate comments are not made intentionally. Its very good to know that now you are keeping check on this problem because sometimes a commenter...

2 days ago by Freebies202 on Microsoft fixes blog comments, speeds up blogs with open source
kevinmchapman

"the very significant number of users" and "many (most) of us" - you have no evidence for these statements. It is a fact that most users are saying...

3 days ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
Marg Menzies Harrison

Another grammar faux pas is the improper use of "you". When sitting down down in a restaurant, for example, I get cringe when the waitress...

3 days ago by Marg Menzies Harrison via Facebook on 10 flagrant grammar mistakes that make you look stupid
zdnetukuser

And NOW, folks, for Canonical's next trick... Kubuntu is late. Here's a pencil. Draw your own conclusions. cf.:...

3 days ago by zdnetukuser on Linux Minterface
Moley

@kevinmchapman. The discussion here reflects the very significant number of users who really do like the traditional menu system and who wish to...

3 days ago by Moley on A tale of two distros: Ubuntu and Linux Mint
kevinmchapman

Er, no... It is an efficient means of finding the application/file/setting you need in one place. The icons are a simply a fallback for when you...

3 days ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
TerryRK

Isn't the provision of a text based search an admission by the developers that the mass of icons approach does not work? I don't need to use a...

3 days ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
kevinmchapman

"Unity and GNOME 3 both abandon the old text-based cascading menus in favour of a graphical icon-driven system." Point truly missed. Both use a...

3 days ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
TerryRK

whs001 - Thank you, I'm glad you liked the article. I absolutely agree with you on your first point. I should perhaps have made it clearer that...

3 days ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
Dennis Nilsson

If we allow corporate interest to dictate the way our government circumvents due process against foreign entities then we should accept the same...

3 days ago by Dennis Nilsson via Facebook on ACTA stumbles in Germany