DAT321 SQL Server 2005 (code named Yukon): Management Tools
Got to this session late as was having a great chat with Bernard Wong from
the Southern California district.
- Euan said it was important for them provide a great operational
experience for the administrators
- The support API mantra is "no secrets"
- New configuration tool is SQL Computer Manager, a one place stop for
managing all of services. All based on MMC. Will be available with MSDE
(thank you very much)
- Did a demo of SQL Server Management Studio
- Two modes: Connected or Disconnected. Connected by default in B2
(thank you!)
- Preconnect and prepopulate object explorer (thank you!)
- Can filter the server explorer tree (sweet)
- Task pane can run reporting services reports, so you can customize
what you see. If you have one of your own, share it with Microsoft. If
they like it and can use it, they'll put it in the product.
- Almost all dialogs are now non-modal
- Self-refreshing activity monitor windows
- Log Viewer allows merged viewing of NT Event Log and SQL Server logs
- Did a demo of the new Query Analyzer which looks kind of like a Visual
Studio screen
- Editor looks and feels
- No Intellisense for T-SQL (just couldn't get it working great)
- Show plan has a mini map that allows you visually navigate the plan.
- Jab back at the PC folks about it being a "blue X" on the loser of a
deadlock with the deadlock viewer
- SQL Server registration can load from a file of servers
- B2 won't have a debugger in SQLManStudio, but B3 will.
- Maintenance plan changes
- Make this sucker more transparent
- Demo failed, but it works like the DTS design surface.
- Demo of dynamic help. The very cool news is that SQLJunkies is a top
root integrator. Oh dear, I might be getting a ton of traffic.
- Profiler won't require SA any more! Kick butt.
- Good demo of SQL Command
- Very brief demo of SQL IMail. NO MAPI required. SQLMail is depreciated
and goes away in the version after the next version of SQL Server.
- Talked about Mercury (SQL Web Admin) This will be shared source
and released after B2.
Very good presentation. Too bad about the connection problems, but I love the
message of NO SECRETS.