Setting FK Constraints in Data Modeler
One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy,...
2026-02-27 (first published: 2026-02-11)
321 reads
Blog Posts
SQL Server Journey till 2025 (brief)
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part of all the Versions!! 7 (70)– Foundation, OLAP Services, Query Analyzer 2000 (80) – SSAS,...
2026-02-27 (first published: 2026-02-26)
23 reads
Ramblings about data communities and your contributions, no excuses
I have been active in the data community throughout my career. I have met people and made friends in the process. As I look back on it, I am...
2026-02-26
23 reads
Are you getting value from your reporting?
Do you spend so long manipulating your data into something vaguely useful that you don’t have the time to focus on analysing the what the data is telling you?...
2026-02-25 (first published: 2026-02-14)
217 reads
Identity Columns Can’t Be Updated: #SQLNewBlogger
I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error...
2026-02-25
43 reads
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been to build an agent which would answer your questions by looking into your data. It...
2026-02-25 (first published: 2026-02-15)
238 reads
Fabric Cost Analysis (FCA)
Monitoring costs in Microsoft Fabric can be trickier than it first appears. You might assume it’s just a flat fee per capacity (easy, right?), but real-world usage tends to...
2026-02-23 (first published: 2025-12-24)
383 reads
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day job, I certainly didn’t expect to write this many blog posts about Git. I don’t...
2026-02-23 (first published: 2026-02-12)
424 reads
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at dataMinds Saturday. It’s a topic close to my heart, and I’ve always wanted to present...
2026-02-20
27 reads
The Book of Redgate: SQL Server Central
It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...
2026-02-20 (first published: 2026-02-13)
307 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Alamat Kantor BCA KCU Kedoya Permai Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5,...
Alamat Kantor BCA KCU Gajah Mada Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari,...
Alamat Kantor BCA KCU Pluit Telp:08218154374
Hub Via Wa:628218154374 Alamat: Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers