Working on Technology Off the Clock
I have always spent time learning relational databases on my own, non-work time. As the years have […]
Blogs
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
Being A Bit Less Comfortable in 2024
I hate coming up with ideas for editorials, but my last editorial of the year gives me […]
Warehouse Load Patterns – Part 2 – Load Patterns
This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
SQL Server: Optimize for Ad Hoc Workloads – use or ...
I used to believe this option was something almost absolute: it should be enabled as best practice. […]
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
Warehouse Load Patterns – Part 1 – Requirements and General ...
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt […]
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...
Last but not least, the Community Keynote. Hang on to your hats, this is going to be […]
PASS Summit 2023 – Redgate Keynote – The New Database ...
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […]
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […]
Autonomous Databases?
I was talking to some people today about the concept of Autonomous Databases. The idea is that […]
An editor’s biggest headache: Plagiarism
As an editor working with other people’s technical writing for many years, you might guess that either […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
Creating an Azure PostgreSQL cluster and connecting to it
One of the technologies that my new job brought with it was learning about all the various […]
Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
SQL Server Security Primer
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
SQL Server Row Level Security Deep Dive. Part 6 ...
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Microsoft Fabric and the Delta Tables Secrets
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
SQL Server Row Level Security Deep Dive. Part 5 – ...
As mentioned in previous sections, RLS is an addition to security and should not be used as […]
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
Download the notebook used on this blog I explained in a previous article how the Tables in […]
SQL Server Row Level Security Deep Dive. Part 4 – ...
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […]