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

Event Display
Meeting Detail

Tue, Nov 21 2017 11:00 (UTC-06:00) Central Time (US & Canada)


SQL Server 2017 - Deep Dive - Bob Ward

RSVP: None

SQL Server 2017 - Deep Dive - Bob Ward

In this session I attempt the impossible: do a deep dive across the investments in SQL Server 2017 in 75 minutes! Come learn about the support for multiple operating systems and containers, what is new in the Database Engine, how Python is now integrated into SQL Server, and much more. Oh and I'll have one or two cool demos to make this real.


Bob Ward is a Principal Architect for the Microsoft Database Systems Group, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 24 years, supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2017. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO), interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server, often presenting talks on internals performance, and troubleshooting at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. You can find him on twitter at @bobwardms or read his blog at https://blogs.msdn.microsoft.com/bobsql.

Meeting Detail

Tue, Nov 21 2017 12:30 (UTC+10:00) Brisbane


Strategies to get maximum concurrency for your workload in SQL Server - Redo

RSVP: None

Strategies to get maximum concurrency for your workload in SQL Server - Redo

Have you experienced slow down in your application because of blocking and wondered what you can do? This talk will cover the basics of concurrency starting with isolation levels including RCSI and snapshot isolation levels, lock escalation, locking granularity and deadlocks. We will follow thru this with diagnosing and troubleshooting the blocking issues and will conclude with general guidelines in designing application(s) for maximum concurrency. Session Goals: (1) Overview of blocking and concurrency in SQL Server. This is more of refresher to bring everyone on the same page. (2) Use demos to show blocking including lock escalation and steps you can do minimize or eliminate blocking without any changes in the application. (3) Use demos to show deadlocks and waits induced thru page latches and show how to monitor and troubleshoot.


Sunil Agarwal is a seasoned professional with 30+ years of industry experience in databases. He has worked as developer/lead building relational database engine technology, as a tool designer/lead building backup/restore tools, as an application developer/manager enabling B2B commerce as e-learning, and now as a principal program manager for SQL Server for the last 14+ years. He currently works in the SQL Server Tiger Team. He has led some key features/technology such as columnstore Indexes, In-Memory OLTP, AlwaysON, Data Compression and concurrency related changes over the past several releases of SQL Server. Experienced in leading development teams both for in-house and offshore engagements. Equally at ease both with drill-down discussions with engineers as well as working with customers and partners. He has authored many technical white papers/blogs, co-authored two books in SQL Server and has presented database technologies in numerous national/international conferences. Sunil enjoys teaching and has taught programming courses at University of Rhode Island and Univers

Meeting Detail

Tue, Dec 05 2017 11:00 (UTC-06:00) Central Time (US & Canada)


SSIS 2016 - Intermediate

RSVP: None

SSIS 2016 Intermediate

Part 2 of SSIS 2016


Virginia Mushkatblat is currently a founder of Hush-Hush, a data masking company. She wrote her first computer program at the age of 14 and has been in technology ever since, progressively rising through the ranks and trying on different hats including database architecture, development, security and operations. She has worked for Startups and Fortune 100 companies in finance, entertainment, e-commerce, internet advertisement, manufacturing, and communications industries and dealt with both heavily transactional and BI applications.She holds Masters Degrees in Engineering and in Computer Science and currently teaches databases to graduating seniors in CSUN, her Alma Mater.

Meeting Detail

Tue, Dec 12 2017 11:00 (UTC-06:00) Central Time (US & Canada)


SOS - Microsoft SQL Operations Studio - 2017

RSVP: None

SOS - Microsoft SQL Operations Studio - 2017

This product is so new even the official name of this exiting product can't be released just yet, but will be before the session. Join us in this hands-on session to learn about the all new SQL Server manageability and development tool. It will be able to run on Windows, macOS and Linux and will be released with 2017. We will walk through end-to-end database development and management scenarios with SQL Server running anywhere with live demos. We will also demonstrate how a portfolio of SQL Server tools working together can empower database development, administration and DevOps practices much more efficiently, effectively and easily. At the end of session, we will host a Q&A session to share the product insight and future roadmap.


Eric Kang is a Senior Program Manager in Database Systems at Microsoft. His focus area includes multi-os database development tools, CICD automation and DevOps practices for SQL Server running anywhere, in Linux, Windows, containers and container platforms.

Meeting Detail

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


Ten Surprising Performance Killers on Microsoft SQL Server

RSVP: None

Ten Surprising Performance Killers on Microsoft SQL Server

Microsoft SQL Server is among the most popular and widely used data platforms of all time with a reputation for resilience, performance, and ease of administration. But wait - performance killers are lurking deep inside your SQL Servers! Learn about these performance killers that most DBAs and Devs are unaware of in this demo-packed session. We will cover a variety of significant issues, ranging from server-side OS settings, file layout, memory settings, and database design to coding issues like data types and cursors. This session will answer questions like: • What Windows Server and SQL Server defaults are likely to make application performance worse? • What is a forwarded record indicator and why is it a red flag? • Why do GUIDs and oversized data type columns decrease performance? • How does changing a database file layout help or hurt performance? • What memory setting should you always change from the default? Learn these performance killers now so that you will save millions of CPU cycles in the future. These mistakes are the “low hanging fruit” of SQL Server application performance. Once you apply the lessons learned from this session, you will you’re your applications performing at a higher level of efficiency and effectiveness than before.


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, 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, Jan 09 2018 11:00 (UTC-06:00) Central Time (US & Canada)


The Jr. DBA Workout Plan

RSVP: None

The Jr. DBA Workout Plan

Squat, deadlift, overhead press, and bench press. In the gym, it's easy to figure out what you need to be doing to get stronger. When you show up to work, you're overwhelmed by all the things happening on your server(s), and you can't figure out where to begin. In this session, we'll talk about building a strong knowledge foundation to help you powerlift your career, without having to clean and jerk or snatch and grab your way to the top. For free.


Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's been a developer at a market research company and a DBA for an eDiscovery shop. He enjoys arguing with the Optimizer and contributing to the First Responder Kit.

Meeting Detail

Tue, Jan 09 2018 12:30 (UTC+10:00) Brisbane


Statement Execution and the Plan Cache

RSVP: None

Statement Execution and the Plan Cache

Kimberly will discuss the impact on caching / performance of different methods of statement execution. Briefly, she will also compare / contrast this with stored procedures. In the end, you’ll know the best way to request data so that stable requests are cached and unstable requests are not (giving you the most optimal performance).


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, Jan 23 2018 11:00 (UTC-06:00) Central Time (US & Canada)


Not So Secret: Get To Know SQL Server Agent

RSVP: None

Not So Secret: Get To Know SQL Server Agent

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

High Availability/Disaster Recovery 101 - Glenn Berry

How do you design a SQL Server 2014 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 2014, 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, 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, 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