Kalen Delaney's Blog

I am presenting my entire SQL Server Internals training online, an hour at a time, though DB Best. Check my blog there regularly for follow-up information including the slides and scripts, a link to the recordings, and solutions to homework exercises. Here is the follow-up to the most recent installment: https://www.dbbest.com/blog/webinar-2... Check the DBBest.com site or follow @DBBest_tech on twitter to get information about signing up for upcoming webinars in the series. The...(read more)

The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts can now be downloaded from my DB Best blog site: https://www.dbbest.com/blog/thank-sql......(read more)

I'm taking off tomorrow for Holland, UK, Denmark, Germany and Israel: https://www.dbbest.com/blog/im-leavin... You can read the post from DB Best, linked to above, or follow individual links to my public events from here: September 30: SQL Saturday Holland October 5: Getting the most out of the SQL Server Engine on Prem and in the Cloud Reading, UK This is a free, full day workshop on some of the new features of SQL Server 2016 and 2016. The workshop includes hands-on labs and...(read more)

(This article was originally published at https://www.dbbest.com/blog/ ) Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex , as well as sp_addtype , sp_droptype , sp_addlogin and sp_droplogin . For changing certain database properties, we had sp_changedbowner and sp_dbcmptlevel, to name a few. Gradually, Microsoft has started replacing these procedures with the more generic DDL commands ADD,...(read more)

Thanks to everyone who attended my 24HOP session on Wednesday, September 7. My favorite part is always the Q&A. I wish there was more time to do live Q&A, but because there’s not, I get to turn it into a blog post! My session was a snippet of what I will be talking about in my pre-con for the big PASS Summit at the end of next month. My full day session is called Locking, Blocking, Versions: Concurrency for Maximum Performance and you can read about it here . In my one-hour 24HOP session,...(read more)

Finally, we have a download available. You can go to this page microsoft.com/en/server-cloud/product... and scroll down to the section 'Technical Resources'. (NOT the section on the left called White papers). Click on “SQL Server 2016 In-memory OLTP technical white paper” and you can open or save. OR You can use this direct link: http://download.microsoft.com/downloa... Enjoy! ~Kalen P.S. And don’t forget...(read more)

  So you might already know, but I didn’t know, until I learned it, of course. My first Windows 8 machine was my Surface Pro 3 and I LOVED the way it started up so FAST. Fast is good, right? I didn’t even bother to wonder WHY or HOW it was so fast. I just thought Moore’s Law was hard at work. But then I noticed something very strange after I started doing most of my SQL Server testing on my Surface. Sometimes cache didn’t seem to be cleared. Sometimes temp tables would mysteriously be there...(read more)

As a teacher, and also a student of languages, one issue that’s always fascinating to me is how people choose to shorten a compound, or multi-part, name. This is very problematic when the word is from another language. For example, we use the word latte in English as a short form of caffè latte, but we shorten it to just the part that means ‘milk’, not coffee! My daughter was an exchange student in Spain and told me another example. Her host mother kept asking her if she had a ‘body’. The question...(read more)

Just a quick note that my CTP3 paper has finally been published, and now I can start working on the final version! Here’s the link: http://download.microsoft.com/downloa... Enjoy! ~Kalen...(read more)

As I mentioned in my previous post , I am heading in new directions, and the first goal has now been reached. Rather than working with training companies to offer my SQL Server Internals training, I am now partnering with Denny Cherry and Associates to offer a special opportunity to those wanting to experience a multi-day training event with me. Starting next April, we will be offering a three-day event called SQL Server Internals for Tuning , where you can learn about those areas of SQL Server Internals...(read more)