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

Login to Subscribe

Event Display
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, Jun 11 2019 02:30 UTC


Title – 14 Habbits of Great SQL Developers - Ike Ellis

RSVP: None

Title – 14 Habbits of Great SQL Developers (Ike Ellis)

SQL Developers range from very bad to great. Come watch this session to learn the habbits that great developers share and enjoy a gentle reminder to renew your commitment to maintain great effective habbits


Ike Ellis is a Senior Data Architect and partner for Crafting Bytes. He has designed and implemented data solutions for many well-known organizations. He has been a Microsoft Data Platform MVP since 2011. He coauthored the book "Developing Azure Solutions," now in its second edition. He is a popular speaker at SQLBits, PASS Summit, and SQL in the City. He speaks at user groups, code camps, and SQL Saturdays. He has written courses on SQL Server for developers, Power BI, SSRS, SSIS, and SSAS for Wintellect. He has an upcoming courses on CosmosDB. He founded the San Diego Tech Immersion Group, a technical book club based in San Diego and is the co-chair of the San Diego Software Architecture Group.

Meeting Detail

Tue, Jul 09 2019 02:30 UTC


Introduction to SQL Server Temporal Tables - Tim Mitchell

RSVP: None

Introduction to SQL Server Temporal Tables

SQL Server temporal tables are a relatively new introduction to the SQL Server stack, representing a unique way to store temporal (time-based) data. These system-versioned temporal tables can be used to create versions of your data over time, allowing for point-in-time historical analysis of changed data. In this presentation, we will introduce and review the essentials of system-versioned temporal tables in SQL Server. We will cover the concept of temporal storage, and demonstrate how these are implemented in SQL Server. Finally, we will demonstrate the use of temporal tables through several realistic examples.


Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

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.

Meeting Detail

Tue, Aug 13 2019 02:30 UTC


Working with Strings in SQL Server - Greg Low

RSVP: None

Working with Strings in SQL Server

Not sure what that N is in front of strings in SQL Server queries? Don’t really get Unicode? Don’t know what a code page is? Not clear about collations? No idea why everyone’s talking about UTF-8? It’s time to get confident with these. Come spend an hour and let Greg show you.


Greg is well known in the SQL Server community as a mentor, trainer, author, and community leader. He is a certified master for SQL Server, was an instructor in that program, and holds a PhD in Computer Science. Microsoft regularly call on Greg to develop data-related content, and to train their own staff. He regularly speaks at tier-one conferences internationally. Greg is best known for his SQL Down Under podcast, SDU Tools, and his eBooks and whitepapers. He heads up a boutique consultancy called SQL Down Under in Melbourne Australia. Greg has been awarded as an MVP since 2001.

Meeting Detail

Tue, Aug 20 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, Sep 10 2019 02:30 UTC


Eyes On The Prize: Simple and Effective Dashboard Visualization Techniques - Kevin Feasel

RSVP: None

Eyes On The Prize: Simple and Effective Dashboard Visualization Techniques

When done right, data visualization informs users quickly and efficiently with a minimum of distraction. When done wrong, we end up with spinning 3D pie charts. In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience. We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image. When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards. Finally, we will take an awful dashboard and turn it into something which end users will appreciate.


Kevin Feasel is a Data Platform MVP and Engineering Manager of the Predictive Analytics team at ChannelAdvisor, where he specializes in T-SQL and R development, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), a contributing author to Tribal SQL (http://www.tribalsql.com), and one of the contributors behind We Speak Linux (https://wespeaklinux.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Meeting Detail

Tue, Sep 10 2019 04:00 UTC


Refactoring Queries for Improved Performance

RSVP: None

T-SQL Tuneup Tips or something like that

Temp Title and Description


Bert Wagner teaches data-focused developers how to use SQL Server efficiently every week on his YouTube channel “SQL with Bert.” When not filming episodes, he gains inspiration for his content through his work as a Principal Business Intelligence Developer for Progressive Insurance in Cleveland, OH. Starting his career as an SSIS and SSRS developer, Bert fell in love with SQL Server query writing and performance tuning. Nowadays he focuses on full stack web development and uses his database tuning skills to ensure that his applications run at peak performance.

Meeting Detail

Tue, Oct 08 2019 01:30 UTC


Introduction to Query Store - Erin Stellato

RSVP: None

Introduction to Query Store

One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then this is a feature you want in your environment. In this session we will cover the data collected, how to use the built-in reports to find problematic queries, and walk through plan forcing in Query Store. Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016 and higher!


Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

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