Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those… Read More »Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those… Read More »Be careful with table updates
This is one of those shameless plugs I’m allowed to do from time to time to promote my user group here in Calgary. Tonight, starting… Read More »Calgary Data User Group: Big Data Clusters with Bob Pusateri
There’s a lot going on in the world today. It feels like there’s too much for us to think about. Speaking for myself, I’m worried… Read More »Days of future past
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… Read More »Table Valued Parameters and Dapper in .NET Core
SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one. Building on a lot of work in the… Read More »SQL Server 2022 announced
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… Read More »You don’t need a blockchain
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… Read More »Join me next week at my first GroupBy session
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… Read More »System-versioned ledger tables: things you can’t do
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.… Read More »Join me at SQL Trail 2021 to hear the next thing about Temporal Tables
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… Read More »System-versioned ledger tables: the next step
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… Read More »Accessibility in font choice
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… Read More »Introducing system-versioned ledger tables
Right off the top here, I must note that the term “dead man’s switch” is archaic, so for the rest of this post I’ll refer… Read More »Why you need a Dead Man’s Switch
I have previously written about accessibility in video captions, presentation slides, and disabilities, and I thought I should expand on the latter topic as it… Read More »Let’s talk about typefaces
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… Read More »Think twice about storing JSON in your SQL Server database