Designing SQL Server ETL Pipelines That Don't Break at Scale
A few lessons learned in building ETL pipelines and tricks to ensure you can easily maintain these over time.
2026-05-15
3,323 reads
SQL Expert
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Learn about using SQL Server to support AI-enhanced search queries with the Relational Embedding Retrieval Pattern (RERP).
2026-04-24
1,985 reads
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Introduction. Why AI Readiness Starts in the Database You probably don’t need machine learning today. Most organizations don’t. You already have reporting dashboards, operational workflows, and business intelligence that work just fine without neural networks or predictive models. That’s not a failure. It’s normal. The problem doesn’t show up immediately. It shows up a few […]
2026-02-27
2,430 reads
Building a Real-Time Analytics Pipeline with Azure Stream Analytics and SQL Server
Learn how a real time analytics solution for ETL and reporting can be built with SQL Server, Power BI, and Stream Analytics.
2026-01-26
1,360 reads
SQL Server and AI: Integrating Machine Learning Services
Get a quick glimpse of using AI in SQL Server by implementing a machine learning system.
2025-07-11
3,167 reads
JSON in Microsoft SQL Server: A Comprehensive Guide
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL Server, starting from version 2016, introduced built-in support for JSON, allowing developers to work with JSON data more efficiently within the relational database environment. This article will explore how to store, retrieve, and manipulate JSON data in […]
2025-01-31
17,039 reads
How to Delete Large Amounts of Data in Microsoft SQL Server
A short look at some of the options for deleting lots of data from a SQL Server table.
2024-10-07
7,805 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers