GroupBy – Free SQL Server Training
By Brent Ozar
To listen to an audio podcast, mouse over the title and click Play. Open iTunes to download and subscribe to podcasts.
Description
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.
| Name | Description | Released | Price | ||
|---|---|---|---|---|---|
|
1 |
CleanUsing Open Source Products to Collect Performance Metrics by Tracy Boggiano | Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and.. | 2/12/2019 | Free | View in iTunes |
|
2 |
CleanColumnstore Indexes: What are waiting for? by Niko Neugebauer | Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those strange and weird HT_* waits stand for ? Why do we... | 2/5/2019 | Free | View in iTunes |
|
3 |
CleanThe Problems With Optional Operators by Erik Darling and Joe Obbish | The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer will make optimal choices. Often, the optimizer will stick an optional operator in a plan that just doesn’t belong. Sorts, Spools, Lookups, Tops,.. | 1/29/2019 | Free | View in iTunes |
|
4 |
CleanHow to get your dream job: Resume & job hunting tips by Andy Mallon | What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream. In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing... | 1/22/2019 | Free | View in iTunes |
|
5 |
CleanWhat ‘Digital Transformation’ Means, and How You Can Use It to Advance Your Career by Kendra Little | Whether you love or hate buzzwords, the big ones signify critical cultural changes. In this session, Kendra Little will explain what executives mean when they describe a 'digital transformation', why this transformation is happening across all... | 1/15/2019 | Free | View in iTunes |
|
6 |
CleanNew Engine Features in SQL Server 2019 by Aaron Bertrand | A new release of SQL Server is like a new season of your favorite TV show. Some releases in the past were lacking; I always felt like SQL Server 2008 R2 was about as exciting as the Seinfeld finale. But Microsoft hasn't disappointed in recent years,... | 1/8/2019 | Free | View in iTunes |
|
7 |
CleanAn Introduction to Partitioning by DBAfromthecold | This mainly demo-based session will cover the following: An introduction to partitioning, core concepts, and benefits. Choosing a Partitioning Key Creating Partition Functions & Schemes Indexing Considerations Splitting, Merging & Switching... | 10/23/2018 | Free | View in iTunes |
|
8 |
CleanMake Your Own SQL Server Queries Go Faster by John Sterrett | Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning. In this session, you will learn some T-SQL performance tuning... | 10/16/2018 | Free | View in iTunes |
|
9 |
CleanT-SQL Tools: Simplicity for Synchronizing Changes by Martin Perez | One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems. In this session we will look into different methods focusing on effective use of T-SQL and explore how these... | 10/9/2018 | Free | View in iTunes |
|
10 |
CleanBe My Azure DBA (DSA) by Paul Andrew | There seems to be a common misconception that once you move from on premises SQL Server to Azure PaaS offerings a DBA is no longer required. This perception is wrong and in the session I’ll show you why. As a business intelligence consultant I... | 10/2/2018 | Free | View in iTunes |
|
11 |
CleanThe Perfect Index by Arthur Daniels | Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It's not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come from vendor applications, ORM... | 9/25/2018 | Free | View in iTunes |
|
12 |
CleanNot just polish – How good code also runs faster by Daniel Hutmacher | I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won’t change a lot of code, won’t generate weeks of testing and validation for your colleagues and... | 9/18/2018 | Free | View in iTunes |
|
13 |
CleanThe Agile DBA: A Guide to Database DevOps with SSDT by Ryan Booz | As the DBA for an Agile, Sprint-based team, you may feel like the bottleneck at every turn. You’ve stuck with the existing processes and tools because it’s what you know. After all, “If it ain’t broke, don’t fix it!” Right? I have... | 7/10/2018 | Free | View in iTunes |
|
14 |
CleanGetting Better Query Plans by Improving SQL’s Estimates by Brent Ozar | You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RECOMPILE). It's served you well, but every now and then, you hit a problem you can't solve. Your data's been... | 7/3/2018 | Free | View in iTunes |
|
15 |
CleanAdvanced Query Tuning Techniques by Guy Glantser | You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now... | 6/26/2018 | Free | View in iTunes |
|
16 |
CleanHow to Monitor Everything by Maria Zakourdaev | Today's applications are not using monolithic approach anymore and evolving into micro-services architecture. Monitoring tools are also evolving, micro-services approach have stepped into this area as well. What you should do if you have several... | 6/19/2018 | Free | View in iTunes |
|
17 |
CleanColumnstore Clustered vs Nonclustered, When to Choose What by Niko Neugebauer | The incredible Columnstore Indexes can increase your analytical query processing speed multiple times, they are updatable (Clustered from SQL Server 2014 and Nonclustered from SQL Server 2016 respectively), but they keep on supporting different sets... | 6/12/2018 | Free | View in iTunes |
|
18 |
CleanSQL Server Containers and Clones by Paul Stanton | Microsoft emphasizes use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database cloning for the full range of the SQL Server family. We’ll explore... | 5/8/2018 | Free | View in iTunes |
|
19 |
CleanSQL Server 2017 Community Driven Enhancements by Javier Villegas | Will cover all new SQL 2017 features that the Data Platform Community has requested and Microsoft has included in the next major version of SQL Server. 200 level | 5/1/2018 | Free | View in iTunes |
|
20 |
CleanArchitecting Availability Groups by Derik Hammer | This session will cover 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. It will also... | 4/24/2018 | Free | View in iTunes |
|
21 |
CleanSQL Injection Attacks: Is Your Data Secure? by Bert Wagner | SQL injection is one of the most common ways that hackers gain access to your SQL server. Do you know how to harden your queries and protect your data from malicious users? This session will provide an overview of how SQL injection works and how to... | 4/17/2018 | Free | View in iTunes |
|
22 |
CleanMaking 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 through scripts that will... | 4/10/2018 | Free | View in iTunes |
|
23 |
CleanEffective 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 isn't about any... | 2/13/2018 | Free | View in iTunes |
|
24 |
CleanUptight 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 have concerns that the DBA.. | 2/6/2018 | Free | View in iTunes |
|
25 |
CleanThe Junior SQL Developer’s Kick-Start by Doug Lane | Congratulations on your recent move into the world of SQL Server development! You've got a handle on the basics -- SELECT, INSERT, UPDATE, and DELETE -- but now what? How do you know what's important to learn next, and what's most likely a waste of... | 1/30/2018 | Free | View in iTunes |
|
26 |
CleanImproving SELECT * Query Performance by Erik Darling | You’re a DBA or Developer, and you have a gut feeling that these simple queries with an egregious number of columns in the SELECT list are dragging your server down. You’re not quite sure why, or how to index for them. Worst of all, no one seems... | 1/23/2018 | Free | View in iTunes |
|
27 |
CleanWriting your own encryption routines in SQL… and then cracking them by David Fowler | I’m going to look into the basics of how encryption works and then we’ll learn how we can go about writing our own encryption routines within SQL Server. When we’re happy that those routines are secure, we’ll look at ways that we can go about... | 1/16/2018 | Free | View in iTunes |
|
28 |
CleanThe Smart Way to Troubleshoot SQL Server Cluster and Availability Group Outages by Edwin M Sarmiento | SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). But when mission-critical databases go offline, bringing them back online could be a nerve-wracking experience. This... | 1/9/2018 | Free | View in iTunes |
|
29 |
CleanSQL Server Health Checks by Eugene Meidinger | You’ve just been handed a SQL Server, and you need to make sure there aren’t any skeletons in the closet. What things should you check to make sure everything is healthy? In this presentation, we’ll run you through the checklist I use when I... | 1/2/2018 | Free | View in iTunes |
|
30 |
CleanSQL Server R Services in SQL 2016 by Chris Hyde | One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and.. | 12/26/2017 | Free | View in iTunes |
|
31 |
CleanElegant T-SQL Solutions for Real World Problems by Matan Yungman | T-SQL can help solve many problems you are faced with at your job. Each problem can have many solutions, but not every solution is simple to write, understand and maintain, and not every solution is good in terms of performance. In this session, we... | 12/19/2017 | Free | View in iTunes |
|
32 |
CleanQuery Store and Query Optimization on SQL Server 2017 by Dean Savović | The advantages of Query Store, features, configuration and query optimization using Query Store on SQL Server 2017 | 12/12/2017 | Free | View in iTunes |
|
33 |
CleanNetworking Internals for the SQL Server Professional with Anthony Nocentino | how data moves between systems on networks & look at TCP/IP internals | 11/28/2017 | Free | View in iTunes |
|
34 |
CleanInside SQL Server In-Memory OLTP with Bob Ward | An internals view of how In-Memory OLTP works for SQL Server 2016 and 2017 | 11/21/2017 | Free | View in iTunes |
|
35 |
CleanSQL Server Infernals - A Beginner's Guide to SQL Server Worst Practices with Gianluca Sartori | A Beginner's Guide to SQL Server Worst Practices | 11/14/2017 | Free | View in iTunes |
|
36 |
CleanWorking 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... | 11/7/2017 | Free | View in iTunes |
|
37 |
CleanModern Data Warehousing: The New Approach to Azure BI with Simon Whiteley | The movement of data through batch and speed layers via Azure Data Lake Store & Analytics, Data Factory, SQL Datawarehouse and Streaming Analytics, and a quick look at Azure Analysis Services with PowerBI | 10/31/2017 | Free | View in iTunes |
|
38 |
CleanEnhancements That Will Make Your SQL Database Engine Roar, 2016SP1 Edition with Pedro Lopes | Several improvements in SQL Server, focusing on the latest enhancements that address some of the most common customer pain points the Database Engine, involving tempdb, new CE, memory management, T-SQL constructs as well as diagnostics for troubleshooti | 10/24/2017 | Free | View in iTunes |
|
39 |
CleanWhy TSQL was the Language of the Year with Terry McCann | TSQL was voted best programming language in 2013, let’s explore why! | 10/17/2017 | Free | View in iTunes |
|
40 |
CleanMonitoring Availability Groups with Tracy Boggiano | Once you have successfully configured Availability Groups, what comes next? | 10/10/2017 | Free | View in iTunes |
|
41 |
CleanStatistics 101 with Steph Locke | Real-time data capture and taking an intuitive and visual approach through summary statistics right up to understanding how to produce simple predictive models | 10/3/2017 | Free | View in iTunes |
|
42 |
CleanHow to Evaluate if SQL 2016 In-Memory OLTP is Right for Your Workload with Ned Otter | In-Memory OLTP workload evaluation, use cases, architecture, capacity planning, data migration, hot/cold data, potential impact on disk-based workloads, and more | 9/19/2017 | Free | View in iTunes |
|
43 |
CleanWhy Defragmenting Your Indexes Isn't Helping with Brent Ozar | Why your daily index maintenance jobs might just be making the problem worse instead of better and what you need to do instead | 9/5/2017 | Free | View in iTunes |
|
44 |
CleanSuccessful 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... | 8/29/2017 | Free | View in iTunes |
|
45 |
CleanGreen is good, Red is bad – Turning Your Checklists into Pester Tests with Rob Sewell | How Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for management | 8/22/2017 | Free | View in iTunes |
|
46 |
CleanSQL Server & Containers with Andrew Pruski | Attendees will be taken through the following: 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.. | 8/15/2017 | Free | View in iTunes |
|
47 |
CleanSQL Server and Continuous Integration with James Anderson | How a CI approach to database development can remove the unknowns from deploying database changes | 8/8/2017 | Free | View in iTunes |
|
48 |
CleanDBAs vs Developers: JSON in SQL Server 2016 with Bert Wagner | This session will explore the new JSON functionality introduced in SQL Server 2016 | 8/1/2017 | Free | View in iTunes |
|
49 |
CleanKeeping Up with Technology: Drinking from the Firehose with Eugene Meidinger | A roadmap for how to focus your training and grow your career | 7/25/2017 | Free | View in iTunes |
|
50 |
CleanT-SQL for Beginners with Andrea Allred | T-SQL for Beginners | 7/18/2017 | Free | View in iTunes |
|
51 |
CleanGetting CI Right for SQL Server with Alex Yates | How to use tSQLt to build a suite of automated tests to give you confidence in the quality of your code & how to use tSQLt to build a suite of automated tests to give you confidence in the quality of your code. Then I’ll talk through various ways to | 7/11/2017 | Free | View in iTunes |
|
52 |
CleanOperational Validation of SQL Server at Scale with PowerShell and Jenkins with Cody Konior | How to integrate PowerShell with Jenkins and multi-thread efficiently in the background with PoshRSJob using ready-to-go templates so you don’t need to worry about how it works | 7/4/2017 | Free | View in iTunes |
|
53 |
CleanHacking SQL Server by André Melancia | Examples of how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace | 6/27/2017 | Free | View in iTunes |
|
54 |
CleanAzure SQL Databases: A Guided Tour by Mike Walsh | How easy it is to deploy a database in Azure | 6/20/2017 | Free | View in iTunes |
|
55 |
CleanBringing DevOps to the Database by Steve Jones | Bringing DevOps to the Database: Automated building and testing of your code on a separate environment and the generation of an upgrade script that a DBA and developer can review and deploy to QA, test, staging, production, or any other environment | 6/13/2017 | Free | View in iTunes |
|
56 |
CleanSAN Primer for the DBA by Doug Bernhardt | What a SAN is, how it works, and why it's typically used vs. direct attached storage | 6/6/2017 | Free | View in iTunes |
|
57 |
CleanSQL Server 2016 Features for Performance Tuning Lovers by Matan Yungman | SQL Server 2016 different performance tuning aspects the new features enhance: Execution plan history and enforcement using the Query Store, live query execution visualization, DMV enhancements, new query hints, and more | 5/30/2017 | Free | View in iTunes |
|
58 |
CleanCrash Course on Better SQL Development by Vladimir Oselsky | Discover better SQL development tips, tools and strategies | 5/23/2017 | Free | View in iTunes |
|
59 |
CleanGems to Help You Troubleshoot Query Performance by Pedro Lopes | Ranging from new xEvents to Showplan improvements, from LQS (and underlying infrastructure) to the revised Plan Comparison tool, learn how these can help you streamline the process of troubleshooting query performance and gain faster insights | 5/16/2017 | Free | View in iTunes |
|
60 |
CleanWorst Practices & Less Known Limitations for Columnstore Indexes by Niko Neugebauer | Discover the words practices and known limitation for columnstore indexes | 5/9/2017 | Free | View in iTunes |
|
61 |
CleanIntroducing the SQL Server 2016 Query Store by Enrico van de Laar | A thorough look at the Query Store, its architecture, the performance impact of enabling the Query Store, DMVs, the built-in reporting and the custom Query Store Dashboard | 5/2/2017 | Free | View in iTunes |
|
62 |
CleanHow to Use Parameters Like a Pro and Boost Performance by Guy Glantser | Plan caching and how the query optimizer handles parameters, the pros and cons of parameter sniffing, and how to identify performance problems caused by poor parameter handling | 4/25/2017 | Free | View in iTunes |
|
63 |
CleanManagement Studio Level-Up with Daniel Hutmacher | Move up to Management Studio Superstar with these great productivity tips! | 3/28/2017 | Free | View in iTunes |
|
64 |
CleanIntroduction to SQL PowerShell (the awesome new 2016 version)! with Aaron Nelson | New SQL PowerShell features and why you will find them useful, whether you are a SQL Developer, B/I Developer, or DBA | 3/21/2017 | Free | View in iTunes |
|
65 |
Clean3 Common Mistakes to Kill SQL Server Performance with Pinal Dave | The three mistakes DBA often make that kill SQL Server’s performance | 3/14/2017 | Free | View in iTunes |
|
66 |
CleanDevOps 101 for data professionals – how your jobs will change with Alex Yates | What DevOps is, where it came from, and its implications for SQL Server | 3/7/2017 | Free | View in iTunes |
|
67 |
CleanT-SQL User-Defined Functions, or: How to Kill Performance in One Easy Step with Hugo Kornelis | How user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance | 2/28/2017 | Free | View in iTunes |
|
68 |
CleanT-SQL: Bad Habits and Best Practices with Aaron Bertrand | T-SQL bad habits, how they develop, and how you can avoid them | 2/21/2017 | Free | View in iTunes |
|
69 |
CleanPower BI Dashboard in an hour with Various Examples with Vishal Pawar | How Power BI can transform your company's data into rich visuals and easy yet powerful Analytics solutions for your whole organization | 2/14/2017 | Free | View in iTunes |
|
70 |
CleanHigh-Performance SQL Server Reporting Services: Lessons Learned with Bert Wagner | Lessons learned from the past six years of developing high-performance SSRS reports | 2/7/2017 | Free | View in iTunes |
|
71 |
CleanSQL Server 2016 "Hidden Gems" with Adam Machanic | Very cool SQL Server 2016 features that don't usually make the top 10 lists | 1/24/2017 | Free | View in iTunes |
|
72 |
CleanKeep It Simple, Make It Fast: The SQL Server Strategy at Stack Overflow with Greg Bray | How Stack Overfow uses Availability Groups (AGs) to scale out the SQL workload and meet our current HA/DR needs, as well as future plans to use Distributed AGs to solve a pesky issue called “the speed of light” | 1/17/2017 | Free | View in iTunes |
|
73 |
CleanSQL Server and PowerShell: Let’s Get Serious with Drew Furgiuele | Practical, real-world examples of how you can blend SQL Server and PowerShell together | 1/17/2017 | Free | View in iTunes |
|
74 |
CleanSQL Server 2016: It Just Runs Faster with Bob Ward | A deep dive and a behind the scenes look at how SQL Server 2016 “It Just Runs Faster”, focused on scalability and performance enhancements | 1/17/2017 | Free | View in iTunes |
| 74 Items |
Customer Reviews
Like a user group, but online
I can never get to my local user group meetings, but this lets me hear amazing presenters on my drive home from work. A+++
Great Initiative By Brent And GroupBy
I am a fan of Brent and a regular reader of his daily mail subscription [ At least try to get the summary, Ha Ha Ha ]. The initiative for the GroupBy sessions are really great for me and a lot of information helps me to know that I don’t know anything yet !!! Thanks to him and the team who shares such nice knowledge for the community.
Listeners also subscribed to
- Dear SQL DBA
- Kendra Little
- View in iTunes
- SQL Server Radio
- Matan Yungman, Guy Glantser
- View in iTunes
- SQL Data Partners Podcast
- Carlos L Chacon
- View in iTunes
- SQL Down Under
- Dr Greg Low
- View in iTunes