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

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


Let's talk about Big Data using SQL Data Warehouse

RSVP: None

Let's talk about Big Data using SQL Data Warehouse

Azure SQL Data Warehouse is a massively parallel processing (MPP) cloud-based, scale-out, relational database capable of processing massive volumes of data. SQL Data Warehouse: Combines the SQL Server relational database with Azure cloud scale-out capabilities. Decouples storage from compute. Enables increasing, decreasing, pausing, or resuming compute. Integrates across the Azure platform. Utilizes SQL Server Transact-SQL (T-SQL) and tools. In this session we will discuss about this awesome feature from Microsoft Azure and how we can use it to help on our day to day.


MVP com grande experiência nas áreas de Banco de Dados e Tecnologia da Informação, atuando no desenvolvimento, implementação, manutenção e suporte de servidores de bancos de dados corporativos de grande porte. Possui diversas certificações profissionais e boa vivência em atividades de desenvolvimento e administração de ambientes empresarias utilizando SQL SERVER. Chapter Leader do SQL Maniacs.

Meeting Detail

Tue, Feb 19 2019 17:00 UTC


Architectural Choices That Affect Performance - Kevin Kline

RSVP: None

Architectural Choices That Affect Performance

Architectural Choices That Affect Performance: Why Design Impacts Performance on Microsoft SQL Server This session takes you through ten common design choices made during the creation of a Microsoft SQL Server database application which hurts performance of your application. This session is great for Developers who have not had much training on database and for DBAs who are usually concerned with keeping servers up and running, but not done much database design. We’ll cover a variety of topics, such as: • What are the basics of tables and indexes? How do data type choices directly impact the size, I/O burden, and performance of applications? • What are the most common database design issues that surface in application code? How can you detect them? • What are the primary techniques database designers use to improve performance when optimizing a database design? If you are a DBA, do you have scripts you can run to perform these checks? If you are a Dev, do you know which common design choices are actually pitfalls? If not, then you should attend! This session takes you through a variety of demos that show what sort of anti-patters are common in applications you buy on the open market, how to detect them and, when possible, how to refactor those problems. Don’t miss out!


Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.

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

No one wants the slow performance of their application. In this session, we will learn about three performance tuning tricks which DBA must know to improve their SQL Server’s performance. We will understand what are those tricks, and how efficiently we can use it in just 50 minutes. We will explore various settings as well as code which will kill SQL Server Performance. At the end of this session, every attendee will receive scripts which will help them improve their SQL Server’s performance. This session is of intermediate level – you just have to know a little bit about SQL Server and a lot more you will learn in this session. The session is carefully crafted from the real world experience for DBA so they can learn tricks which can help them to improve their server’s performance.


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, May 21 2019 16:00 UTC


DevOps Fundamentals: What, who, why and how? - Kendra Little

RSVP: None

DevOps Fundamentals: What, who, why and how?

More and more organizations are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery and start adding more value to the business. But what exactly is DevOps? And what does it mean for DBAs? Join Microsoft Data Platform MVP Kendra Little to discover: • What is DevOps and what benefits can it offer your organization? • Who in your organization should be involved in DevOps? • Why should your organization adopt DevOps? • Why should DBAs want to adopt DevOps? • How can your organization start implementing DevOps?


Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.

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