Days of future past
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 about the environment first and foremost, followed closely by folks… Days of future past
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… Table Valued Parameters and Dapper in .NET Core
SQL Server 2022 announced
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 Azure SQL space, SQL Server 2022 looks to include some… SQL Server 2022 announced
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… You don’t need a blockchain
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… Join me next week at my first GroupBy session
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… 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… Join me at SQL Trail 2021 to hear the next thing about Temporal Tables
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… System-versioned ledger tables: the next step
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… Accessibility in font choice
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… Introducing system-versioned ledger tables
Why you need a Dead Man’s Switch
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 to it as “operator presence control,” or OPC. The concept… Why you need a Dead Man’s Switch
Let’s talk about typefaces
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 relates to typefaces, or what we call “fonts.” To be… Let’s talk about typefaces
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;… Think twice about storing JSON in your SQL Server database
Scaling down in the cloud
I may be completely off base here, but I’ve noticed a correlation between folks who use Amazon Web Services and their understanding that once you scale up a service during a busy business period, you… Scaling down in the cloud
Join me on 13 August 2021 for Dativerse
This coming Friday the 13th (August 2021) is the first ever Dativerse virtual conference, hosted by our DataGrillen friends William and Benjamin. According to their site: We try to elevate those that are usually underrepresented… Join me on 13 August 2021 for Dativerse