Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
88 reads
Kenneth Fisher
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-06-10 (first published: 2022-05-19)
607 reads
How can I use the identity column, without knowing identity column’s name.
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-06-03 (first published: 2022-05-12)
408 reads
SQL Homework – June 2022 – SQL Agent Jobs continued.
A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading
2022-06-02
25 reads
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
32 reads
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
38 reads
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-05-24
8 reads
My job managing a calling list. : T-SQL Tuesday #150
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-23 (first published: 2022-05-10)
177 reads
SQL Homework – May 2022 – Books on Line
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-20 (first published: 2022-05-05)
431 reads
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-05-19
66 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 Mangga Dua Surabaya No.Telp 083831617937
Whatsapp.083831617937 Jl. Jagir Wonokromo 100, Pertokoan Mangga Dua Blok B-6 No.1 Surabaya, Jawa Timur,...
BCA KCP Kusumabangsa No. Telp 083138716609
Whatsapp: 083138716609 Jl. Kusumabangsa No. 35, Ketabang, Kec. Genteng, Kota SBY, Jawa Timur Surabaya,...
BCA KCP Kupang Jaya No. Telp 083138716609
Whatsapp: 083138716609 Jl. Kupang Jaya 17/I,Sonokwijenan, Kec. Sukomanunggal, Kota SBY, Jawa Timur Surabaya, Jawa...
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