Oct
30
to Nov 1

Online Class -- SQL Server Internals 201

 

Online class offered through Brent Ozar Unlimited

Register here

You’re a developer or database administrator, and you’re curious.

You love learning about the internals of the tools you use. You’re comfortable writing queries and creating tables, but you don’t always understand why a particular index gets used, and another one does not. You’re not sure when SQL Server chooses to reuse an existing query plan, versus when it decides to create a new one.

You’ve been to a few 1-hour “how to tune indexes” or “how to tune queries” sessions at your local user group, SQLSaturdays, or online, and you’re ready to dig deeper. You’ve run common industry tools like sp_WhoIsActive, sp_BlitzIndex, and sp_BlitzCache, but now you want to learn where those tools get their data from.

You’re ready for SQL Server Internals 201.

This is a 2-day class offered on the following dates:
     August 29-30, 2018
     October 30 and November 1, 2018

 

View Event →
Oct
25
9:00 AM09:00

Online Class -- Faster Transactions Without NOLOCK

Online class offered through Brent Ozar Unlimited

Register here

You’re a developer with an application that’s grown over time, and its performance has started to degrade. When your users change data with inserts/updates/deletes, they are reporting random slowdowns. The more users you get, the worse performance becomes – and you’re not allowed to purge or archive data, either.

How are you supposed to handle concurrency and scale? You don’t have a senior DBA you can escalate these problems to – maybe you work for a software vendor. (Or maybe you’re the DBA, and this is the first time you’ve hit the notorious locking, blocking, and deadlocking walls.)

Good news: SQL Server has options to help – and we’re not talking about NOLOCK.

Dates Available:  
     August 23, 2018
     October 25, 2018

View Event →
Jul
11
6:00 PM18:00

Speaking at REDMOND SQL Server User Group

 

Query Plan Options

What are the options available for looking at your query plans? When is one option better than another? What’s the difference between an estimated plan and an actual plan? In this session, we’ll look at why getting familiar with just looking at plans is the best first step to query tuning. We’ll also look at some of the latest additions to query plans, including Live Query Statistics, available starting in SQL Server 2016.

Download the slides and demos

View Event →
Jun
27
12:00 PM12:00

Speaking at Downtown Seattle SQL Server User Group

Speaking at the second meeting of the rebooted downtown Seattle SQL Server User Group:

Query Plan Options

What are the options available for looking at your query plans? When is one option better than another? What’s the difference between an estimated plan and an actual plan? In this session, we’ll look at why getting familiar with just looking at plans is the best first step to query tuning. We’ll also look at some of the latest additions to query plans, including Live Query Statistics, available starting in SQL Server 2016.

Download the slides and demos

 

View Event →
May
14
to May 16

Speaking at SQLDay

  • Hala Stulecia Wroclaw, Poland (map)
  • Google Calendar ICS

SQLDay is the largest conference focused on Microsoft Data Platform – databases, Big Data, Business Intelligence and advanced data analysis.

DOWNLOADS:

Demos and presentation for my Exploring the Plan Cache session at SQLDay 2018 can be downloaded here.

Demos and presentation for my Concurrency session at SQLDay 2018 can be downloaded here.

View Event →