A New Word: Ghough

ghough – n. a hollow place in your psyche that can never be filled; a bottomless hunger for more food, more praise, more attention, more affection, more job, more...

Friday Flyway Tips: More Config Options

Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway...

Temporal Table Data Fixes

I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...

T-SQL Tuesday: Encryption and Data Protection

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any doubt that’s for October 2023, I’m posting this invitation a little early as I got...

FDD 2023 – Session Materials

You can find the slides for my session at Future Data Driven summit at GitHub. It was really nice presenting (virtually). If you have any questions, let me know!
The...

How to Secure SQL Server

Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. At times when applications are run in geographically restricted areas, there...

SQL Homework – September 2023 – Time for temporal tables.

Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading

Common Mistakes in SQL Server – Part 2

The  Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...

Common Mistakes in SQL Server – Part 2

The  Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...

Enable PowerShell Remoting

Enable PowerShell Remoting

I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell...