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

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 […]

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

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.

Why Learn About SQL Server Internals?
30 Oct 2017

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!” […]

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

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:

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

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:

Webinar #1.3 Metadata Internals Follow-up
03 Oct 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 1.3 — Metadata Internals If you missed the session, and/or would like to watch the recorded version, you can get a link to the recording here. Related posts Why Learn About SQL Server Internals? Webinar #1.1 SQL Server Metadata Overview Follow-up Webinar #2.1 Follow-up (Episode 4) Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)

Thank you, SQLSaturday Holland!
02 Oct 2017

The first event on my Fall tour is behind me now. I had a wonderful time at SQLSaturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts can now be downloaded: Locking Session Statistics Session

I’m Leaving on a Jet Plane
27 Sep 2017

I’m taking off tomorrow for a three-and-a-half-week adventure, representing DB Best Technologies in four different countries. In addition to some customer visits, and a week’s vacation with my daughter and grandson in Stuttgart, I’ll be presenting at the following four PUBLIC events.

Webinar #1.2 SQL Server DMVs Follow-up
26 Sep 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 1.2 — SQL Server DMVs files If you missed the session, or would like to watch the recorded version, here’s the link. (Once you complete the registration information, you will get an email with a link to the webinar. Yes, it’s a little tedious, but the marketing team says I have to use this link.) Following are solutions to the homework exercises for Webinar 1.2:

Webinar #1.1 SQL Server Metadata Overview Follow-up
22 Sep 2017

The link to watch Webinar #1.1: Metadata Overview can be found here: Webinar #1 – SQL Server Metadata Overview Once you complete the registration information, you will get an email with a link to the webinar. Yes, it’s a little tedious, but the marketing team says I have to use this link. 🙂 The zip file that includes the presentation and demo scripts is located at Webinar 1.1 — SQL Server Metadata Overview files. As I mentioned when telling you […]