Ready to dive into the world of SQL? Whether you're dreaming of a lucrative data career or just want a new skill under your belt, learning SQL is a...
2024-05-21
99 reads
As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...
2024-05-20 (first published: 2024-05-02)
193 reads
This comic was retweeted into my timeline on Twitter (I refuse to call it X). Here’s the dialog from the comic, for those that don’t want to click through...
2024-05-20
16 reads
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You get an option to load sample data when you create a new pipeline in...
2024-05-20 (first published: 2024-05-02)
264 reads
flichtish – adj. nervously aware how much of your self-image is based on untested assumptions about yourself – only ever guessing how you’d react to a violent thread, a...
2024-05-17
18 reads
I wrote a post recently about pruning branches in git. That’s part of the job, but the other part is removing local branches. This post looks at one way...
2024-05-17 (first published: 2024-05-01)
343 reads
he rollback plan... what to do when things go wrong to get back to where you were before the deployment or implementation. I've seen too many cases where a...
2024-05-17 (first published: 2024-05-01)
355 reads
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate DevOps Roadshow comes to Ireland and the Northern UK in June. We’ll be in these...
2024-05-16
19 reads
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the great unifier (where I have updated the picture with the newest supported sources) and wanted...
2024-05-15 (first published: 2024-05-01)
432 reads
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights. They condense multiple rows into single, meaningful values, making it easier to grasp the big...
2024-05-15
340 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Sudut, Jl. Asia No. 128/168 dan, Jl. Asia Jl. Lampung No.130/170, Sei Rengas I,...
Wa 087878229292 Ruko Pd. Lestari, Jl. Raden Patah No.Raya Blok C/7-8, RT.001/RW.012, Karang Tim.,...
Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1, Menteng Dalam, Kec....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers