SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.
Why disabling the SQL Server sa account still matters in 2026
Every few years, someone asks a familiar question: do we really still need to disable the sa account in SQL Server? After all, it’s 2026. SQL Server has better encryption, better auditing, better defaults, and more security features than ever before. Surely this old guidance belongs in the past?
Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
Changing Data Types
Steve had to deal with a customer that changed data types in columns often. Is that something you experience?
Query Hint Recommendation Tool in SSMS 22
SQL Server Management Studio keeps adding features, but unless you look you probably don’t notice. In this article, we look at the new Query Hint Recommendation Tool in SSMS 2022 and how this can be used.
Webinar: Compliance Without Compromise: Test Data Management That Finally Fits
You know you shouldn't have production data in test environments. But every time you look at fixing it, the options feel impossible: enterprise tools that cost six figures and take months to implement, or DIY scripts that sort of work until they don't. Join this webinar on Mar 18 to learn more.
Breaking Down Your Work
Self-assessment and self-examination can be important in many fields, especially technology in the age of AI.
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Last time we turned SQL Server into a Christmas tree. Every year around St Patrick's Day I find myself doing something I can't fully justify. This year that thing was using SQL Server's spatial viewer to draw a shamrock and a pint of Guinness. Hope you have a happy St Patrick's Day and a few […]
I’m Not Gonna Waste Time Debunking Crap on LinkedIn.
LinkedIn is full of absolute trash these days. Just flat out b****** garbage. (Oh yeah, that – this post should probably come with a language disclaimer, because this stuff makes me mad.)
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 Fatmawati Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan, Daerah...
BCA KCP Labuan Bajo No.Telp:087757645171
Whatsapp:087757645171 Kawasan Komersial Marina, GF A6, Labuan Bajo, Kec. Komodo, Kabupaten Manggarai Barat, Nusa...
BCA KCU DIPONEGORO No tlpon:083138717148
Whatsapp:083138717148.Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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