GroupBy – Free SQL Server Training

By Brent Ozar

Technology Science & Medicine Education Training Software How-To

What's GroupBy – Free SQL Server Training about?

GroupBy.org is free technical training by the community, for the community. Volunteer speakers submit abstracts at GroupBy.org and you – the attendee – vote to pick the sessions. Want to present your own session, or just vote on others? Join us at GroupBy.org.

Download our free app to listen on your phone

GroupBy – Free SQL Server Training episodes:

04.24.2018
Architecting Availability Groups by Derik Hammer
The pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. We also cover their exclusive features such as read-only routing and backup off-loading. In...
04.17.2018
SQL Injection Attacks: Is Your Data Secure? by Bert Wagner
This session will provide an overview of how SQL injection works and how to write injection-proof queries through a series of T-SQL demos. We’ll also take a look at why some commonly used techniques aren’t as secure as many people...
04.10.2018
Making Your Emergency Toolkit by Rich Benner
You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems. We will walk...
02.13.2018
Effective Unit Testing for SQL Server by Gavin Campbell
There are tools available from Microsoft, as well as from a number of third-party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline. This session is an attempt to get back...
02.06.2018
Uptight Database Security by Ronald Dameron
Do you work for an institution that fears its DBAs could go rogue on their production databases? Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak? Do you...
12.12.2017
Query Store and Query Optimization on SQL Server 2017 by Dean Savović
In this session, I will talk about advantages of Query Store, features, configuration and query optimization using Query Store on SQL Server 2017. The session will also cover how one can monitor query performance, how Query Store gathers data and...
11.28.2017
Networking Internals for the SQL Server Professional with Anthony Nocentino
In this session, we introduce how data moves between systems on networks, then look at TCP/IP internals. We’ll discuss real-world scenarios showing you how your network’s performance impacts the performance of your SQL Server and even your recovery objectives.
11.21.2017
Inside SQL Server In-Memory OLTP with Bob Ward
Based on the successful 500 Level talk at PASS 2016, this session will provide an internals view of how In-Memory OLTP works for SQL Server 2016 and 2017. Because this session is Advanced, it is intended for those that understand...
11.07.2017
Working with Dynamic Data Masking & Row Level Security with John Martin
Microsoft has introduced native capability to the database engine around masking sensitive data and restricting access at the row level. Allowing us new options for building more secure Data Platform solutions. However, it is important to understand the differences from...
10.24.2017
Enhancements That Will Make Your SQL Database Engine Roar, 2016SP1 Edition with Pedro Lopes
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions. This session will showcase several improvements in SQL Server, focusing on the latest enhancements that address some of the...
10.17.2017
Why TSQL was the Language of the Year with Terry McCann
TSQL was voted best programming language in 2013, let’s explore why! In this session we will look at what make SQL such a fascinating language. We will do this by working through a few real life development problems and common design...
10.10.2017
Monitoring Availability Groups with Tracy Boggiano
Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to...
09.19.2017
How to Evaluate if SQL 2016 In-Memory OLTP is Right for Your Workload with Ned Otter
In this session, we will explore In-Memory OLTP workload evaluation, use cases, architecture, capacity planning, data migration, hot/cold data, potential impact on disk-based workloads, and more. By the end of the session, you will have an understanding of how In-Memory OLTP...
09.05.2017
Why Defragmenting Your Indexes Isn't Helping with Brent Ozar
In just the first 15 minutes, you'll have a series of ah-ha moments when you realize that your daily index maintenance jobs might just be making the problem worse instead of better. Then, you'll learn what you need to do...
08.29.2017
Successful Production Deployments with Columnstore Index in SQL Server 2016 with Sunil Agarwal
Imagine your Data Warehouse is growing exponentially to multi-terabytes and you have been tasked to make analytics queries even faster while keeping the cost of storage low. Industry leading SQL Server 2016 columnstore technology can help you solve these...
08.22.2017
Green is good, Red is bad – Turning Your Checklists into Pester Tests with Rob Sewell
After this session, you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for management.
08.15.2017
SQL Server & Containers with Andrew Pruski
-Defining what containers are (benefits and limitations) -Configuring Windows Server 2016 to run containers -Installing the docker engine -Pulling/Pushing SQL images from/to the docker repository -Running SQL Server containers -Committing new SQL Server images -Exploring 3rd party options to run containers on previous versions of Windows...
08.08.2017
SQL Server and Continuous Integration with James Anderson
How do you know your database change won’t affect something you haven’t thought of? Database objects can have many dependent objects in the database and in the application. Keeping track of these dependencies can be difficult, especially if the database is...
08.01.2017
DBAs vs Developers: JSON in SQL Server 2016 with Bert Wagner
This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to...
07.25.2017
Keeping Up with Technology: Drinking from the Firehose with Eugene Meidinger
SQL Server releases every 2 years. SSMS releases every month. Power BI releases every week. It’s impossible to “keep up” with technology, and it’s foolish to try. Instead, you should realize you have a limited amount of TrainingBucks: time, energy...
07.11.2017
Getting CI Right for SQL Server with Alex Yates
This isn’t the dark ages anymore. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form...
06.20.2017
Azure SQL Databases: A Guided Tour by Mike Walsh
You know about the cloud but you’re not there yet. Is it hard? Is it easy? How do you get started? Come to this session and see for yourself. We’ll start with nothing and end up with a deployed Azure...
06.13.2017
Bringing DevOps to the Database by Steve Jones
DevOps is a hot topic in today’s software development world, however, most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be...
06.06.2017
SAN Primer for the DBA by Doug Bernhardt
When storage doesn't perform and scale it causes issues for SQL Server and can make DBA life extremely challenging. In many cases, SQL Server storage is provisioned on a SAN. However, very few DBAs even get to see a SAN or understand...
05.30.2017
SQL Server 2016 Features for Performance Tuning Lovers by Matan Yungman
It’s a work day, and you’re in front of your monitor battling a vicious query. You’ve already tuned a query or two in your life and have some tricks up your sleeve, but nothing seems to get this query down...
05.16.2017
Gems to Help You Troubleshoot Query Performance by Pedro Lopes
Query Store in SQL Server 2016 is one of the most relevant improvements for production DBAs. It introduces the concept of click-once mitigation approach to query performance regression. But that’s not the sum of all enhancements in the query performance...
05.09.2017
Worst Practices & Less Known Limitations for Columnstore Indexes by Niko Neugebauer
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one would expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ... Setting the...
05.02.2017
Introducing the SQL Server 2016 Query Store by Enrico van de Laar
With the release of SQL Server 2016, we were finally able to play with, in my opinion, one of the most exciting new features in SQL Server 2016, the Query Store! The Query Store serves as a flight recorder for...
04.25.2017
How to Use Parameters Like a Pro and Boost Performance by Guy Glantser
Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren’t aware of the crucial influence they have on query performance. In fact,...
03.28.2017
Management Studio Level-Up with Daniel Hutmacher
Move up to Management Studio Superstar with these great productivity tips! We’ll explore stuff like keyboard shortcuts, configuration options, how to keep your SSMS settings synchronized across multiple environments and other really useful everyday tricks and hacks. Think “hey, wait,...
03.14.2017
3 Common Mistakes to Kill SQL Server Performance with Pinal Dave
No one wants slow performance of their application. In this session, you will learn about three mistakes which DBA often do which kills SQL Server’s performance. We will understand what are those errors, why those particular errors are prevailing in the...
03.07.2017
DevOps 101 for data professionals – how your jobs will change with Alex Yates
In 2009 John Allspaw and Paul Hammond delivered the session “10 deploys per day – Dev & ops cooperation at Flickr.” In forty-six minutes they changed the way millions of people would think about the software delivery process for years...
02.28.2017
T-SQL User-Defined Functions, or: How to Kill Performance in One Easy Step with Hugo Kornelis
User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly...
02.21.2017
T-SQL: Bad Habits and Best Practices with Aaron Bertrand
Whether you are a developer, DBA, or anything in between, chances are you are not always following best practices when you write T-SQL. Unfortunately, many so-called “bad habits” aren’t always obvious, but can lead to poor performance, maintainability issues, and...
02.07.2017
High-Performance SQL Server Reporting Services: Lessons Learned with Bert Wagner
SQL Server Reporting Services (SSRS) is an easy-to-use tool for automating reports and creating highly visual dashboards. Although SSRS is easy to learn there are many tips and tricks that can improve your report building experience, not to mention make...
01.24.2017
SQL Server 2016 "Hidden Gems" with Adam Machanic
By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You've no doubt heard plenty about such features as Query Store, JSON...
01.17.2017
Keep It Simple, Make It Fast: The SQL Server Strategy at Stack Overflow with Greg Bray
Stack Overflow is the largest online community of developers, and the performance and reliability of our SQL Server databases are crucial to serving over 1.3 Billion page views each month with each rendered in ~10-20 milliseconds. The Site Reliability Engineering...
01.17.2017
SQL Server and PowerShell: Let’s Get Serious with Drew Furgiuele
Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away and it is definitely something worth learning to make your life as a SQL Server professional easier. In this session,...
01.17.2017
SQL Server 2016: It Just Runs Faster with Bob Ward
Based on the popular blog series, join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 “It Just Runs Faster”, focused on scalability and performance enhancements. This talk will discuss the improvements,...

