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.

Small Changes Can Make a World of Difference – sponsored by Dell Software

Wed, May 28 2014 16:00 UTC

Small Changes Can Make a World of Difference – sponsored by Dell Software

As DBAs, we all know about the big new features, like AlwaysOn Availability Groups, Columnstore Indexes and In-Memory OLTP ("Hekaton"). But there are other "small" hidden features you may have not heard about that can make your lives a lot easier. In this presentation, we will go over some of the cool "small" features that were introduced in SQL Server 2012 and SQL Server 2014, and see how they can help us. Among other topics, we will talk about: • The new revolutionary sys.dm_exec_query_profiles DMV • Delayed Durability • Changes in the storage world and how you can leverage them • Buffer Pool Extension to SSD drives • IO throttling using Resource Governor • Parallelism improvements • Partition Switch and Online Index Operations improvements • Online Schema Changes • Features that can boost your productivity when working with SSMS


Matan Yungman

Matan Yungman is a Data Platform MVP, a senior consultant and the professional manager at Madeira Data Solutions. He has been working with SQL Server since 2002, and today he spends his time consulting, mentoring, teaching and speaking about SQL Server. Matan also co-hosts SQL Server Radio, a podcast for SQL Server professionals. He is passionate about SQL Server, technology and the SQL Server community.

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.

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

 

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.

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

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