1 / 25

Recap of SQL Live and SQL PASS Conferences 2002

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

yitro
Download Presentation

Recap of SQL Live and SQL PASS Conferences 2002

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Recap of SQL Live and SQL PASS Conferences 2002 12/09/2002 Erik Veerman Dave Fackler Douglas McDowell

  2. 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

  3. 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

  4. 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)

  5. Highlights • SQL Server CE Development • Log Shipping and Replication • Security • Database Performance • ADO and ADO.NET Programming • XML • Data Warehouse, DTS, Analysis Services

  6. PASS Community Summit - Seattle • November 19-22, 2002 • Washington State Convention & Trade Center • Seattle, Washington

  7. YUKON debrief Gord Mangione, VP Microsoft SQL Server Bill Baker, General Manager SQL Server Peter Spiro, Distinguished Developer

  8. 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 …

  9. YUKON BI ACT III ???

  10. 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

  11. 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

  12. 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

  13. 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.

  14. 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

  15. YUKON BI “…Abilities” Usability • Usability studies • Focus Groups • Site visits …

  16. 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)

  17. 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

  18. 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

  19. 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!

  20. 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

  21. 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

  22. 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

  23. 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.

  24. Highlights • Yukon • SP 3 Beta • Access to Microsoft Development Team • Ask the Experts

  25. Next Year • November 11-14, 2003 • Washington State Convention & Trade Center • Seattle, Washington BE THERE!

More Related