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

Event Display
Meeting Detail

Tue, Nov 20 2018 17:00 UTC


An Introduction to Partitioning

RSVP: None

An Introduction to Partitioning

Are you a Database Administrator or Developer who has not previously implemented partitioning within an OLTP database? Have you thought about it, want to implement it, or even been asked to? We're going to go over the concepts and implementation of partitioning for you! We'll cover: • Introduction to partitioning, core concepts, and benefits. • Overview of partitioning functions and schemes. • Considerations for selecting a partitioning column. • Creating a partitioned table. • Explanation of aligned and non-aligned indexes. • Manually switching a partition. • Manually merging a partition. • Manually splitting a partition. • Demo on partition implementation & maintenance, covering automatic sliding windows. A SQL Server DBA, originally from Swansea, Wales but is currently living in Dublin, Ireland, Andrew has been working with relational databases (in one form or another) for over 10 years and has been a SQL Server DBA for 6 of those.


SQL Server DBA with over 10 year's experience. Originally from Wales but now living in Ireland

Meeting Detail

Tue, Dec 04 2018 17:00 UTC


Data Compression 101

RSVP: None

Data Compression 101

Since data compression is now a standard level feature (2016 SP1+) learn how to squeeze a little extra performance out of your databases for free! We’ll cover the types of compression available and how they work, the costs and benefits and how to determine good candidates for compression. Once we know what we want to compress we’ll cover three ways to apply it, including the easiest way to compress your whole database to meet best practices with just one line of code!


Jess Pomfret is a SQL Server DBA at Westfield Group in Westfield, Ohio. She started working with SQL Server in 2011 and currently works as part of a team administering over 100 instances ranging from 2005 to 2017. She enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell. She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.

Meeting Detail

Tue, Dec 18 2018 17:00 UTC


Cross querying multiple SQL sources using Xpath based queries

RSVP: None

Cross querying multiple SQL sources using Xpath based queries

When working on large SQL Server estates, lacking the total overview is a common challenge. There is a lot of data in the performance and dictionary views but it is hard to visualize in an easy manner. To make sense of the situation you need to gather all the information together in a simple view. Merging data from multiple sources in SQL can be tricky, and lead to complicated SQL queries that require a lot of experience to write and understand. We will show how SQL queries can be mapped in a graph structure and combined with an XPath based query language, using a dedicated query engine, to merge together the data to give clear dashboards across the entire SQL Server estate.


Per Undheim is a Senior DBA at dbWatch working with R&D, operations and customers on both SQLServer and Oracle cluster platforms. He is actively involved in developing and deploying new features in our products, helping customers with deployment and tuning – and managing several other projects in-house and for customers. He is also our resident security expert having worked as security manager in other companies before joining dbWatch. When not working with SQL server or Oracle issues he is an avid drone builder and pilot making his own electronics and 3d prints.

Meeting Detail

Tue, Jan 08 2019 17:00 UTC


Plan Stability through Plan Forcing - Erin Stellato

RSVP: None

Plan Stability through Plan Forcing - Erin Stellato

Intermittent performance issues due to parameter-sensitive queries are a DBA's nemesis. By the time you're notified of an issue, sometimes it's gone away...or someone else has restarted the instance or cleared the plan cache, and any data you could use is gone. Capturing the different plans for those queries can be tricky, but with Query Store it becomes very simple - the hard part is deciding what plan you like best. The Query Store feature, introduced in SQL Server 2016 and also available in Azure SQL Database, captures query performance data, and it allows you to manually force a plan for a query. In SQL Server 2017 and Azure SQL DB, the Automatic Plan Correction feature will force plans for you. Sound scary? It's not. In this session we'll explore both manual and automatic plan forcing through demos so you understand how it works, what to expect, and what to watch out for when you implement it in your environment. Erin Stellato is a SQL Server MVP 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 statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure 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 like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.


Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 17 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, Jan 22 2019 17:00 UTC


Free Downloads for Powerful SQL Server Management - Brent Ozar

RSVP: None

Free Downloads for Powerful SQL Server Management - Brent Ozar

You're responsible for managing and troubleshooting SQL Server, and you're not alone. The SQL Server community has banded together and built a ton of cool stuff that you can use to do your job easier. In this one-hour session, Brent will show the First Responder Kit, sp_WhoIsActive, Ola Hallengren's maintenance solution, SentryOne Plan Explorer, and point you to a dozen more tools you can download right now, for free. 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, Feb 05 2019 17:00 UTC


Understanding SQL Server Backup and Restore - Tim Radney

RSVP: None

Understanding SQL Server Backup and Restore - Tim Radney

Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn! Tim is a SQL Server MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.


Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQL Saturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

Meeting Detail

Tue, Mar 05 2019 17:00 UTC


Stored Procedure Optimization Techniques - Kimberly Tripp

RSVP: None

Stored Procedure Optimization Techniques - Kimberly Tripp

Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources). Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.


Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

Meeting Detail

Tue, Mar 19 2019 16:00 UTC


Administering Beyond the Speed of Light : Managing SQL Server with Ansible

RSVP: None

Administering Beyond the Speed of Light : Managing SQL Server with Ansible

Ansible is open source software used for configuration management, server provisioning, application deployment and general automation tasks. It can be used to manage both Windows and Linux based systems, running on-premise or in the public cloud. Despite its ability to perform a vast array of tasks, Ansible is reliable, secure and easy to get up and running quickly. Thanks in part to its agentless architecture, Ansible scales effortlessly to hundreds or even thousands of servers. In this presentation we will walk through the basics of installing and configuring an Ansible server and using this server to administer SQL server instances running on Windows and Linux. No prior knowledge of Ansible is expected but an understanding of basic Linux administration will be helpful.


Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Site Reliability Engineering Manager on the DevOps team at Citrix ShareFile. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Cary, North Carolina. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

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

Holding


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

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