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

Event Display
Meeting Detail

Tue, Feb 20 2018 11:00 (UTC-06:00) Central Time (US & Canada)


High Availability/Disaster Recovery 101 - Glenn Berry

RSVP: None

2017 High Availability/Disaster Recovery 101 - Glenn Berry

How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2017, showing how you can combine them to design and build a solution to help meet your HA/DR goals. It also covers how to come up with the necessary policies to make the technology actually work in your situation.


Glenn Berry works as a principal consultant at SQLskills in Elizabeth, CO. He is a 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, Mar 06 2018 11:00 (UTC-06:00) Central Time (US & Canada)


Common SQL Server Mistakes and How to Avoid Them - Tim Radney

RSVP: None

Common SQL Server Mistakes and How to Avoid Them - Tim Radney

Making mistakes is natural, but learning from them and avoiding them in future takes effort. There's no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid. In this session, Tim will share with you a ton of what he's learned over the years from working and consulting at multiple Fortune-level companies. You'll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. You'll learn many proven and accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smoothly as possible and you'll leave with a checklist of items to take home to make sure your SQL Server environment is configured properly.


Tim Radney is a principal consultant with SQLskills and a Microsoft SQL Server MVP.

Meeting Detail

Tue, Mar 20 2018 11:30 Central Daylight Time


What To Do When SQL Server is Slow - Brent Ozar

RSVP: None

What To Do When SQL Server is Slow

Someone comes running in and asks, "Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow." It's one of the most common complaints we get about our databases - and yet, most of us don't have a written plan with what steps to take, in order. I do this for a living, so I've had to make a written checklist to handle it. I'll give you the exact same checklist I use, then walk you through several performance emergencies. I'll show you how I use open source scripts like sp_WhoIsActive, sp_BlitzFirst, sp_BlitzCache, and more to find the root cause fast. We won't cover performance tuning - our goal in this hour is just to have a written triage process so we don't look like bumbling idiots. Let's get good at this! Bio: 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, Mar 20 2018 12:30 (UTC+10:00) Brisbane


Automatic Tuning and Adaptive Query Processing in Azure SQL Database and SQL Server 2017

RSVP: None

Automatic Tuning and Adaptive Query Processing in Azure SQL Database and SQL Server 2017

Automatic Tuning and Adaptive Query Processing are perhaps the two key features of SQL Server 2017 and Azure SQL Database which would influence query optimizer's plan choices. The following session will provide an overview of the features and explain how it can help to address performance issues like parameter sniffing, plan regressions, lack of indexes or too many indexes without any manual intervention and change of code.


Nagaraj Venkatesan is a Data Platform MVP from Singapore and the leader of Singapore SQL PASS Chapter. As a SQL Server enthusiast, Nagaraj is a regular speaker in Asia Pacific region at Data Platform events like SQL Saturdays, SQL Server Geeks Summit, User group meetups etc. Nagaraj shares his technical expertise at strictlysql.blogspot.com. Nagaraj also runs a YouTube channel called "DataChannel", which contains technical interviews with top Microsoft Data Platform experts in the world.

Meeting Detail

Tue, Apr 03 2018 11:00 Central Daylight Time


Index Fragmentation: Internals, Analysis, and Solutions - Paul Randal

RSVP: None

Index Fragmentation: Internals, Analysis, and Solutions - Paul Randal

As soon as you have more than one index on a table, you're going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy.


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 10 2018 12:30 (UTC+10:00) Brisbane


Test Driven Development in SQL Server – it will make your database deployments better

RSVP: None

Test Driven Development in SQL Server – it will make your database deployments better

Test Driven Development (TDD) is a practice that has for years enabled application developers to write code that is less-buggy. It is extremely relevant for database development, as it ensures that the code produced using TDD will be of higher quality, which means interactions with data and code are safer. In this session we will go through how to setup some simple unit tests using various industry tools such as the open-source framework – tSQLt, the SQL Cop testing utility and Redgate’s SQL Test tool which brings it all together. The advantage of these tools is that we can run them within our familiar SQL Server Management Studio, whereas other testing frameworks rely on the Visual Studio IDE. It will be shown in a comprehensive DEMO how to bring TDD to your database development and result in higher quality deployments to your databases when incorporated into Continuous Integration processes.


Hamish is a Systems Management Specialist with a passion for efficient database & application deployment using DevOps methodologies. He has 19 years IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to end users is his career passion. Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, International speaker and a repeat guest lecturer at a local university.

Meeting Detail

Tue, Apr 17 2018 11:00 Central Daylight Time


Execution Plans for Beginners - Thomas LeBlanc

RSVP: None

Execution Plans for Beginners - Thomas LeBlanc

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?


Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 28+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts using SSIS, SSAS, PPS, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge UG and SQLSaturday. Blog - TheSmilingDBA.BlogSpot.com Thomas completed in 2015 12 hours of online SQL Server Analysis Services content and 8 hours of SQL Server 2017 content for LearnNowOnline. Current articles can be accessed on SQLShack.com.

Meeting Detail

Tue, May 01 2018 11:00 Central Daylight Time


Index Design Patterns for Beginners - Kendra Little

RSVP: None

Index Design Patterns for Beginners - Kendra Little

Ready to design your first nonclustered index in SQL Server? In just one hour you’ll learn how to look at a query and design a nonclustered index to make it faster. You’ll learn about key columns, included columns, and a few gotchas to look out for. You’ll leave the session with a foundational understanding of rowstore nonclustered indexes, ready to tackle further indexing challenges.


Kendra Little teaches people to architect and tune SQL Server for performance. She is a Microsoft Certified Master in SQL Server, a Microsoft MVP, and one of the few artists in the world to draw both dinosaurs and databases.

Meeting Detail

Tue, Jun 05 2018 11:00 Central Daylight Time


Not So Secret: Get To Know SQL Server Agent - Jes Borland

RSVP: None

Not So Secret: Get To Know SQL Server Agent - Jes Borland

Secret agents have it all: fun code names, cool gadgets, and fast cars. SQL Server Agent has operators, jobs, and alerts. These features will turn your database server into a well-tuned machine that can warn you of errors, alert you to approaching problems, and run tasks on a schedule. Learn how to increase your automation capabilities and take your notifications to a new level!


Jes Borland is a SQL Server Premier Field Engineer at Microsoft. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is a user group founder, a blogger, and a frequent speaker. In her free time, she runs, cycles, and cooks.

Meeting Detail

Tue, Oct 16 2018 11:00 Central Daylight Time


SQL Server 2016 features to make DBA lives easier - Padma Achanta

RSVP: None

SQL Server 2016 features to make DBA lives easier

SQL Server 2016 announced many new features like in- Memory OLTP, Live Query statistics, Temporal tables and enriched the existing features Encryption to Always Encryption, High Availability Enhancements, Replication Enhancements etc. which make DBA lives easier. Let's flavor for a while handful of different SQL features. In this session, Microsoft Certified SQL DBA Padma Achanta will demonstrate numerous features of SQL Server 2016. Attendees will learn what’s different in SQL Server 2016 and handful of important concepts which are beneficial in day to day DBA life, along with very good examples, SQL Server Architecture and beyond.


Padma Achanta is a Microsoft Certified SQL Server Database Administrator. She is an enthusiastic participant in SQL sessions and relishes learning about Technologies and educating associates. Padma initiated working on SQL online Video exercises. She gained many rewards for her contribution in SQL Server in her working and worked companies and now she volunteered in Women in Technology.

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