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

Event Display
Meeting Detail

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


Migrating to In-Memory OLTP - Erin Stellato

RSVP: None

Migrating to In-Memory OLTP - Erin Stellato

When In-Memory OLTP was originally introduced it seemed to be the answer to all our problems. No locking! No latching! 100x performance gains! But just as there is no spoon, there is no silver bullet with SQL Server, and In-Memory is not a quick-fix for every scenario. But it *could* be a solution for your environment. How do you know? That's what we'll talk about in this session. We'll discuss the basics of In-Memory and then cover topics such as candidate workloads, figuring out what to migrate, and testing methods that you can use to determine if it really does provide a performance boost. Along the way we'll clear up any misconceptions you have about In-Memory OLTP, and you'll walk out of the session knowing whether this is something you should pursue, or put on the back burner until the right opportunity comes along.


Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Meeting Detail

Tue, Feb 13 2018 12:30 (UTC+10:00) Brisbane


Migrating to SQL Server 2017

RSVP: None

Migrating to SQL Server 2017

How do you design and implement a safe and successful migration from an older version of SQL Server to SQL Server 2017 with no data loss and virtually no downtime? What if you have a limited hardware budget for the upgrade effort and you are worried about the core-based licensing in SQL Server 2017? How can you choose your hardware wisely in light of the new licensing model? How can you convince your organization that the time is right to upgrade to SQL Server 2017? This session will cover several different methods for migrating your data to SQL Server 2017 while meeting these objectives and minimizing your hardware and licensing costs. You will also learn how to help make the case that a complete data platform upgrade makes excellent sense from a business perspective. You will also learn how to do effective capacity planning for the new environment to ensure that you have the best performance possible with a manageable SQL Server 2017 licensing cost.


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, 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 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