Using strace inside a SQL Server Container
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-03
10 reads
Blog Posts
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
5 reads
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
19 reads
20 Years of Redgate Software
Yeah, Redgate is only one year younger than my children. What’s really frightening is that I’ve been using Redgate’s products since my kids were a year old. I was...
2019-09-02
31 reads
Protected: Vajrasara – an interview with Lashana Lewis – Part 1
There is no excerpt because this is a protected post.
2019-09-02
18 reads
Protected: Vajrasara – An interview with Lashana Lewis – Part 2
There is no excerpt because this is a protected post.
2019-09-02
7 reads
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-09-02 (first published: 2019-08-22)
297 reads
Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell
Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way....
2019-09-02
16 reads
SQL Homework – September 2019 – Getting the data in
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-09-02
243 reads
SSIS Precedence Constraints
In the control flow for SQL Server Integration Services, the “lines” we commonly use to connect tasks to each other are actually smart controls. These SSIS precedence constraints allow...
2019-09-02
21 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
BCA KCP Iskandar Muda Tlpn/wa:085373737551
Jl. Iskandar Muda No.123, Sei Sikambing D, Kec. Medan Petisah, Kota Medan, Sumatera Utara...
BCA KCP MT Haryono. Tlp:085373737845
Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01 Lt.G-01, RT.5/RW.11, Wil,...
BCA KCP Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
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