1 / 12

DBA Delta Force

DBA Delta Force. SQL Server 2012 features for the DBA. Agenda. About me Discontinued and Deprecated features in SQL Server 2012 New features to be aware of ColumnStore Indexes Thanks. Gareth Swanepoel From South Africa, originally Been in IT for 20+ years

sauda
Download Presentation

DBA Delta Force

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. DBA Delta Force SQL Server 2012 features for the DBA

  2. Agenda About me Discontinued and Deprecated features in SQL Server 2012 New features to be aware of ColumnStore Indexes Thanks

  3. Gareth Swanepoel From South Africa, originally Been in IT for 20+ years Was first a sysadmin, then a DBA DBA Consultant with Pragmatic Works Currently authoring 3 chapters in the upcoming SQL Server 2012 Pro Admin book eMail : GarethS@pragmaticworks.com Twitter : @GarethSwan Website : www.MyGareth.com

  4. Discontinued & Deprecated features

  5. Discontinued features BACKUP DATABASE WITH [MEDIA]PASSWORD Compatibility version 80 (SQL 2000) VIA connection protocol SQL Mail, Net Send & pager notifications All 32-bit support (AWE, etc.) SQL Server Distributed Management Objects (SQL-DMO) Reference: http://technet.microsoft.com/en-us/library/ms144262(v=SQL.110).aspx Features not available in SQL Server 2012

  6. Deprecated features Compatibility version 90 (SQL 2005) Remote servers Ability to return result sets from triggers BACKUP {DATABASE | LOG} TO TAPE SQL Server Profiler Reference: http://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx Features not available in the next and future versions of SQL Server

  7. New & improved features Extended Events – New Session Wizard & Session UI Contained database authentication Custom (user-defined) database roles Auditing enhancements AlwaysOn FileTable and Full-text Semantic Search T-SQL enhancements Features that DBA's care about that will kick butt in SQL Server 2012

  8. ColumnStore Indexes ColumnStore Indexes – the basics The Fangorn Forest: Home of the Ents Row Store (Heap / B-Tree) Column Store (values compressed) data page 2000 data page 2040 data page 1000 data page 2010

  9. ColumnStore Indexes Key Characteristics of CSI's Columnar data format Faster query results Query processing Table cannot be updated The Fangorn Forest: Home of the Ents

  10. ColumnStore Indexes DEMO The Fangorn Forest: Home of the Ents

  11. ColumnStore Indexes Best Practices Choosing Columns DO … put CSI's on large tables only DO … structure queries as star-joins DON'T … use OUTER JOIN DON'T … use UNION ALL DON'T … use string filters, etc DON'T … use NOT IN (<subquery>) The Fangorn Forest: Home of the Ents

  12. eMail : GarethS@pragmaticworks.com Twitter : @GarethSwan Website : www.MyGareth.com Sales : Sales@pragmaticworks.com Products Services Foundation BI productstoconvertto a Microsoft BI platformand simplifydevelopmentontheplatform. Speed development through training and rapid development services from Pragmatic Works. Helping those who do not have the means to get into information technology and to achieve their dreams.

More Related