Enjoy Every Sandwich : TechEd '04: DAT200 General Session: A 'Whistle Stop' Tour of SQL Server 2005

TechEd '04: DAT200 General Session: A 'Whistle Stop' Tour of SQL Server 2005

Encouraged us to really pay attention The SQL Business Intelligence Integrator
Talked about the new Best Practices Analyzer. New stuff in the RTM
- About 70 best practices
- It would be a great idea to run this now to see
- You can use Report Services to report against the data collected. Neat.
SQL Server 2005 is the start of the "Data Platform"
- Data Life Cycle
- All forms of data
Enterprise Data Management
- 10 "Terror Bytes" of data that needs to live in many places for many years and have it be usable.
- SQL Server has been 64-bit ready since 1998.
- MS has a 64-bit, 64-way, 1/2-tb of RAM that they are testing on.
- Lots of features designed to deliver very high uptime.
- Mirror (continuous log shipping) for very fast fail over
- Database snapshot
  - Read-only
  - Shares underlying data
  - Changes create a "copy-on-write"
- Talked about Dedicated Admin Connection and Dynamic Memory Views
- Security enhancements
  - Standard security honors host system policy about passwords
  - Encryption Support
    - Cell-level encryption supported
    - Can be password or certificate based
    - EncryptByKey and DecryptByKey
  - Off-by-Default.
Developer Productivity
- Different from JVM, the CLR is deeply integrated
- Hosting layer that handles Threads, Memory and Garbage Collection
- Visual Studio integration and debugging integration
- XML storage, schmea, indices, XML data access and complements SQLXML (well, no, it superceeds it)
- TSQL enhancements: Varchar(max) and Varbin(max), Try/Catch, Recursive Queries, MARS, Pivots and Top
- "The way to get at data"
- SOA support: Web Services support; Service Broker and Query Notifications
- SQL Web Services is not IIS.
- Service Broker: Asynchronous, distributed, decoupled programming environment.
- NO MORE MAPI FOR EMAIL.
- Observation was made by Bill Wolff "Means you don't need BizTalk with notification Services." That's not quite true, you still need BizTalk for transformation at least.
- Notification services "Don't call use, we'll call you," for the work unit result.
- Best practices white paper is in the works for T-SQL vs. CLR.
- System.SqlServer is now System.Sql
- Demo of using CLR to split strings vs. T-SQL. CLR stomped on T-SQL, but I bet Ihtak's method could have made a clean competition.
Business Intelligence
- DTS is a complete rewrite. New stuff is pipeline oriented. More than 100x more performant than current version
- Step-through debugging
- UDM is a cube with attributes
- Proactive Caching is the new power
- Six new data mining and two new text mining services
- Reporting Services gets AdHoc with the ActiveViews purchase. Won't be in B2, but may be B3.Self-service creation and so on.
- KATSU! The cynics reason that Whidbey and Yukon are joined at the hip -- so everybody knows has the same platform to work from. It is about doing more work with less different software.
SQL Server Management Studio replaced QA/Profiler etc.
SQLCMD and SQLiMail
Data Tuning Advisor and XML show plan
SQL development goes on in building 35.

posted on Tuesday, May 25, 2004 2:01 PM by ktegels

Enjoy Every Sandwich

Search

Navigation

Tools

List O'Links

Kent's Other Stuff

Subscriptions

News

Post Categories

Article Categories

TechEd '04: DAT200 General Session: A 'Whistle Stop' Tour of SQL Server 2005