Upcoming Free Training Webcasts

Brent Ozar WebcastHey, 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.

Register now. If you can’t make it live, no worries – the videos will be on our YouTube channel too.

  • This field is for validation purposes and should be left unchanged.
Previous Post
SQL Server Perfmon counters that are still interesting in 2019
Next Post
Wanna see Erik Darling as Freddie Mercury at #SQLbits?

2 Comments. Leave new

  • When should I expect the Pony to arrive? How old is the pony? Can you send a picture of its teeth? How many hands high is it?
    ;-P

    Reply
  • Thank you so much, I’ve already found many helpful tips here.
    I’m desperately looking for a way of working out this on my company Indiaaccess and Hostasp database server

    Thanks for your info

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}