Hey, wanna learn about SQL Server for free?
Feb 7 – PASS Data Expert Series: PASS is taking the top-rated Summit 2018 recordings and replaying them live, for free, on a webcast. I’ll be in the chat room too, taking your questions. Register here, and the lineup includes:
- SSMS & T-SQL Tricks with Bob Pusateri – 11AM Eastern
- Fix My Functions with Kendra Little – 12:20PM
- Getting Better Query Plans with me – 1:40PM
- Performance Tips and Tricks with Pinal Dave – 3:00PM
- SQL Server with Containers with Bob Ward – 4:20PM
- Building Trust in Teams with Richard Campbell – 5:40PM
Jan 25 – How to Think Like the Engine: You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this 90-minute class, you’ll learn how the SQL Server engine looks at your indexes and builds your query results.
Feb 1 – Getting Started with the Consulting Toolkit: SQL Server consultants: you need an easy way to run an app, gather lots of diagnostic data, save it to a portable spreadsheet that you can analyze later. Even better, you want an app that your clients can run when their server is having problems but you’re not around – and then send that spreadsheet to you so you can diagnose problems after they’ve happened. That’s my new Consultant Toolkit. In this webcast, I’ll show you how to get it for free, start using it, and teach your clients how to use it.
Feb 8 – An Introduction to GitHub for DBAs: Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? I’m with you: I’m Brent Ozar, and I hated GitHub. For years, I struggled with it, but I’ve come to a gradual truce. I’m not a GitHub pro by any means, but in the span of one session, I can explain the most important terms to you in a way that’ll make sense for non-developers. I’ll show you how to contribute to someone else’s open source project, and how to get started putting your own scripts under source control.
Feb 15 – How to Capture Baselines with sp_BlitzFirst: You’re responsible for performance tuning SQL Server, and you’ve heard the same advice a bunch of times: “You should set a performance baseline.” But what does that even mean? And how do you do it? What metrics should you gather? How often should you gather them, and how much history should you keep? I’m a performance tuning DBA with a couple decades of experience, and I’ll show you how to capture baselines by setting up the free, open source sp_BlitzFirst to run in an Agent job every 15 minutes. You’ll also learn how to use the free Power BI Dashboard to read the baseline metrics.