Do the tools you use make something more or less of an engineering effort?

Read More

Let's dive into optimized locking in Azure SQL Database!

Read More

I'm honored to be returning to DataGrillen!

Read More

Does data compression make changing data types faster? Let's dig in and find out!

Read More

I'm extremely happy to be speaking at SQLBits this year!

Read More

Does the HOLDLOCK table hint really use the SERIALIZABLE transaction isolation level? Let's experiment and find out!

Read More

I spun up an Azure SQL Virtual Machine, but I quickly found that PolyBase wasn't installed. To add it I would need the install media of course, but how does one get that in an Azure SQL VM?

Read More

Despite the fact that I've now been writing and tuning SQL statements for over half my life, I still don't feel like I'm an expert. Whenever I need a reminder of this, all I do is ask myself where a GROUP BY clause goes in a SQL query. Does it go before or after WHERE?
Read More

Design choices, tooling, and code I used to build a URL redirection service using Azure Cosmos DB and Azure Functions.

Read More

I've been hard at work recently redesigning this blog and converting it from WordPress into a static site. Please don't be too shocked! Get it? Static…shocked… ok that’s my dad joke quota for the day. But honestly it's been a really interesting process that I'm excited to share with you!
Read More