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

Philip Charles Cohen

Read about it and weep, John Donahoe ... In addition to Visa’s V.me, there is now MasterCard’s PayPass digital wallet soon to arrive; another...

2 hours ago by Philip Charles Cohen via Facebook on PayPal takes phone-based payments to the high street
apexwm

Leslie Satenstein : Where have you ever seen Mozilla even mention this? Firefox is the most popular browser in the GNU/Linux OS, so I don't see...

2 hours ago by apexwm on Firefox rapid release improves Fedora Linux
songmaster

SHleG: Do you remember building a clockwork scorpion kit (I'm pretty sure I have a photo of it somewhere) — I think it was called something like...

4 hours ago by songmaster on Software with everything
Chris Wortman

Good I love Yahoo! Their search engine is getting better than Google as of late. I find more of what I want on the first page, and usually within...

4 hours ago by Chris Wortman via Facebook on Linux Mint 13 ramps up for KDE release
PatrickG

openhgs has made the point for Windows 8 multiple monitors without realising it! With Windows 7 you have to switch the mouse and so your focus...

6 hours ago by PatrickG on Windows 8 could speed multi-monitor uptake
Leslie Satenstein

Mozilla has threatened to stop supporting Linux. I guess that UBUNTU is going with another browser. I indicated that if Mozilla stops supporting...

8 hours ago by Leslie Satenstein via Facebook on Firefox rapid release improves Fedora Linux
Andy Bolstridge

Much as I abhor Microsoft's licensing practices, this is almost certainly down to purchasing IT equipment via 3rd party consultants - you get the...

8 hours ago by Andy Bolstridge via Facebook on 6 million wasted licences and £1,200 PCs: welcome to government IT
Jack Schofield

@openhgs Windows users have had multiple desktops since Linus started writing Linux. They just haven't shipped as standard because not enough...

1 day ago by Jack Schofield on Windows 8 could speed multi-monitor uptake
Jack Schofield

@Phil at Cloud4 What, Microsoft gets £1,200 per PC and £1,622 per server? Gosh, I'm amazed....

1 day ago by Jack Schofield on 6 million wasted licences and £1,200 PCs: welcome to government IT
craigsc

You guys have no idea what is going on at Autonomy. Autonomy could have been a much more profitable organization. The sales operations at Autonomy...

1 day ago by craigsc on HP cuts 27,000 staff as Autonomy chief Lynch leaves
Moley

How does this impact on dual or multi booting? Seems to me to more or less prohibit this, from Windows 8 anyway. Will Grub 2 recognise Windows 8,...

1 day ago by Moley on Windows 8 start-up speed forces USB boot workaround
apexwm

I don't understand why there cannot be a slight pause during the boot process so the user can press a key. Many operating systems do this, even if...

1 day ago by apexwm on Windows 8 start-up speed forces USB boot workaround
Gavin Goodman

You can now buy the Xi3 modular computer in the UK at http://www.ocdistribution.com . This can be bought with the Tand3m software, pricing and...

1 day ago by Gavin Goodman on CES 2012: Xi3 microSERV3R
Phil at Cloud4

I agree: Mike Lynch can clearly build a business and manage strategy. I suspect the exit of Mike is more likely the end of a planned handover...

1 day ago by Phil at Cloud4 on HP cuts 27,000 staff as Autonomy chief Lynch leaves
Phil at Cloud4

This is unbeleivable government wastage with only one winner... Microsoft 1 - Tax payer Nil!

1 day ago by Phil at Cloud4 on 6 million wasted licences and £1,200 PCs: welcome to government IT
Mispam

So what do you do when you can't boot into windows? Why can't I just hold Shift while I power up instead of having to boot into windows and click a...

1 day ago by Mispam on Windows 8 start-up speed forces USB boot workaround
apexwm

I've also seen that Mac OS X for Intel machines is supposed to run in VirtualBox, which would also be a nice solution. I've never tried it though.

1 day ago by apexwm on xTreme Triple Booting: Linux, Mac & Windows
dave heasman

What I wonder is why when companies are caught bang to rights in not providing contracted services, people bend over to smear the customers? Surely...

1 day ago by dave heasman on Virgin throttles broadband for high-speed customers
pjc158

Strange statement from HP regarding Mike Lynch and not capable of scaling a company. Autonomy was a $7bn purchase which started as a small company...

1 day ago by pjc158 on HP cuts 27,000 staff as Autonomy chief Lynch leaves
lojolondon

Or - possibly, they will destroy business by ensuring people do not invest where there is no return. Another socialist idea, well beyond it's...

2 days ago by lojolondon on Open Data Institute will act as biz incubator