Last week I stood in front of a classroom at Washington State University and looked out at a room full of students who had done everything right. They had studied hard, were earning their degrees, built their portfolios, and showed up with genuine enthusiasm for careers in technology. They wanted to know what the industry […]
A few lessons learned in building ETL pipelines and tricks to ensure you can easily maintain these over time.
Today, Kendra explains why she doesn't like shared development databases.
LLMs should be used in data pipelines for unstructured text, semantic search, and natural language queries – but avoided for deterministic, high-volume, or regulated tasks. Drawing on my real-world experience building large-scale ML systems, in this guide I’ll explain exactly where LLMs belong in your data pipeline and, just as importantly, where they don’t.
Learn about restoring your keys from an Azure Key Vault in the event of a DR situation.
We often learn to write code before we really learn to read it, which seems like a problem to Steve.
In theory, SQL Server performance monitoring is pretty simple: 1. Review the server’s top wait types, 2. Find the queries causing those wait types, 3. Fix those queries, or improve the way the server reacts to them (indexes, settings, etc.). But in practice, step 2 is awful because:
This editorial was originally published on Jun 17, 2020. It is being republished as Steve is out of town. Let us know if you've changed your SQL IDEs since then. Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us […]
SQL Server 2025 shipped without SSRS. If you're managing paginated reports, your options just narrowed; but they're not what most people think. I evaluated all 10 realistic migration paths. Here's an honest comparison, including the one I built.
Explore the mechanics of the SOFTMAX function in SQL Server. Transform scores into probabilities with this essential tool.
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers