Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)
19 Dec 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.9 - Columnstore Indexes If you missed the session, or would like to watch the recorded session, the recording will be available soon. Don’t miss the next webinar on January 9th: Viewing Query Plans!   The registration link will be posted here when available, In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server I...

Webinar 2.8 Followup (Episode 11 – Compression)
12 Dec 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.8 - Data Compression     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 19th: Columnstore Index Storage!   You can register here,   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server Interna...

Webinar 2.7 Followup (Episode 10 – Partitioning)
05 Dec 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.7 - Partitioning     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 12th: Data Compression!   You can register here.   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server Internals? Webinar #1...

Webinar 2.6 Followup (Episode 9 – Fragmentation)
28 Nov 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.6 - Fragmentation If you missed the session, or would like to watch the recorded session, the recording is available here. Don’t miss the next webinar on December 5th: Partitioning!  Registration is available here. In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server Internals? Webinar #1.1 SQL Server Metadata ...

Webinar 2.5 Followup (Episode 8 – Nonclustered Indexes)
21 Nov 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.5 — Nonclustered Indexes Because this week is a holiday week in the US, there is NO HOMEWORK! If you missed the session, or would like to watch the recorded session, the recording is available through this link. Don’t miss the next webinar on November 28th: Fragmentation! You can register here: https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-9-tickets-39714618493 In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this poin...

Webinar 2.4 Followup (Episode 7 – Clustered Indexes)
14 Nov 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.4 — Clustered Indexes If you missed the session, or would like to watch the recorded version,  here is the link to the video. Solution to the homework will be posted by or on next Monday. Don’t miss the next webinar on November 21st: Nonclustered Indexes!  You can register here. https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-8-tickets-39713832141 In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it doe...

Webinar #2.3 Follow-up (Episode 6)
07 Nov 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.3 — Large Datatype Storage And here is the link to the video. Don’t miss the next webinar on November 14th: Clustered Indexes! You can register here! -------------------------------------- Homework discussion for Webinar #2.2: Calculate the maximum number of IAMs a single object, including its indexes, can have. (more…)...

Why Learn About SQL Server Internals?
30 Oct 2017 Kalen Delaney

I’ve been writing and teaching about SQL Server internals for over 25 years. While there is usually a lot of interest in my books and classes, there are always people who ask, frequently after about the first day of my 5-day class, “What’s the point? Why is this information useful to know?” What is “Internals”? First of all, we need to answer the question “What is Internals?” For SQL Server, the short answer is “The way SQL Server works internally!” Internals education looks to answer some of these questions: • How does SQL Server manage memory, processors, i/o and other physical resources? • How is data physically sto...

Webinar #2.2 Follow-up (Episode 5)
24 Oct 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.2 — Allocation Information If you missed the session, or would like to watch the recorded version, you can get a link to access the video here. Webinar #2.2 Homework: (more…)...

Webinar #2.1 Follow-up (Episode 4)
18 Oct 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides, demo and homework files here: Webinar 2.1 — Tables, pages and rows If you missed the session, and/or would like to watch the recorded version, you can get a link to the recording here.   Here are solutions to the homework: (more…)...