Intent Locks In SQL Server
Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They’re something that I’ve found myself explaining time and time again, I’ve even...
2019-07-25
659 reads
Blog Posts
Learning More about Kubernetes (K8s)
I know a bit about this, but I’m always looking for more. I had the chance to see Brendon Burns recently and I was impressed. That is one seriously...
2019-07-25 (first published: 2019-07-08)
710 reads
Why We Don’t Truncate Dimensions and Facts During a Data Load
Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While...
2019-07-25
810 reads
Adding a Column with a Default Constraint
Last week a question came up about adding a column to a table, and giving that column a default constraint. Would that default value be assigned to all existing...
2019-07-24 (first published: 2019-07-16)
470 reads
Custom error messages
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem ... Continue reading
2019-07-24
38 reads
Keep It Simple Stupid
Some of us take days and weeks to write a blog, while others can take two minutes and write a great blog *cough* *cough* Denny (B|T). Why is that?...
2019-07-24
28 reads
OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2
Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of extended support with Microsoft today! 9th July...
2019-07-24 (first published: 2019-07-09)
705 reads
Redis University
As if I don’t have enough to do, I started a data structures class at Redis University. Someone recommended this to me as another way a company has structured...
2019-07-24
40 reads
Weekly reading #22
A little bit late but it is here! It is Wednesday already and we are preparing for #DPS2019 which will be in August in Bangalore. Meanhwile I received another...
2019-07-24
26 reads
A simple powershell script to look up server hardware and OS information
This is a simple powershell script to query and display hardware and OS information from a remote computer.It uses CIM (Common Information Model) that is available since Powershell version...
2019-07-23
2,691 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Cs Lion Air Tower Tlp/ Chat 083843888827
Cs Lion WhatsApp 083843888827 Jl. Pasar Sindu No 10, Sindu Kelod, Sanur, Denpasar Selatan,...
BCA KCP Dewi Sartika Telpon/WA:08213111185
BCA KCP Dewi Sartika Telpon/WA:08213111185 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati,...
BCA KCU RAWAMANGUN Telpon/WA:08213111185
BCA KCU RAWAMANGUN Telpon/WA:08213111185 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers