Learn about using SQL Server to support AI-enhanced search queries with the Relational Embedding Retrieval Pattern (RERP).
2026-04-24
1,574 reads
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,221 reads
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,188 reads
Get a quick glimpse of using AI in SQL Server by implementing a machine learning system.
2025-07-11
2,843 reads
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
15,753 reads
A short look at some of the options for deleting lots of data from a SQL Server table.
2024-10-07
7,482 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Metro Pondok Indah No.60 & 61 UA, Pd. Pinang, Kec. Kebayoran Lama, Kota...
Jl. Jatinegara Bar. No.4 C 1, RT.2/RW.4, Wil, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah...
The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt. Mezzanine Unit A...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers