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



All Episodes
Now displaying: March, 2017
Mar 28, 2017

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, how’d you do that!?”

Did you, for instance, know that you can hold down the Alt key while selecting text? The “Alt trick” works for copying, pasting, moving, even typing. Handy if you want to re-use text horizontally instead of just vertically. Like comparing the contents of columns in two tables

Some of the other things I’ll cover:

- Previewing and quick-reference stuff you can do with keyboard shortcuts
- Quickly navigating your code to find errors or bookmarks

No undocumented stuff, no registry editor, and nothing you wouldn’t put into production. Just really clever productivity tips that will take some of the burden off your everyday work.

But I’m not going to sugarcoat it. Your code may still run slow, and you’ll probably write just as many bugs – but you’ll write them quicker and with so much more style and panache.


Mar 21, 2017

Let’s face it, using SQL PowerShell prior to SQL Server 2016 was like installing training wheels on a Ducati. But things have massively changed. Your community feedback was incorporated before SQL 2016 shipped and presto, SQL PowerShell is actually useful all of a sudden.

But it gets better! The SQL Tools team at Microsoft has promised to keep adding new cmdlets every month and keep making improvements to the SQL Provider.

SQL PowerShell offers faster ways to manage SQL Servers, develop & deploy SQL databases, and identify performance bottlenecks. I will show you these new features in the new SqlServer module and why you will find it useful, whether you are a SQL Developer, B/I Developer, or DBA.

The SQL Server team has already delivered cmdlets to help you manage SQL Server Agent Jobs, review the SQL Error Log, Add / Manage & Remove Logins, and write data to tables in SQL Server.

2017 promises even more cmdlets and you don’t want to be left behind!

(P.S. That picture of the TreeMap up there, that was generated in PowerShell and I will show you why it’s so awesome for Performance Tuning.)

Mar 14, 2017

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 industry and how we can fix it.

We will explore various settings as well as code which will kill SQL Server Performance. At the end of this session, every attendee will receive scripts which will help them improve their SQL Server’s performance. This session is of intermediate level – you just have to know a little bit about SQL Server and a lot more you will learn in this session. The session is carefully crafted from the real world experience for DBA so they can learn tricks which can help them to improve their server’s performance.

We will discuss various SQL Server Settings, File Placements as well as ignored details related to SQL Server Performance.

Mar 7, 2017

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 to come. It didn’t have a name yet, but DevOps was born. DevOps folk preached about the cloud, automation, rapid delivery and any database technology that wasn’t relational…

In 2013 Kenny Gorman declared “The DBA is Dead”.

For the record, I don’t believe that, but a lot of people do. What is certain is that the world of IT is changing, and the traditional DBA role, and most other data roles, are changing with it.

I’m going to explain what DevOps is, where it came from, and its implications for SQL Server. We’ll cover the human and technical basics of database DevOps – and I’m going to discuss some changes that data folk need to make.