What's GroupBy – Free SQL Server Training about?

Download our free app to listen on your phone

GroupBy – Free SQL Server Training episodes:

Architecting Availability Groups by Derik Hammer

SQL Injection Attacks: Is Your Data Secure? by Bert Wagner

Making Your Emergency Toolkit by Rich Benner

Effective Unit Testing for SQL Server by Gavin Campbell

Uptight Database Security by Ronald Dameron

Query Store and Query Optimization on SQL Server 2017 by Dean Savović

Networking Internals for the SQL Server Professional with Anthony Nocentino

Inside SQL Server In-Memory OLTP with Bob Ward

Working with Dynamic Data Masking & Row Level Security with John Martin

Enhancements That Will Make Your SQL Database Engine Roar, 2016SP1 Edition with Pedro Lopes

Why TSQL was the Language of the Year with Terry McCann

Monitoring Availability Groups with Tracy Boggiano

How to Evaluate if SQL 2016 In-Memory OLTP is Right for Your Workload with Ned Otter

Why Defragmenting Your Indexes Isn't Helping with Brent Ozar

Successful Production Deployments with Columnstore Index in SQL Server 2016 with Sunil Agarwal

Green is good, Red is bad – Turning Your Checklists into Pester Tests with Rob Sewell

SQL Server & Containers with Andrew Pruski

