Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant
It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply …
Fabric Database: Advanced Vector Search Features
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about some advanced features available in both of them. Before analysing these advanced features, we need to understand some concepts abo …
Fundamentals Week 2025 is Coming This Month! Get Your Tickets Now.
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …
Scales & Measurements
The post Scales & Measurements appeared first on SQLServerCentral.
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this concept about seven years ago in which there were two architectural designs: either store data in Azure SQL Database and transform data using stored p …
Free Webcast Tomorrow: Fundamentals of TempDB
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m teaching Fundamentals of TempDB, and we’re going to be covering temp table statistic …
Sponsoring SQL Saturday Richmond This Week
On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. Having worked for a company in Virginia Beach for most of my career, Richmond’s events were always a regular stop for me over the years. I have known many …
Managed Instance Gotchas – Error Conditions
I was recently on a project to migrate a very transactional installation of SQL Server to Azure SQL Managed Instance (MI). SQL Managed Instance is a good stepping stone between a full, on-prem SQL instance / Azure VM and an Azure SQL Database. It has m …
DeepSeek: What is new with this AI technology?
Introduction I was happily resting in Samaipata, a pre-Inca temple admiring the ruins with our guide when a colleague wrote me. Dan, you need to watch this! Then he showed me the news about DeepSeek. It was the most interesting news of the year, so I s …
Load Data into Snowflake Using Python with Pandas
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals. Whether you’re pulling data from a relational database, wrangling a CSV file, or prototyping a new pipeline, this combination lever …
Basic Regex Emulator for SQL Server
The post Basic Regex Emulator for SQL Server appeared first on SQLServerCentral.
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
In February 2025, Microsoft introduced new T-SQL functions in Azure SQL Database and SQL Database in Microsoft Fabric to enhance fuzzy string matching capabilities. You can visit Exciting new T-SQL features: Regex support, Fuzzy string-matching, and bi …
[Video] Office Hours: Back in the Home Office
I’m back home after a 2-week Iceland vacation. Let’s catch up with your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:04 Suresh: Hi Brent . Question about 128 GB memory limit for SQL …
The CREATE DOMAIN Statement
One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does not exist in SQL Server as of SQL Server 2022, but it has been a part of PostgreSQL since 7.3. Some definitions from other smart people Chris Date defined a doma …
Fabric: Query a SQL Endpoint from a Notebook
Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how to make a query to a SQL Endpoint. We use notebooks to connect directly to lakehouse. Except by the T-SQL notebook, the notebooks have a default …