2017 review: the year by the numbers

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers that have been my life this year. 106,914: the number of miles I flew on United this year (plus 8,504 miles on other airlines around Indonesia) 34,827: my current […]

2017: the year in books

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016) and people have been enjoying it, so here I present the 2017 end-of-year post. I set a moderate goal of 50 books this year but I only managed 48 as […]

Live online training from Kimberly in early January!

We’ve been considering doing some live, online training classes for a while now, and with the demand for Kimberly to teach an Immersion Event on partitioning, we’ve decided to take the plunge and present our first live, online class in January! Kimberly will be teaching our new IEVLT: Immersion Event on Very Large Tables: Optimizing Performance […]

New class: Practical Machine Learning

We’ve added a third brand-new class to our Spring line-up in Chicago: Immersion Event on Practical Machine Learning. It’s a combination 2-day class plus 3-day class, taught by industry expert Rafal Lukawiecki, presented on May 7-8 and 9-11, 2018. This course has two parts. You start with the 2-day Part 1: Introduction to Machine Learning, AI & Data Science with […]

New Pluralsight course: Implementing a Hybrid Cloud Solution in Azure

Tim’s latest Pluralsight course has been published – SQL Server: Implementing a Hybrid Cloud Solution in Azure. It’s 2.5 hours long, and from the course description: Have you been wondering what Azure Virtual Machines or Azure SQL Databases are and what they mean for you as a production DBA or developer? The Azure platform has become an Enterprise-worthy […]

2012/2014 bug that can cause database or server to go offline

Over the years I’ve discussed log space reservation, which is when SQL Server automatically reserves some free space in the transaction log so that in-flight transactions can always be rolled back without the log having to grow. This is because rolling back a transaction requires generating more log records, and so there needs to be guaranteed space […]

Disaster recovery 101: Object ID 0, index ID -1, partition ID 0

Quite often I see questions about DBCC CHECKDB error messages along the lines of: Specifically, the part that confuses people is “Object ID 0, index ID -1, partition ID 0”. There isn’t an object ID of 0 in the system, and how can an index have an ID of -1? This pattern means that DBCC couldn’t […]