I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL statements that load data from views into a respective fact or dimension. Such a...
2024-07-08 (first published: 2024-06-08)
766 reads
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
20 reads
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-07-08 (first published: 2024-06-21)
219 reads
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly captures the kind of person you are, tying together your many flaws and contradictions into...
2024-07-05
22 reads
A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to restore to a supported...
2024-07-05 (first published: 2024-06-20)
382 reads
I’ve seen the term polyglot persistence floating around Redgate a bit recently in the marketing department. I haven’t really seen this term anywhere, and I wonder if you have....
2024-07-05 (first published: 2024-06-17)
131 reads
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...
2024-07-03 (first published: 2024-06-16)
98 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced! We’re kicking off at 1pm UTC on August 8th (8th of the 8th…get it? 🙂...
2024-07-03
65 reads
After a data migration, we needed to decommission the old Azure SQL DBs, but we wanted to keep a copy in case we needed anything later. Enter exporting an...
2024-07-03 (first published: 2024-07-02)
401 reads
I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server...
2024-07-03
596 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers