One of the new features in SQL Server 2025 is that you can now use regular expressions directly in your T-SQL queries. Now, regular expressions (or RegEx) have never been a syntax that's easy to read. There are a lot of brackets, dashes and other symbols that make no sense when you first see them. … Continue reading SQL Server 2025: Simplifying Data Checks with RegEx
Some time ago, Microsoft announced the release of a new version of SQL Server. This made me happy, mainly because in the storm of everything Fabric, Copilot, and cloud, sturdy technology still has a place, and Microsoft hasn't forgotten that. Companies still rely on on-premises systems that require databases. And running everything on-premises is still … Continue reading My top features of SQL Server 2025 for Business Intelligence
When Microsoft Fabric was introduced in May 2023, one of its major promoted components was the Real-time Analytics part. We (that is, my coworkers and I from Axians) focused mainly on the batch processing of data. With the introduction of the DP-700 exam, I started to focus more on the real-time part of Microsoft Fabric. … Continue reading Mastering Real-Time Analytics with Microsoft Fabric
If you come from an SQL Server background, mirroring will be familiar to you. It may be good or bad, but hopefully not at a nightmare level. Whatever your association with database mirroring, it is also available within Microsoft Fabric. What is mirroring If you're not coming from a SQL Server background, or any data … Continue reading DP-700 training: Implement mirroring
Today, May 19th, 2025, is the keynote day of Microsoft Build, where Microsoft announces its big new tech innovations. You won't be surprised; there's a lot of Copilot in the announcements. You can't get around it if you have any toolset in the cloud; there will be AI waiting for you to help you. Bad … Continue reading Is Microsoft SSMS Copilot the Future of Database Management?
Some time ago, a client came up with a very intriguing question. As I love a challenge, especially when you get to dig deep into a toolset, I jumped at the occasion and went for it. The following is a write up about the steps taken to analyse. Both for future me when I run … Continue reading Azure Synapse Analytics performance, an analysis
Some time ago, I wrote a number of blogposts comparing the different Azure SQL options to give you some idea about performance, differences between tiers and differences between the Stock Keeping Units (SKU's). This was done by creating data in the database itself and review the metrics. This works fine and gave a good overview … Continue reading Loadtesting SQL, the sequel
Data security is the most important part of our job as data engineers and data architects. There are very few use cases where people need to see all the data in full detail. I know, customers take a different view on this but in reality, do they really need every single detail? No, they do … Continue reading DP-700 training: data masking
The best place to store your data is in a SQL Server database that no living being can ever access. The end. No, I'm kidding, of course. But there's an atom of truth in this joke. Because for years we, in the structured data industry, have always been convinced that a database is the best … Continue reading DP-700 Training: Choose an appropriate data store
This blogpost will be introductory to version control within Microsoft Fabric. If you've got the basics of this under control, you're welcome to refresh your knowledge in this blog or check out our points of view. Alternatively, you can dig into the blogposts by Kevin Chant who has a lot of good posts on this … Continue reading DP-700: Configure version control
