I work with a lot of SQL Server databases that are poorly normalized. One of my pet dislikes is the column to rule them all.
Here are simple tests:
Here are some examples:
2026-07-27
Intrusions into computer systems are happening all the time now. We need to address this issue as an industry, but it’s important to understand that the way we design databases plays a big role in the impacts that occur during intrusions.
If you don’t accept that you could have an intrusion, you are living in La La Land. (See https://en.wikipedia.org/wiki/Fantasy_prone_personality )
A bug in any one of the frameworks that you use, the code that you write, the protocols that you use, the operating system or hosting services that you use can potentially expose you to an intrusion.
2026-07-25
I’ve pointed out in previous blog posts that I’m not a fan of ORMs. What I’m even less of a fan of is code-first design, particularly in combination with an ORM like the Entity Framework.
It might seem cool and shiny and if you are just whipping up a small proof of concept or test app, please feel free to do it, but the minute you think of doing it for enterprise systems, please just don’t. And if you have colleagues wanting to do this, just say no.
2026-07-15
I work with data. I understand that for most organizations, that the data they own is the most valuable asset the company owns.
One thing I’ve learned from working with data is that unlike application software, data generally outlives generations of applications, is often used by many different applications, and typically just morphs from shape to shape over time. It almost never gets totally refreshed.
This is a good thing.
2026-07-09
I spend most of my life in a variety of customer sites. Most of these nowadays tend to be large financial organizations. When I talk to developers in those organizations, and ask them about how they interact with their DBAs, I can’t tell you how often I hear that they try to avoid ever making schema changes, etc. as it takes too long and the process is painful.
When I talk to the DBAs at the same organizations, and I ask them why they resist making schema changes, I hear this:
2026-07-05
Day by day, we’re getting further away from needing to use 32-bit DLLs. One place where I keep coming across them, is when doing integration work. The problem is that there are many 32-bit drivers for older systems, and no-one is going to ever bother to write 64-bit drivers for them. So, if you have to use those drivers, you need to run the 32-bit versions. And SSIS has options that allow you to run 32-bit drivers.
2026-06-29
The on-premises versions of SQL Server have the ability to connect one server to another via a mechanism called Linked Servers.
Azure-based SQL Server databases can communicate with each other by a mechanism called External Tables. I’ll write more about External Tables again soon.
With Linked Servers, I often hear people describing performance problems. There’s a configuration setting that commonly causes this, yet it seems to be almost unknown.
2026-03-11
I’m not a great fan of linked servers in SQL Server but they are often necessary. If I’m working with the latest version of SQL Server, I really prefer to use External Data Sources and External Tables. But not everyone is on the latest version. In the meantime, what I see all the time, is people hardcoding server names like this:
SDUPROD2022.WWIDB.Payroll.Employees
That makes your code really hard to manage. One option to get around that is to use synonyms.
2026-03-09
More Microsoft Fabric love !
Turn data into insights the moment it happens because yesterday’s data is already too late !
We’ve added more Microsoft Fabric love to our courses. We’re pleased to announce that our new course Mastering Microsoft Fabric Real-Time Intelligence is now available. This is another course that we’ve had so many requests for. You can find details of it here:
Mastering Microsoft Fabric Real-Time Intelligence
Do you need to master Real-Time Intelligence in Microsoft Fabric?
2025-12-14
Learn to design, automate, and optimize data pipelines across Azure and Microsoft Fabric environments !
We’re pleased to announce that our new course Azure Data Factory and Fabric Data Factory: Data Integration for Data Professionals is now available. This is another course that we’ve had so many requests for. You can find details of it here:
Azure Data Factory and Fabric Data Factory: Data Integration for Data Professionals
Are you ready to master modern data integration with Azure and Fabric Data Factory?
2025-08-11
