1 / 24

Welcome

Welcome. November 14, 2011 Meeting. Mailing List. Sign up on the www.msbinyc.com home page: December 12 th - Denali in PowerPivot : Self-Service BI hits the Big Time Kevin S. Goff. Next Meeting:. Sponsor. Raffles. 3 eBook coupons from O’Reilly. We’re a PASS Chapter!.

trung
Download Presentation

Welcome

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. Welcome November 14, 2011 Meeting

  2. Mailing List • Sign up on the www.msbinyc.com home page: • December 12th- Denali in PowerPivot: Self-Service BI hits the Big Time • Kevin S. Goff Next Meeting:

  3. Sponsor

  4. Raffles • 3 eBook coupons from O’Reilly

  5. We’re a PASS Chapter!

  6. Sign up for a free membership today at sqlpass.org …and join the community discussions here: LinkedIn www.linkedin.com/PASS Facebook www.facebook.com/PASSGroup Twitter @SQLPASS and www.twitter.com/sqlpass PASS Blog: www.sqlpass.org

  7. SQL Server 2012: A First-Hand Report from the PASS Summit Jeff Bolton

  8. Agenda • What is PASS? • Key Announcements • Fantastic 12 • Power View • Column Store Indexes • Q&A

  9. About Jeff Bolton • Database Architect • Member of Tallan’s BI Practice • Nearly 25 years of IT experience • Hockey Dad

  10. What is PASS? • “Connect. Share. Learn” • Benefits • Become a Member for Free • http://www.sqlpass.org/RegisterforSQLPASS.aspx

  11. SQL Rally 2012 • Dallas, TX • May 10-11, 2012 • http://www.sqlpass.org/sqlrally/2012/dallas/

  12. Summit 2012 • Seattle, WA • November 6-9, 2012 • http://www.sqlpass.org/summit/2012/

  13. Key Announcements • “Denali” = SQL 2012 • Scheduled for H1 2012 • “Crescent” = Power View • Hadoop Support • ODBC Drivers for Linux • “Data Explorer” • Amir Netz, Technical Fellow

  14. Vision • Any Data, Any Size, Anywhere • Connecting the World’s Data • Immersive Experience Wherever You Are

  15. Fantastic 12 – Part 1 • Required 9′s & Protection • Blazing Fast Performance • Rapid Data Exploration • Managed, Self-Service BI • Credible Consistent Data • Organizational Compliance

  16. Fantastic 12 – Part 2 • Peace of Mind • Scalable Data Warehousing • Fast Time to Solution • Extend Any Data, Anywhere • Optimized Productivity • Scale on Demand

  17. Big Data • 2009 - .8ZB but by 2020 – 35ZB • Different Management Methods • eBay – 10PB on 256 Nodes • Facebook – 20PB on 2,700 Nodes • NOSQL = Not Only SQL • RDBMS for OLTP and Small Data Warehouses

  18. Power View (“Crescent”) • Browser based BI Report Authoring Tool • Self-Service • Highly Interactive and Visual • Requires SharePoint Integrated Mode of SSRS

  19. Demo – Power View

  20. Column Store Indexes (“Apollo”) • Group and Store Data by the Column, Not Row • Significant Compression • Column-oriented: • 1,2,3; • Smith,Jones,Johnson; • Joe,Mary,Cathy; • 40000,50000,44000; • Row-oriented • 1,Smith,Joe,40000; • 2,Jones,Mary,50000; • 3,Johnson,Cathy,44000;

  21. Key Characteristics • Faster Query Results • Key Columns • Clustered Index Key • Record Size • Query Processing • Table Cannot be Updated

  22. Demo – Column Store Index

  23. Other Cool Takeaways • Containment • SSMS and BIDS Improvements • Azure updates • SSIS vs T-SQL for ETL • DMV Queries Against SSAS • http://www.data.gov

  24. Questions?

More Related