Change Event Streaming (CES) in SQL Server 2025 and Azure SQL enables event-driven architectures by streaming JSON records from table activity to Azure Event Hub, with Entra support now available in ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

Tern is a standalone migration tool for PostgreSQL. It includes traditional migrations as well as a separate optional workflow for managing database code such as functions and views. Tern projects are ...

Even after 50 years, Structured Query Language, or SQL, remains the native tongue for those who speak data. It’s had impressive staying power since it was first coined the Structured Query English ...

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects simply to a non-technical, business audience. Over… DBMSs are important ...

Introduction: Retrieval Augmented generation (RAG) is a natural language processing (NLP) technique that combines information retrieval and natural language understanding with content generation. RAG ...

Technologists are awed by it. Colleges fear it. Currently, we’re all obsessed by it. But amid the noise, what can you actually do with ChatGPT? How might it serve a regular office worker? Join the ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

Here, I am going to discuss some basic and most important configurations of the SQL Server Instance and Database Level which might be ignored and can cause performance issues. Although this is not the ...