Follow up Questions from Day 3 - Edmonton
Wow we had an unbelievable turnout in Edmonton. A packed house until the end with some great questions. So many questions in fact during the Q+A and Ask the Experts in the cabana that I had a hard time keeping track of them all. I'm in transit in Calgary on my way to Victoria but I'll post some of the most common questions before I get on the plane.
Q1. What's the impact of using the new Administration environment in SQL Server 2005 against existing SQL 2000 environments? Anything I should be aware of?
SQL Server Management Studio is the replacement for Enterprise Manager and yes will connect against your existing SQL 2000 databases. You can install just the SQL 2005 Tools until you upgrade your SQL 2000 databases.
Q2. Do I need to upgrade my applications/ODBC/MDAC once I upgrade my database to SQL Server 2005?
Existing applications should function as they did before.
Q3. With the CLR integration in SQL Server, can a stored proc invoke an existing COM component(s)?
The short answer yes. More on this later.
Q4. What are the requirements for SQL Server 2005 on Windows 2000?
It depends on the version you are trying to install (Express, Standard, Enterprise etc...) as there is a base minimum for the OS (can't install the enterprise edition of SQL on Windows XP Pro [:)]. For SQL Server 2005 Standard edition.
- Microsoft Windows 2000 Server with Service Pack (SP) 4 or later
- Windows 2000 Professional Edition with SP 4 or later
- Windows XP with SP 2 or later
- Windows Server 2003 Enterprise Edition, Standard Edition, or Datacenter Edition with SP 1 or later
- Windows Small Business Server 2003 with SP 1 or later
For more information on the SQL Server edition/os combinations have a look here http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx
Q5. Does SQL Server 2005 support in term of web services and WSC 3.0?
Don't have the answer for this one - more on this later.
Q6. What's the story with replication services in SQL Server 2005?
If there is any doubts out there, yes the replication services are in the product and enhanced. There are some things to consider that could break replication once you upgrade to please have a look at the online books for SQL Server 2005.
Q7. Encryption of stored procedure in SQL Server 2005? Is it improved over 2000 and more secure?
running out of time so I'll follow up some of these items in a later post.
