Sep
14
8:00 AM08:00

Hekaton session at SQL Saturday Gothenburg!

DEMOs and Presentation can be downloaded from here.

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Sep 14 2019 at Beda, Forskningsgången 3, Göteborg, Västra Götalands län, 417 56 Göteborg, Sweden

My session is called “What the Hekaton?”

SQL Server Hekaton, aka In-Memory OLTP, will completely change the way you think about data management. As a DBA, you’ll need to analyze your memory and storage needs completely differently. In this session, I will show you the in-memory architecture for your Hekaton data and indexes, and discuss what gets written to disk during checkpoints, as well as what gets logged. Finally, I’ll go into detail on just what it is that makes Hekaton so much FASTER!

View Event →
Jun
1
8:00 AM08:00

Concurrency session at SQL Saturday Dallas!

DEMOs and Presentation can be downloaded from here.

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Jun 01 2019 at UTDallas, The Erik Jonsson School of Engineering and Computer Science, 800 W. Campbell Road, Richardson, TX, Dallas, Texas, 75080-3021, United States

Join me at SQL Saturday #841 in Dallas, TX!

My session is called “Are You Optimistic About Concurrency?”

View Event →
Apr
27
8:00 AM08:00

Speaking about tempdb at SQL Saturday Redmond!

DEMOs and Presentation can be downloaded from here.

Note that this event was postponed from an earlier date, which was cancelled due to extreme weather conditions.

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Apr 27 2019 at Microsoft Building 92, 15010 NE 36th St,, Redmond, Washington, 98052, United States

Join me at SQL Saturday #807 in Redmond, WA!

My session is called “Everlasting Issues With Temporary Tables and tempdb”.

View Event →
Apr
6
11:00 AM11:00

Speaking about tempdb at SQL Saturday Colorado Springs

DEMOs and Presentation can be downloaded from here.

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Apr 06 2019 at CTU Colorado Springs, 4435 North Chestnut Street, Colorado Springs, Colorado, 80907, United States

Join me at SQL Saturday #830 in Colorado Springs!

My session is called “Everlasting Issues With Temporary Tables and tempdb”.

View Event →
Feb
27
8:30 AM08:30

Concurrency Precon - SQLBits 2019

Demos are available here!

Faster Queries Without NOLOCK!

SQL Server offers two methods for applications to provide multi-user concurrency and provide data consistency: Pessimistic and Optimistic Concurrency Control. In this seminar we’ll discuss what consistency might mean to your applications, and describe the details of how each concurrency model works internally. We’ll examine the costs and trade-offs between the two models. Finally, we’ll examine the metadata and tools available for analyzing and troubleshooting problems.

  • Why is concurrency management a crucial part of database tuning?

  • How does SQL Server implement pessimistic concurrency with locking?

  • How do we get true optimistic concurrency?

Pre-requisites
Basic knowledge of TSQL Querying 
Laptop Required: Optional

  • Software: Delegates can follow along with some of the demos if they have a laptop with SQL Server 16 or later installed, with the latest Management Studio,.

  • Subscriptions: They can connect to an Azure SQL Server or SQL DB if they do not have a local one, but it is not required.

View Event →
Feb
20
to Feb 21

Partitioning Session at SQL Konferenz, Darmstadt

Slides and Demos can be downloaded from here.

Partition Magic

There are many reasons for partitioning your data and indexes in SQL Server, and one of them is because of the ease of moving data into and out of a table. The way SQL Server keeps track of the internal storage of partitioned data allows data movement to be done as a metadata only operation. 

In this session we'll look at the metadata for table, index and partition storage to explore exactly what happens when a partition is moved. Looking at the internal details of partition storage allows us to understand the reasons for some of the restrictions on how and when we can get a benefit from partitioning.


In this session we'll look at:

  • How partitioning works

  • How your partitioned data is organized

  • The metadata behind your partitions

  • What is really happening when you switch partitions, split partitions and merge partitions

View Event →
Feb
8
8:30 AM08:30

Performance Precon at SQL Saturday Redmond

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.

Register for this detail-packed seminar now!
This is the same content offered as a precon at large conferences, and it’s less than half the cost here!

For details about SQL Saturday Redmond, including the exact location, you can go here.

SQL Server Internals for Performance

We all know that the answer to almost any SQL Server tuning question is “It Depends!”

In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of tuning changes can be made to enhance your system or application performance, and what areas of SQL Server Internals you need to understand to make the best choice for you when trying to answer the following questions:

  1. Should we build a clustered, nonclustered or columnstore index?

  2. Is reusing cached query plans a good thing?

  3. Should I enable Read Committed Snapshot Isolation?

  4. How many files should tempdb be configured with?

View Event →
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 →