Speaker – Wayne Sheffield
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Session Title – More Fundamentals for Your SQL Server Toolbox [DBA]
SQL Server has evolved many times over the years. This evolution has brought a need for every DBA to enhance or at least revisit their fundamental methods for tuning and troubleshooting. In this session you will explore how SQL Server has made the data professional’s job easier through the addition of new features and enhancements to some of the well-established features. This session will expose you to some of the new toys now available to you (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server. Coming away from this session, you will have more tools to help showcase your rock-star skills back on the job.
Thank you to our Sponsors!
Speaker – Azhagappan (Az) Arunachalam (view bio)
Session – SQL Graph
Microsoft is on the verge of releasing SQL Server 2017 RTM. The feature set has been finalized, and Release Candidate v2 is out. Some of the major features of SQL Server 2017 includes support for Python alongside R (released with SQL Server 2016), inclusion of adaptive query plans, and SQL Graph integration, not to mention the portability of the product to run on other platforms (various distributions of Linux, Linux container on Docker on MacOS, or Linux/Windows container on Docker on Windows etc.,). SQL Graph is a version 1 of the product – but one that holds a lot of promises. In this session, we’ll take a look at what this feature brings to the table, and see how it is different from the other graph database offerings.
Speaker – John Morehouse (view bio)
Session – SQL Server Databaseology: A Deep Dive Into Database Internals
Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge that will allow you to build better and faster databases.
Files – SQL-Server-Databaseology.zip
Come out and join us on Wednesday July 19th for an informative session! Please remember to bring school supply donations in conjunction with Sentry One’s sponsorship of SQL Vacation! Details of the contest and desired supplies can be found here.
Abstract: Seven Points Administrators Should Know About Execution Plans
Every time we send a query to SQL Server, the database has to execute your query. This session will review seven areas you should know about execution plans, how they work, and how to help make your job easier.
Speaker: Carlos Chacon
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. Carlos is regular contributor to the SQL Server community in Richmond and is planning a SQL Server conference in October. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven).
Additional info: SQL Data Partners is hosting a two day conference on October 4-5, 2017 in downtown Norfolk. They have graciously provided our User Group with a discount code ( B3F9EC) More details and registration can be found here.
The great SQL podcast from SQL Data Partners can be found here
Thank you to our Sponsors!
We are honored to have Kevin Kline of SentryOne joining us as part of his “SQL Vacation” tour! He will be presenting his famous session on end to end troubleshooting in SQL Server.
In addition to having Kevin Speak SentryOne will be collecting school supply donations and will be awarding an awesome Barbecue apron to 3 lucky individuals from all the entries. Please see http://info.sentryone.com/sql-vacation-2017 for details on how to enter.
Come on out and join us for a