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

Event Display
Meeting Detail

Tue, Jun 06 2017 11:00 Central Daylight Time


All about Indexing with Gail Shaw

RSVP: https://attendee.gotowebinar.com/register/7241500509312627458

All about Indexing with Gail Shaw

Indexes are essential to good database performance, but it can be hard to decide what indexes to create and the ‘rules’ around indexes often appear to be vague or downright contradictory. In this session we’ll dive deep into indexes, have a look at their architecture and internal structure and how that affects the way that indexes are used in query execution. We’ll look at why clustered indexes are recommended on almost all tables and how their architecture affects the choice of columns. We’ll look at nonclustered indexes; their architecture and how query design affects what indexes should be created to support various queries


Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization. Gail works for Entelect, a medium-sized custom software development house based in Johannesburg. Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server.

Meeting Detail

Tue, Jun 13 2017 12:30 (UTC+10:00) Brisbane


Plan, Design and Implement a HADR Solution – a Journey

RSVP: https://attendee.gotowebinar.com/register/8066925879046939905

Plan, Design and Implement a HADR Solution – a Journey

Have you ever struggled to get a HA and DR solution for a single instance with more than 50 applications, 100 databases and 4 TB of data? Over the years, HA and DR has been a challenge with SQL Server. As the product evolved so did the options simplified for achieving a feasible HADR solution. In this session I will walk you through various projects I have worked on in past 8 years. I will start with the basic DR solution built using Log shipping, an alternate to AGs in SQL 2008 using Powershell/.NET and SAN Replication and the latest 4 node, two site cluster built with Availability Groups.


Manohar Punna is an SQL Geek and President of DataPlatformGeeks by passion and a Data Platform Consultant by profession. He is a speaker at various SQL Server Day events and user groups, SQL Saturday Melbourne and Sydney, SQLBits XIV conference and SSGAS conferences. He has authored over 150 blogs and has written a One DMV a Day series which is a longest one day series on any topic on SQL Server till date.

Meeting Detail

Tue, Jun 20 2017 11:00 Central Daylight Time


SQL Server 2016 SP1: All the Enterprise Features You Ever Wanted—In Standard Edition

RSVP: https://attendee.gotowebinar.com/register/5012461686849752066

Meeting Detail

Tue, Jul 11 2017 11:00 Central Daylight Time


SQL Server Performance Tuning Made Easy

RSVP: https://attendee.gotowebinar.com/register/4566824126635228417

SQL Server Performance Tuning Made Easy

SQL Server Performance Tuning is still a mystery to many. Quite often even an experienced SQL Server DBA, often gets confused as to how to figure out where to start with this entire process. In this module we are going to learn about how to get started with SQL Server Performance Tuning. We will go over some very important scripts which will help us to get started with the SQL Server Performance Tuning exercise. At the end of the session the author will share his three important scripts which he uses at his customer sites all the time.


Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 18 Pluralsight courses and has written over 4000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 15+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET).

Meeting Detail

Tue, Aug 08 2017 11:00 Central Daylight Time


Azure SQL Data Warehouse for the SQL Server DBA

RSVP: https://attendee.gotowebinar.com/register/7531614349923626755

Azure SQL Data Warehouse for the SQL Server DBA

The power of cloud storage and compute power has made data warehousing possible for businesses of all sizes. What was once a large capital expenditure and multi-year implementation can now be deployed and ready to use within minutes and allow any organization to collect, query and discover insights from their structured data sources. With a full T-SQL interface and compatibility with the rest of the Microsoft data stack, Azure Data Warehouse can fit transparently into your business data strategy and leverage already existing and familiar development and management skills. In this session we will look at the main concepts of the Azure SQL Data Warehouse service, how it's different than SQL Server and the advantages it provides to an on-premises solution.


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, Sep 12 2017 11:00 Central Daylight Time


From DBA to Data Scientist

RSVP: https://attendee.gotowebinar.com/register/4117932011900835841

From DBA to Data Scientist

The world’s fastest growing job is that of the data scientist. Many believe the career is out of reach without a PhD. While many job requirements list a PhD as preferred it’s not a necessity. The good news for database professionals is that we can leverage our skills and experience to enter the machine learning space without the advanced education requirements. There’s a learning curve but it doesn’t require a master’s or PhD. In the real-world companies need data scientists who specialize in applied machine learning. Machine learning is a type of artificial intelligence that provides computers with the ability to learn without being explicitly programmed. Applied machine learning is using existing algorithms to build predictive models at the expense of understanding how the under lying algorithms are written. In this session I’m going to discuss the move from the DBA role to that of the Machine Learning Engineer. We will learn about applied machine learning. In addition to discussing machine learning we will build a predictive model in Python and Azure Machine Learning Studio. We are about to witness an explosion in applied machine learning and I’m going to show what you’ll need to do to get started.


Mike West brings over 23 years of IT experience, including expertise in network administration and SQL Server. Prior to becoming a database consultant, Mike worked as a senior level SQL resource for Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman. Mike’s technical expertise for the last 20 years has centered on databases. For the last 18 years Mike’s sole focus has been on SQL Server. Mike is a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) Born in Ohio, raised and educated in Pennsylvania, he currently resides in Atlanta.

Meeting Detail

Tue, Sep 19 2017 11:00 Central Daylight Time


Shortcuts From an Inpatient DBA

RSVP: https://attendee.gotowebinar.com/register/9016254114803772419

Shortcuts From an Inpatient DBA

This session is about performance tuning your day. We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier. Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use. I am a SQL Server DBA and Microsoft Data Platform MVP that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. Since 2003, I have been supporting high-volume, highly-available OLTP environments with demanding performance needs.


Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 13 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy is also co-organizer of SQL Saturday events in Boston, and the founder of the BostonSQL User Group

Back to Top