The SQL Server 2016 Plan
Steve notes SQL Server 2016 went out of support this past week. What are you plans if you run this version?
Implicit Conversions Cripple SQL Server
Learn about implicit conversions, which can dramatically affect the performance of your workload.
The Mythical Bus Accident
Preparing for disaster is important, both at work and in your personal life.
Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs
Learn how to use VECTOR_DISTANCE and VECTOR_SEARCH in SQL Server to find semantically similar data.
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.
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
ALAMAT BANK BCA KCU TARAKAN TLP/WA 08218200203
Hub Cs:08218200203 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan,...
Alamat Bank BCA KCU BALIKPAPAN Telp 08218200203
Hub.Via,WhatsApp:08218200203 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
Alamat Bank BCA KCU PALANGKARAYA Telp 08218200203
Hub.Via,WhatsApp:08218200203 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan Tengah...
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers