GroupBy September Sessions Online

Thanks to the intrepid work of Pavel, our AV sorcerer, you can now watch last week’s GroupBy sessions online completely. As always, it’s all free thanks to our volunteer speakers:

You can also subscribe to our podcast, follow our YouTube channel, download our iOS app, or get our Android app. Enjoy!

Read More

Vote Now to Pick the December #GroupBy Conference Lineup

At GroupBy, your votes pick the conference lineup. Anybody can submit an abstract on any topic, and then the choice is yours.

Here’s the sessions in the running for December’s online conference. Tell us what you want to see by voting now, and voting closes September 8th.

Which 10 sessions do you want to see for December

  • Improving SELECT * Query Performance by Erik Darling (9%, 117 Votes)
  • Elegant T-SQL Solutions for Real World Problems by Matan Yungman (8%, 105 Votes)
  • SQL Server Health Checks by Eugene Meidinger (8%, 103 Votes)
  • The Smart Way to Troubleshoot SQL Server Cluster and Availability Group Outages by Edwin M Sarmiento (7%, 86 Votes)
  • Uptight Database Security by Ronald Dameron (7%, 85 Votes)
  • Query Store and Query Optimization on SQL Server 2017 by Dean Savović (7%, 82 Votes)
  • Effective Unit Testing for SQL Server by Gavin Campbell (6%, 81 Votes)
  • The Junior SQL Developer's Kick-Start by Doug Lane (6%, 80 Votes)
  • Writing your own encryption routines in SQL... and then cracking them by David Fowler (6%, 79 Votes)
  • Cardinality Estimator on SQL Server 2014/2016 by Dean Savović (6%, 73 Votes)
  • SQL Server R Services in SQL 2016 by Chris Hyde (5%, 61 Votes)
  • 20M+ fines and prison: General Data Protection Regulation (GDPR) is coming. What does this mean for DLM? by Alex Yates (4%, 55 Votes)
  • Polybase In Action by Kevin Feasel (4%, 44 Votes)
  • Off I Go Into the Wild Azure Yonder by Ronald Dameron (3%, 43 Votes)
  • A Deep Dive Into Data Lakes by Ust Oldfield (3%, 37 Votes)
  • Power BI Newbie Hour: Panel Q/A by Eugene Meidinger (3%, 36 Votes)
  • Just Enough Database Theory for Power BI by Eugene Meidinger (3%, 33 Votes)
  • Power BI Internals: Deep Dive by Eugene Meidinger (2%, 25 Votes)
  • An (Advanced) Introduction to DAX by Eugene Meidinger (2%, 22 Votes)
  • ZZZ (Removed - Terry presented in September) (0%, 6 Votes)

Total Voters: 203

Loading ... Loading ...
Read More

June GroupBy Intermission Recordings are Online

Wanna hear the presenters talk shop? Here’s the intermissions from this month:

James Anderson, Rob Sewell, Andrew Prust, Bert Wagner, and Brent Ozar talk about why Microsoft might want to run SQL Server on Linux, presentation disasters, the DBAtools and DBAreports open source projects. At 42 minutes in, Drew Furgiuele joins and shows the High Altitude SQL Server Project’s balloon gear:

Discussing database devops, being on-call, currency exchange, car crash videos, and what it’s like being a Stack Overflow moderator with James Anderson, Bert Wagner, Daniel Hutmacher, Aaron Bertrand, and Brent Ozar:

Rob Sewell, Bert Wagner, Drew Furgiuele, and Brent Ozar talk about the SQLbits costume party, the ham radio gear in the High Altitude SQL Server Project, how they’ll calculate where the balloon will land, Bert’s car mechanic hobby, and Brent’s extremely bad taste in cars:

We talk about our guilty pleasures, Pinal Dave explains the Indian McDonald’s vegetarian menu, and Andrea Allred shows up in full princess garb:

Alex Yates and Adam Machanic debate about testing databases through the app rather than database unit testing, and then Andrea Allred, Pinal Dave, Drew Furguiele, and Richie Rump talk about princesses:

Cody Konior and Aaron Nelson talk about Jojoba and the PowerShell gallery:

Wanna hang out and chat with the presenters? Registration for September’s live sessions is open now.

Oops! We could not locate your form.

Read More

#GroupBy September 2017 Lineup Announced, Registration Open

The voting is over, and here’s what you picked:

Friday, September 1:

Friday, September 8:

Congratulations to the winners, and registration is open now. Wanna join in the fun and present a session yourself? Submit a session now for the December 1 & 8 event.

Oops! We could not locate your form.

Read More

Missed #GroupBy last week? The recordings are up now.

If you missed ’em live, now you can watch from the comfort of your, uh, wherever you are.

If you have questions for the presenters, click on the session title to hit the session page. From there, you can leave comments on the abstract, and the speakers get emails for each comment. You can rate the sessions too, or just tell the speakers how much you liked their work.

Wanna get in on the fun? Abstract submissions are open now for the December 1 & 8 events, and you can register now to attend the September events live.

Containers & SQL Server

Andrew Pruski (@DBAfromtheCold –

Continuous Integration and SQL Server

James Anderson (@DatabaseAvenger –

DBAs vs Developers: JSON in SQL Server 2016

Bert Wagner (@BertWagner –

Getting Continuous Integration Right for SQL Server

Alex Yates (@_AlexYates_ –

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

Rob Sewell (@SQLDBAWithBeard –

Keeping Up with Technology: Drinking from the Firehose

Eugene Meidinger (@SQLGene –

Operational Validation of SQL Server at Scale with PowerShell and Jenkins

Cody Konior (@CodyKonior –

Successful Production Deployments with Columnstore Index in SQL Server 2016

Sunil Agarwal (@S_u_n_e_e_l)

T-SQL for Beginners

Andrea Allred (@RoyalSQL –

Read More

Vote Now to Pick the September #GroupBy Conference Lineup

GroupBy is a free online conference by the community, for the community. Anyone can submit an abstract on any topic, and then you, dear reader, get to pick the conference lineup.

Here’s the sessions in the running for GroupBy September – tell us what you want to see by voting now.

Which 10 sessions do you want to see for September

  • Why Defragmenting Your Indexes Isn’t Helping by Brent Ozar (8%, 214 Votes)
  • Inside SQL Server In-Memory OLTP by Bob Ward (5%, 142 Votes)
  • Enhancements that will make your SQL database engine roar – 2016 SP1 Edition by Pedro Lopes (5%, 131 Votes)
  • Statistics 101 by Steph Locke (4%, 115 Votes)
  • Networking Internals for the SQL Server Professional by Anthony Nocentino (4%, 115 Votes)
  • Monitoring Availability Groups by Tracy Boggiano (4%, 101 Votes)
  • From 0 to 1bn transactions a month on a shoestring budget by Steph Locke (4%, 101 Votes)
  • Why TSQL was the language of the year by Terry McCann (4%, 101 Votes)
  • How to evaluate if SQL 2016 In-Memory OLTP is right for your workload by Ned Otter (3%, 92 Votes)
  • Modern Data Warehousing – The new approach to Azure BI by Simon Whiteley (3%, 91 Votes)
  • Working with Dynamic Data Masking & Row Level Security by John Martin (3%, 89 Votes)
  • Azure SQL Database – Managing your database on the cloud by Vitor Fava (3%, 88 Votes)
  • R for reporting by Steph Locke (3%, 85 Votes)
  • Azure SQL Data Warehouse : 101 by John Martin (3%, 82 Votes)
  • Is the cloud cost effective? by Steph Locke (3%, 80 Votes)
  • Architecture and Customer Case Studies with In-Memory OLTP by Jos de Brujin (3%, 75 Votes)
  • Measuring the Overhead of the Query Store by Jason Hall (3%, 74 Votes)
  • Build your first bot – no code required! by Steph Locke (3%, 70 Votes)
  • Linux OS Fundamentals for the SQL Admin by Anthony Nocentino (2%, 61 Votes)
  • We need DataOps – NOW by Steph Locke (2%, 59 Votes)
  • NoSQL Server: JSON superpowers! by Davide Mauri (2%, 55 Votes)
  • Azure SQL Database – Scaling In and Scaling Out using elastic pool by Vitor Fava (2%, 55 Votes)
  • SQL Server on Linux – SQL Server vNext goes cross platform! by David Williams (2%, 52 Votes)
  • Data + Docker = Discombobulating? by Steph Locke (2%, 52 Votes)
  • War of the Indices- SQL Server vs. Oracle by Kellyn Gorman (2%, 51 Votes)
  • Preparing your business for data science by Steph Locke (2%, 51 Votes)
  • Optimizing your SQL Server for Azure VMs by Parikshit Savjani (2%, 46 Votes)
  • SQLDockit – SQL inventory and best practices on steroids by Frane Borozan (2%, 43 Votes)
  • Analysis Services Development with Biml Studio by Reeves Smith (2%, 42 Votes)
  • TFS Database backups/restore by Uche Okoye (1%, 37 Votes)
  • Open Source PowerShell Core on Linux and Mac by Anthony Nocentino (1%, 37 Votes)
  • Monitoring Linux Performance for the SQL Server Admin by Anthony Nocentino (1%, 33 Votes)
  • Get Spatial With It by Michael Henderson (1%, 33 Votes)
  • Dapper: the microORM that will change your life by David Mauri (1%, 32 Votes)
  • Apache Zeppelin and SQL Server: two best friends by Davide Mauri (1%, 30 Votes)
  • Working with Azure Data Factory & Creating Custom Activities by Paul Andrew (1%, 28 Votes)

Total Voters: 352

Loading ... Loading ...
Read More