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.

Regular Meeting Schedule

The DBA Virtual Chapter 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

Performance Troubleshooting made easier- New features in Management Studio

Wed, Feb 14 2018 12:00 (UTC-07:00) Mountain Time (US & Canada)

RSVP: None

Performance Troubleshooting made easier- New features in Management Studio

With the release of SQL Server 2016 fundamental changes were made to SQL Server Management Studio (SSMS) and Graphical Execution Plan (Showplan). SSMS is updated each month with the latest version of the SQL Client Tools. Do you know that ‘Vulnerability Assessment' per Database and Availability Group latency between replica's can be reported from within SSMS? Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows? In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.


Taiob Ali

Taiob Ali, an accomplished technical leader with proven record of success. He has spent the last 12 years working with SQL Server and MongoDB platform both on premise and cloud. His experience includes three major business sectors: financial industry, e-commerce and healthcare. Taiob has hands on experience in managing large database projects including large data migration, complex process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as lead DBA. Focusing on automation, improving and streamlining operational workflow, plan and prepare for cloud migration. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays and Azure conferences.

Meeting Recordings

The DBA Virtual Chapter 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.

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, dbavolunteer@sqlpass.org.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids