Filtering by: Online class

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 →