Data or Experience
Is it more imortant to use the data or your experience? Does one have more weight than the other?
SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion
How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.
How to Get NULLs Horribly Wrong in SQL Server
NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.
Automating SSIS Design Pattern - Stage Delimited Flat File
How long does it take to create to 100 staging packages? The answer will shock you!
Trust People
Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.
Knee-Jerk Wait Statistics : CXPACKET
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
Data Loss or Downtime
This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.
FORMAT() is nice and all, but…
Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
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 KCU BOGOR No tlpon:083138717148
Whatsapp:083138717148.Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCP Sawah Besar Telp:08213111109
Jl. Sukarjo Wiryopranoto No.28 C, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
BCA KCU BEKASI Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, 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