Meet & Greet at 6:30PM Presentation at 7PM
Please join and
RSVP at our
FWSSUG MEETUP page!
Abstract:
Query performance is what it is all about. SQL Server 2014/2016 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables. This session is all about when and how to apply in-memory tables in a production environment. After this session you will 1. Understand what in-memory tables are and how to create and maintain them including their limitations 2. Be able to identify performance gains over equivalent disk back tables 3. Comprehend the new data monitoring needed for in-memory table
In_MemoryPresentationLink is a dropbox link containing zip file containing my PowerPoint and all TSQL script demo files.
Bio:
Mike Byrd Bio:
Email: mbyrd@nctv.com
Phone: 512-657-5349
Twitter: @ByrdNest_TX
Web Site:
www.TSQLMentoring.com
Company: ByrdNest Consulting (Business Owner)
Job Title: Senior Database Engineer
Address: 213 Lakeview, Sunrise Beach, TX 78643-9308
LinkedIn profile:
https://www.linkedin.com/in/mike-byrd-bbbaa01
Summary: Former rocket scientist and USAF Fighter Test Pilot -- now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Current in SQL Server 2016 (RC3), 2014, 2012, 2008R2, and 2005. Presented many SQL Saturday presentations at Austin, Baton Rouge, Denver, Dallas, Houston, Oklahoma City, South Florida, Gothenburg (Sweden), Atlanta BI, Albuquerque, Tampa, Jacksonville, Pensacola, Nashville, Atlanta, Oslo, and Sydney. Currently consulting for several Austin based software companies and free-lance writing a series of performance articles for SolarWinds (
http://logicalread.solarwinds.com/?s=Byrd
). Also working up new data architecture and implementation plan for Daughters of Republic of Texas system.
Specialties: SQL Server performance tuning; database (OLTP & OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Instruction: Have presented group TSQL classes for Newgistics, Austin, TX; Conexis, Irving, TX; and Mentor (Johnson & Johnson), Irving, TX, and individualized mentoring on a one-on-one basis, Have presented TSQ: Basic to Advanced PreCon at Dallas SQL Saturday #447 – 17 paid attendees with all excellent reviews. Recently presented Advanced TSQL 8 hour session to Solarwinds Corporate Office, Austin, TX with very positive reviews (25 attendees).