SQL Server and Continuous Integration with James Anderson

DBAs vs Developers: JSON in SQL Server 2016 with Bert Wagner

Keeping Up with Technology: Drinking from the Firehose with Eugene Meidinger

Getting CI Right for SQL Server with Alex Yates

Azure SQL Databases: A Guided Tour by Mike Walsh

Bringing DevOps to the Database by Steve Jones

SAN Primer for the DBA by Doug Bernhardt

SQL Server 2016 Features for Performance Tuning Lovers by Matan Yungman

Gems to Help You Troubleshoot Query Performance by Pedro Lopes

Worst Practices & Less Known Limitations for Columnstore Indexes by Niko Neugebauer

Introducing the SQL Server 2016 Query Store by Enrico van de Laar

How to Use Parameters Like a Pro and Boost Performance by Guy Glantser

Management Studio Level-Up with Daniel Hutmacher

3 Common Mistakes to Kill SQL Server Performance with Pinal Dave

DevOps 101 for data professionals – how your jobs will change with Alex Yates

T-SQL User-Defined Functions, or: How to Kill Performance in One Easy Step with Hugo Kornelis

T-SQL: Bad Habits and Best Practices with Aaron Bertrand

High-Performance SQL Server Reporting Services: Lessons Learned with Bert Wagner

SQL Server 2016 "Hidden Gems" with Adam Machanic

Keep It Simple, Make It Fast: The SQL Server Strategy at Stack Overflow with Greg Bray

SQL Server and PowerShell: Let’s Get Serious with Drew Furgiuele

SQL Server 2016: It Just Runs Faster with Bob Ward