TechEd 04: DAT317 SQL Server 2005 (code named "Yukon"): Setup and Deployment
Speaker is Mike Maringas. Great opening and a very personable style.
- Unified install experience
- Goal is to an unified and integrated experience
- Instance names clashing problems are getting address. Starting with B2,
single package per unique instance and per product feature. Solution
involves using an alias.
- Demo of the installation progress
- Service Packs by feature (AS, NS, etc) makes is possible to just patch a
service without affecting other services and means smaller service pack
downloads.
- 64-bit beta BI and DTS after Beta 2.
- Scripted installs for beta 2
- Cluster Analysis with GUI
- Slip streaming of services
- Patch management story is much better
- WUS supported
- Based on MSI 3.0 which has patch uninstall
- Talked about Setup Configuration Check which helps prevent failures
- Install failures hook into Watson
- Some discussion of dynamically updating help
- Cluster installs
- 8-node cluster supported in Yukon
- All machines are treated as a distributed transaction
- No upgrade for MSDE yet
- SQL 2005 can upgrade 2000 Enterprise, Developer and Pro with SP3.
English and Japanese, running on X86, IA64 and AMD64
- NO NEW MDAC BITS
- Good efforts made a minimizing total downtime during the upgrade
process. Full-Text might be a lazy upgrade.
Informative presentation. Looks like they have spend a good amount of time
working on making this a smooth process.