SQL Server 2005 adoption

Microsoft Access
Microsoft Office
Microsoft Windows
SQL Server
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than SQL Server 2000?s Query Analyzer and Enterprise Manager? Do you think the changes to the security model and schemas will be a greater hurdle? How will you go about getting up to speed on the new features and functionality ? or do you feel you?re already pretty well educated? Are you prepared to upgrade in the next three months, six months, year?? Any feedback you can provide on your SQL Server 2005 adoption plans, concerns or training efforts would be greatly appreciated. Your comments may be included in a series of letters to the editor on SearchSQLServer.com. You may also e-mail me directly at Nbellistri@techtarget.com with additional comments or thoughts. Thank you for your time and attention.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I only just installed the SQL Server 2005 a few days ago, and haven’t had very much time to look at the setups yet.
However it seems to me, that the Management Studio works quite better and is at the first look very easy to use.
The basic functions for backing up, attaching and altering databases seems to work just fine!

The Diagram tool however has grown very poor! The GUI now has to leave room for one extra row at the bottom of each table in order not to show the vertical scrollbar – and showing the vertical often affects the horizontal space, also making this scrollbar appear! This is incredibly annoying! – why can’t they make a simple function to ‘shrink’ the table (in the diagram GUI) to the smallest possible size, and not showing the scrollbars for that reason? How hard can that be???
Also I experienced once, that although I’d saved several diagrams in my database, those diagrams dissapeared, once I reinstalled the server and re-attached the database-files. It seems the diagrams are not saved in the database itself, as they are in SQL 2000!

One thing is completely missing… The simple and fast interface from Query Analyzer from SQL 2000, when you only want to run basic T-SQL or like! For this purpose it seems to me, that there’s no reason to start up the entire Management Studio!

My experiences so far! 🙂

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Sriley
    Hello Nick...I work for a software developer, so generally our adoption of new platforms is driven by customer's intentions. We have been working with the '05 CTPs and so far I'm pleased with what I've seen. Like a previous poster, I would prefer to have Query Analyzer launch separately, but perhaps I'm just set in my ways. I do like the security/schema changes. T-SQL enhancements and .net integration are great. SSIS changes are a bit of a challenge, but so far so good. This tool just keeps getting better. I have not had the time to dig into Analysis Services, but associates at some customer sites are very happy with new functionality and better integration. I'm sure everyone will have their favorite enhancements but for me partioning is huge. It's about time!! Service Broker will definitely help us out with our complex web apps. Overall MS has done a very nice, if not spectacular, job with '05 in my opinion. Getting up to speed on all of these changes will be the biggest challenge. I look forward to reading others views.
    0 pointsBadges:
  • PurpleLady
    I am a developer as well as a DBA. While I am very interested in the new security model, I am very concerned with the conversion to SSIS since I am responsible for quite a few DTS packages that from my research will not convert using the tool. I also would prefer to be able to access query analyzer without using the Management Studio. Quite often I am multitasking using both tools - I guess I'll have to figure a way to do that. At this point in time, we don't intend to upgrade for at least a year - I've been through the hurdles of interfacing with our ISP running a different version and don't want to go there again.
    0 pointsBadges:
  • SQL Server 2005 adoption (Q/A) | Seek The Sun Slowly
    [...] Address: https://itknowledgeexchange.techtarget.com/itanswers/sql-server-2005-adoption/ (0) Comments Read [...]
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: