Always room for growth

Table Valued Parameters and Dapper in .NET Core

A customer I’ve been working with for a while now has a monolithic ASP.NET MVC web application which we are porting to .NET Core 3.1 (and then almost immediately to .NET 6). One of our biggest changes was getting rid of Entity Framework and replacing it with Dapper, because performance is a feature. To deflect
-> Continue reading Table Valued Parameters and Dapper in .NET Core

You don’t need a blockchain

After writing several posts about a neat feature in Azure SQL called system-versioned ledger tables, it reminded me about something I’ve wanted to say for a number of years now, outside of snarky tweets. Here goes: You don’t need a blockchain. In the vast majority of use cases, you need a properly audited relational database
-> Continue reading You don’t need a blockchain

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