GroupBy – Free SQL Server Training

We retired this podcast, because we couldn't parse it for 10 consecutive times.

http://static.libsyn.com/p/assets/8/5/d/f/85dfeeee7393e568/GroupBy-Artwork.png

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.

Website: https://groupby.org
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.
Language: 🇬🇧 English
last modified: 2019-05-03 11:58
last episode published: 2019-02-12 11:00
publication frequency: 10.35 days
Contributors: GroupBy is free technical training by the community, for the community.; Author; Brent Ozar; Owner
Explicit: false
Number of Episodes: 74
Rss-Feeds: Detail page
Categories: Education Software How-To Technology Training Science & Medicine

0 Likes 0 Followers 1 Subscribers

Sign up / Log in to like, follow, recommend and subscribe!

Recommendations

Episodes

Date	Title & Description	Contributors
2019-02-12	Using 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 ...
2019-02-05	Columnstore 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 w...
2019-01-29	The 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, Ag...
2019-01-22	How 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 my...
2019-01-15	What ‘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 industri...
2019-01-08	New 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, an...
2018-10-23	An 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 Pa...
2018-10-16	Make 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 tips ...
2018-10-09	T-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 meth...
2018-10-02	Be 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 develop ...