Kalen Delaney

Geek City: Growing Rows with Snapshot Isolation

Kalen Delaney — Sun, 20 Nov 2011 00:43:00 GMT

I just finished a wonderful week in Stockholm, teaching a class for Cornerstone Education. We had 19 SQL Server enthusiasts, all eager to find out everything they could about SQL Server Internals. One questions came up on Thursday that I wasn’t sure of...(read more)

Did You Know? Query Options Setting in SSMS

Kalen Delaney — Thu, 20 Oct 2011 00:09:00 GMT

Hi folks I’m back from an amazing week at PASS and an awesome reception for SQL Server MVP Deep Dives Volume 2. I’m starting to plan and write my next book on SQL Server 2012 Internals so blogging will kept to a minimum, not that I’ve had a lot of time...(read more)

Did You Know? I’ll be teaching my Internals Class online!

Kalen Delaney — Wed, 07 Sep 2011 20:27:00 GMT

In my most recent commentary for SQL Server Magazine, online here: http://www.sqlmag.com/article/training-and-certification2/sql-server-training-options-140429 , I talked about different options for making training content available online. As an addendum...(read more)

Geek City: Where are LOBs stored?

Kalen Delaney — Sun, 26 Jun 2011 21:27:00 GMT

When researching a question from one of the students in my class last week, I was reading the documentation for CREATE TABLE about storing LOB columns at http://msdn.microsoft.com/en-us/library/ms174979.aspx . For this discussion LOB columns includes...(read more)

Geek City: What gets logged for SELECT INTO operations?

Kalen Delaney — Tue, 15 Mar 2011 19:41:00 GMT

Last week, I wrote about logging for index rebuild operations. I wanted to publish the result of that testing as soon as I could, because that dealt with a specific question I was trying to answer. However, I actually started out my testing by looking...(read more)

Geek City: What gets logged for index rebuild operations?

Kalen Delaney — Tue, 08 Mar 2011 18:54:00 GMT

This blog post was inspired by a question from a future student. Someone who was already booked for my SQL Server Internals class in June asked for some information on a current problem he was having with transaction log writes causing excessive wait...(read more)

Geek City: Preparing for the SQL Server Master Exam

Kalen Delaney — Thu, 03 Mar 2011 14:40:00 GMT

I was amazed at the results when I just did a search of SQLBlog, and realized no one had really blogged here about the changes to the Microsoft Certified Master (MCM) program. Greg Low described the MCM program when he decided to pursue the MCM at the...(read more)

Did You Know: Where's the Best Place to Get Started?

Kalen Delaney — Thu, 17 Feb 2011 07:34:00 GMT

Have you ever wondered how to start learning about a specific SQL Server topic? Or how to advise someone who asks "How do I get started?" Redgate, and SQL Server Central, have launched a new site to answer that question. SQL Server Stairways are a series...(read more)

Did You Know: I'm going back to Boston!

Kalen Delaney — Wed, 26 Jan 2011 04:12:00 GMT

After spending 5 months in Boston last summer and fall, I'm going back again, to teach my 5-day SQL Server Internals and Query Tuning class for Boston SQL Training. Last time I taught my course there, we had a completely full class with a waiting list....(read more)

Geek City: Ordered Seeks and Scans

Kalen Delaney — Fri, 21 Jan 2011 23:28:00 GMT

I got a couple of really great questions during my SSWUG Workshop this morning , as I was discussing seeks and scans, and since the answers to the two questions are very related, I decided to address both of them in more detail in this blog post. Most...(read more)

Did You Know? My PASS Demos and Social Networking

Kalen Delaney — Mon, 15 Nov 2010 22:30:00 GMT

My PASS demos are now available on my website for my Precon Session on SQL Server Concurrency: Locking and Blocking and Row Versions, Oh My! and for my Spotlight Session on Seeking SQL Server Secrets. You can download both sets of scripts from www.SQLServerInternals.com/conferences...(read more)

Did You Know: SQL Geeks for Good

Kalen Delaney — Thu, 04 Nov 2010 19:04:00 GMT

Are you going to PASS next week? We're not going to have anything to compete with the big release and book-signing for the SQL Server MVP Deep Dives book like we had last year, but there is something special you can do this year. A former student is collecting...(read more)

Geek City: Inside SQL Azure

Kalen Delaney — Tue, 02 Nov 2010 16:10:00 GMT

My new whitepaper has just been published! Inside SQL Azure http://social.technet.microsoft.com/wiki/contents/articles/inside-sql-azure.aspx The paper examines the internals of the SQL Azure databases, and how they are managed in the Microsoft Data Centers,...(read more)

TSQL Tuesday #11:Rolling Back TRUNCATE TABLE

Kalen Delaney — Tue, 12 Oct 2010 20:02:00 GMT

“It ain't what people don't know that hurts them it's what they know that ain't so” -- commonly attributed to Mark Twain SQL Server has been around for a long time now, and people who learn one version well sometimes have monumental task when a new version...(read more)

Did You Know? It's really easy to convey the wrong message when writing

Kalen Delaney — Tue, 28 Sep 2010 20:17:00 GMT

And it's also really easy to procrastinate. I meant to blog about a big misunderstanding right after last month's SQL Server Magazine UPDATE commentary appeared, but now I'm just finishing up this month's commentary and only now realized I forgot to write...(read more)