The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Login to Subscribe

Event Display
Meeting Detail

Tue, Apr 02 2019 16:00 UTC


Performance Troubleshooting Using Wait Statistics - Paul Randal

RSVP: None

Performance Troubleshooting Using Wait Statistics - Paul Randal

One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns. Paul’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and has been a SQL Server MVP ever since. When he’s not tweeting, blogging, or helping someone recover from a disaster, he’s likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp.


Paul’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and has been a SQL Server MVP ever since. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp. Full bio at http://www.sqlskills.com/about/paul-s-randal/

Meeting Detail

Tue, Apr 09 2019 02:30 UTC


Containers - You Better Get on Board!

RSVP: None

Containers - You Better Get on Board!

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes. In this session, we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes Prerequisites: Operating system concepts such as command line use and basic networking skills.


Anthony is the Founder and President of Centino Systems as well as a Pluralsight Author and a Microsoft Data Platform MVP. Linux Expert and Corporate Problem Solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

Meeting Detail

Tue, Apr 16 2019 16:00 UTC


3 Performance Tuning Tricks you Always Wanted to Know - Pinal Dave

RSVP: None

3 Performance Tuning Tricks you Always Wanted to Know - Pinal Dave

No one wants the slow performance of their application. In this session, we will learn about three performance tuning tricks which DBA must know to improve their SQL Server’s performance. We will understand what are those tricks, and how efficiently we can use it in just 50 minutes. We will explore various settings as well as code which will kill SQL Server Performance. At the end of this session, every attendee will receive scripts which will help them improve their SQL Server’s performance. This session is of intermediate level – you just have to know a little bit about SQL Server and a lot more you will learn in this session. The session is carefully crafted from the real world experience for DBA so they can learn tricks which can help them to improve their server’s performance.


Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4200 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Meeting Detail

Tue, May 07 2019 16:00 UTC


Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance - Glenn Barry

RSVP: None

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance - Glenn Barry

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in flash storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads. Glenn has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.


Glenn Berry works as a principal consultant at SQLskills in Elizabeth, CO. He is a former Data Platform MVP and has a collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests! His expertise includes DMVs, high availability, hardware selection, and storage subsystems. Glenn is also an adjunct faculty member at University College - University of Denver, where he has taught since 2000.

Meeting Detail

Tue, May 14 2019 02:30 UTC


Using Open Source Products for Collecting Performance Metrics - Tracy Boggiano

RSVP: None

Using Open Source Products for Collecting Performance Metrics - Tracy Boggiano

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions. In this session, we will discuss sp_whoisactive and Query Store. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization. Attendees will see how easy it is to get good performance data and visualize in an interactive way and combine with other tools to troubleshoot issues. For an example, we will combine this solution with Query Store and/or sp_whoisactive to find a problem that occurred on a system and caused me to get my nap interrupted on a Saturday.


Tracy is a Senior Database Administrator for FM:Systems. She has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS local user group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

Meeting Detail

Tue, May 21 2019 16:00 UTC


DevOps Fundamentals: What, who, why and how? - Kendra Little

RSVP: None

DevOps Fundamentals: What, who, why and how?

More and more organizations are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery and start adding more value to the business. But what exactly is DevOps? And what does it mean for DBAs? Join Microsoft Data Platform MVP Kendra Little to discover: • What is DevOps and what benefits can it offer your organization? • Who in your organization should be involved in DevOps? • Why should your organization adopt DevOps? • Why should DBAs want to adopt DevOps? • How can your organization start implementing DevOps?


Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.

Meeting Detail

Tue, Jun 04 2019 16:00 UTC


Journey to the Cloud with Azure Database Migration Service - Warner Chaves

RSVP: None

Journey to the Cloud with Azure Database Migration Service - Warner Chaves

As part of Microsoft Azure's data platform offering, Microsoft has developed the Azure Database Migration Service. This is a cloud service that lets you take your databases (SQL Server, MySQL, PostgreSQL) and easily migrate them into one of Azure's Database as a Service offering. Efficiency and reliability are always important when performing a migration and using a service like this one can help DBAs accomplish their work faster and make the migration seamless and less error prone. Definitely a good tool for any DBA looking to migrate their databases to Azure! In this session we will go over the details of the Azure Database Migration Service as well as show live demos of the service and performing a migration from SQL Server to Azure SQL Database.


Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.

Meeting Detail

Tue, Jul 09 2019 16:00 UTC


Help! SQL Server 2008 is Still Here! - Brent Ozar

RSVP: None

Help! SQL Server 2008 is Still Here! - Brent Ozar

Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing's changing at your company. You still have SQL Server 2008 in production, and you're a little nervous. How should you approach the conversations with management? Brent Ozar will help: he's been there too, fighting managers who want to leave an old server hiding in the corner. We'll role play: you be the manager, and Brent will show his techniques for convincing management to take the plunge and move to a newer SQL Server version. Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.


Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at BrentOzar.com.

Meeting Detail

Tue, Jul 23 2019 16:00 UTC


What Else Can Indexes Do?

RSVP: None

What Else Can Indexes Do?

Lots of sessions about indexes give you technical, but not practical information. It's not that the information is bad, it's just that you can't take it and apply it to your problems. In this session, we're gonna dive deep into how queries use indexes, and the warning signs you'll see when you have a problem indexing can solve. We're going to be looking at query plan stuff like memory grants, spools, and lookups. We're also going to look at how indexes can give you a leg up on locking. And best of all, you'll learn how to stop worrying about fragmentation and start fixing real problems.


Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's had some terribly boring DBA jobs, and been a consultant for Some Guy You've Never Heard Of™. He enjoys public arguments with the optimizer and wine photography.

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