A Security and AI Fail
Security is an important consideration for anyone working with data, but it's especially a concern with AI.
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Learn about using classification as a technique to prepare your data for additional machine learning analysis.
Confession Time: I Never Taught You About B-Trees.
I work with databases for a living. I teach people, and I help them via consulting. And as far as I can remember, I’ve never written something about how b-trees work.
It’s 2026. Why are databases still failing GDPR compliance audits?
This article examines three recurring database-layer failures documented in the EDPB’s 2026 enforcement findings: the complexity of executing erasure across relational schemas, the backup paradox that can silently undo compliant deletions, and the audit log contradiction that traps organizations between two competing obligations.
Forward Deployed Engineers
A new job title, the forward deployed engineer, is becoming more popular.
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
This article shows how the TRY_PARSE() and TRY_CONVERT() functions can be used to handle data quality issues and ensure that your software continues to function without throwing errors.
Understanding Deadlock Victim Selection in SQL Server
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
SSRS Reminded Me of the Time Microsoft Retired TMG
Reading that SQL Server 2025 shipped without SSRS took me back to 2012, when Microsoft announced end-of-life for TMG — our perimeter firewall, web proxy, and SSL inspection. It had run quietly for years until it suddenly needed a plan. Within weeks, vendors found us. Demos, a steering committee, a three-month project plan. We weren't […]
I Can't Make You Learn
Steve believes that his career and life have become better as he learns more everything. It's the key to improvement.
Why Your SQL Permissions Disappeared
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers