GroupBy logo

Join me next week at my first GroupBy session

2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next week, but I was also selected to speak at the upcoming GroupBy conference on Tuesday October 26, 2021. Yes, that’s also next week! Some facts about next week’s talks: Yes,
-> Continue reading Join me next week at my first GroupBy session

Glasses, calculator, tablet, white neat desk

System-versioned ledger tables: things you can’t do

This is the third post in the series about system-versioned ledger tables, a new feature introduced in Azure SQL Database. You can read Part 1 and Part 2 if you haven’t already. Every choice we make is a trade-off. New features have limitations, and ledger tables are no exception. Some of these limitations are perfectly
-> Continue reading System-versioned ledger tables: things you can’t do

Join me at SQL Trail 2021 to hear the next thing about Temporal Tables

I’ve had the privilege of presenting all over the world about temporal tables in SQL Server including the United Kingdom, Canada, and the United States. The theme of the session has always been Back to the Future, which is the greatest time travel movie ever, but I haven’t changed the talk much since I debuted
-> Continue reading Join me at SQL Trail 2021 to hear the next thing about Temporal Tables

Glasses, calculator, tablet, white neat desk

System-versioned ledger tables: the next step

In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates whether your database has been tampered with. Very simply, if the cryptographic hash does not match what is in the off-site digest, your database has been
-> Continue reading System-versioned ledger tables: the next step

A sample of the OpenDyslexic font

Accessibility in font choice

Choosing the right typeface for your presentation (or for that matter anything you create that contains words) is fraught. In a previous post I wrote about the difference between serif and sans-serif. I mentioned font families, line spacing, and kerning. I also discussed why it’s important for a font to differentiate between characters that look
-> Continue reading Accessibility in font choice

Glasses, calculator, tablet, white neat desk

Introducing system-versioned ledger tables

As long-time readers of this blog know, I’m a big fan of temporal tables, also known as system-versioned temporal tables. Until recently, temporal tables were synonymous with system-versioned tables, but all that changed a short while ago with the introduction — in Azure SQL Database — of system-versioned ledger tables. This new series of posts
-> Continue reading Introducing system-versioned ledger tables

A small slice of pie

Think twice about storing JSON in your SQL Server database

During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10 million rows, which isn’t that remarkable; another table in the same database has almost 500 million rows. The remarkable thing — because you read the subject
-> Continue reading Think twice about storing JSON in your SQL Server database