Transcript Slide 1
Recap of SQL Live and SQL PASS Conferences 2002 12/09/2002 Erik Veerman Dave Fackler Douglas McDowell SQL Server Magazine Live! • Sun, Oct 27 to Wed, Oct 30 • Hyatt Grand Cypress Resort, Orlando, FL • Held in conjunction with – ASP.NET Connections Conference – VS.NET Connections Conference • Innovator Cup Awards Keynotes and Seminars • Keynote Sessions – Visual Studio.NET Roadmap – SQL Server: Today and Tomorrow • Pre-conference Seminars – – – – ASP.NET Jumpstart Create a VS.NET Application in a Day Hands on C# ADO and ADO.NET Programming and Performance – TSQL for Administrators – Tuning High Performance SQL 2000 Databases – COM+ Enterprise Services and .NET Conference Sessions • Three SQL Server tracks: – Administration and Architecture (24) – ADO and Application Development (17) – TSQL and Server Side Development (16) • Access to ASP.NET and VS.NET sessions – – – – Visual Basic (36) C++ (18) C# (13) ASP (39) Highlights • • • • • SQL Server CE Development Log Shipping and Replication Security Database Performance ADO and ADO.NET Programming • XML • Data Warehouse, DTS, Analysis Services PASS Community Summit - Seattle • November 19-22, 2002 • Washington State Convention & Trade Center • Seattle, Washington YUKON debrief Gord Mangione, VP Microsoft SQL Server Bill Baker, General Manager SQL Server Peter Spiro, Distinguished Developer YUKON BI OLAP and Data mining • BI Dev Workbench • ETL • Management Tools • Best Practices and Partnerships ACT III! • Act I = OLAP • Act II = Data Mining • Act III … YUKON BI ACT III ??? YUKON BI “…Abilities” Scalability, Serviceability, Manageability, Securability, Usability Scalability • Centralized calculations on the server – Less network traffic – Simple to maintain • Cached MDX Calcs • Disk based dimension storage (150 Mil members tested) • 10X performance increase on write-back YUKON BI “…Abilities” Securability • Every line of code reviewed in May (2K sp3) – Secure by default (disable http anonymous) – Fine grain admin permissions – Service runs at lowest security level • Encryption – Pipe, password, local cubes • Signed binaries • Audit YUKON BI “…Abilities” Manageability • Integrated with relation engine – Single shell FE, Query Editor supports MDX, SQL – Profile OLAP (connections, actions, stats, usual) – Integrated Backup/restore • Development – Development lifecycle (dev-test-prod) – XML based DDL, stored procedures • Analysis Management Objects – ASO (Replaces DSO) • MDX Debugger – Visualize calculation logic – Debug logic… step by step, check calc logic YUKON BI “…Abilities” Availability • • • • Failover clustering “in the box” Multi-instance Server staging Back-up and Restore – NOT Archive and restore! – No more 2 Gb limit • XML for Analysis (XMLA) – – – – The way that A.S. interacts with clients Native server protocol, not PTS Enables integration with other AS servers Available now. YUKON BI “…Abilities” Serviceability • • • • Trace events Flight recorder – last “n” events Capture and replay events Dr Watson • Backward compatibility – Full support for MDX, ADO MD, OLE DB – Migration tools – Side-by-Side integration YUKON BI “…Abilities” Usability • Usability studies • Focus Groups • Site visits … YUKON RDBMS Programmability • Goals – Enable developers to take advantage of existing skills – Provide end-to-end development tool • Common Language Runtime (CLR) – – – – – – Infrastructure integration (memory, threads, SQL types) Functions procedures, triggers User defined types, aggregations in-proc data access symmetric data access )mid-tier/data tier deployment. Tight integration with (AUTHORING, DEBUGGIN, PROFILING) YUKON RDBMS Programmability • XML – Structured/semi-structures data documents – XML data types • (first class citizens, columns, variables, parameters of the XML type can be associated with XSD… not just a char column) – X-Query (standard optimizations/storage) – Native Web Services (HTTP, soap protocal) – Web service YUKON RDBMS Programmability • T-SQL enhancements – Varchar(max), date, time – Recursive queries (ANSI) (“bill of materials” types of queries) – Exception handling (for transaction abort) – Query notification (notify when the results of the query change) – Mid-tier cache invalidation – Multiple active result sets (single connection allows multiple requests in the server) – Query notifications YUKON RDBMS Data Management • Security – Implementation robustness, more precise control – Row level security, user/schema separation, – Flexible server roles, all permissions grantable, tools documentation • Availability/Scalability – – – – Online operations (create index, restore) Support for high-end failover clustering operations Scale up operations (target 64 proc machines) 64 bit operations support for Itanium 2 family • Available in SQL2K SP3! YUKON RDBMS Data Management • Manageability (differentiate from other systems) – Innovative management tools and object models – Awareness and auto-reporting of problems – Comprehensive logging and playback to isolate issues. • Futures • (MSFT realized that database technology is really useful thing!!) – VLDB, RAS, Query capabilities • (available to many storage areas... file system, Exchange, etc), – Self managing – Unified Storage – Synergy between data triangle • Personal data • Internet data • Business data YUKON RDBMS Application Example • VB code created with visual studio – “create assembly”... to point to the dll • security is defined by permission buckets. • Stored procedure calls the assembly – “create HTTP Endpoint” … to create a web service • allow the procedure to be accessed outside SQL • Algorithm on the XML data – – – – Created a user defined aggregate based on the CLR Consume multiple rows into a scalar value XML loaded into the DOM Extract the data and run the aggregation • Takeaway – Integrated into system Conference Sessions • 200+ members of the Microsoft SQL Server Team including product managers, developers, testers, and members of the support team • Over 100 Technical Sessions focusing only on SQL Server • More than 80 MVP, Microsoft and user-expert presenters • 30+ leading complementary solution providers on our tradeshow floor Conference Sessions • 11 full-day SQL Server seminars • 10 Ask the Expert topics and 3 Q&A Panel discussions, moderated by Microsoft • The most detailed preview of Yukon for months to come. Highlights • Yukon • SP 3 Beta • Access to Microsoft Development Team • Ask the Experts Next Year • November 11-14, 2003 • Washington State Convention & Trade Center • Seattle, Washington BE THERE!