The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

SQL Server 2017 New Features (Not Linux support!)

Wed, Mar 14 2018 18:00 UTC

SQL Server 2017 New Features (Not Linux support!)

This session covers the new features in SQL Server 2017 - apart from Linux support • New support using Query Store for automatic tuning of queries which have bad plans (multiple plans with regressions) • Additional information (statistics) stored in the actual execution plans • New DMVs e.g. showing log information, statistics histograms • Interleaved Execution for multi-statement T-SQL TVFs • Adapative joins for queries • Resumable online index rebuild • Performance enhancement for non-cluster index builds on memory optimized tables. • Additional in-memory SQL Surface Area e.g. Computed columns, JSON, CROSS APPLY,sp_spaceused,sp_rename,CASE,TOP N with TIES • Parallel Transaction Redo for memory optimized tables, increases throughput for Always On Availability Groups • DTC support for Always On Availability Groups • Cluster-less Availability Groups • Minimum Replica Commit Availability Groups • New CLR strict security • Graph database queries • Running Python scripts in SQL Server • BULK INSERT directly from CSV files

David Williams

David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQL Saturdays as well as local usergroups and is a regular volunteer at events including SQLBits.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top