The Fabric Modern Data Platform
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
Archives de l’année : 2025
Securing the DevOps Pipeline Part 1: Tools and Strategies for ...
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard ...
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
Oracle’s Limited Cloud Vendor Licensing
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
Updated First Responder Kit and Consultant Toolkit for April 2025
This quarter’s release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about […]
New Series – Testing LLMs as Technical Editors
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
How to Remove Constraints from a SQL Server Table
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
Creating a Date Dimension (Calendar Table) in SQL Server
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]
The Waitlist is Open Now for My SQLBits Workshop!
I’m excited to return to London for SQLBits again this year! I’ve written about why SQLBits is my […]
SQL Server vs PostgreSQL
PostgreSQL est de plus en plus populaire. Est-ce un bon choix pour remplacer SQL Server on-prem et […]
The complexity of using Power BI in US Sovereign Clouds
The post The complexity of using Power BI in US Sovereign Clouds appeared first on SQLServerCentral.
Elements of the SQL Server Update Statement
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update […]
[Video] Office Hours in North Bay, Canada
Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I […]
Working with MongoDB Shell
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Tap Tap Tap – Short, Silent SQL Server Tutorials
One of the things I love about TikTok is that it exposes me to wildly new video ideas […]
Killing a SPID and Checking Rollback progress in SQL Server
The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.
Free Webcast: Avoiding Deadlocks by Query Tuning
Deadlocks used to scare me. I’d get the alert from a monitoring tool, and I’d look around to […]
Data Elements on a Nominal Scale
“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan […]
Free Webcast Tomorrow: Fundamentals of Columnstore
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Navigating Your Test Data Challenges: Insights and Solutions
The post Navigating Your Test Data Challenges: Insights and Solutions appeared first on SQLServerCentral.
Introduction to GitHub Actions Part 1: Getting Started
The post Introduction to GitHub Actions Part 1: Getting Started appeared first on SQLServerCentral.
Understanding UNION and UNION ALL in SQL Server
Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve […]
DAX CASE Statement Functionality using IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality using IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Windows Clustered MSDTC and SQL Server 2019 mishap
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each […]
Qu’est ce qu’un expert en informatique ? Comment le devient-on ...
Je viens de passer près de 40 ans de ma vie dans le domaine des bases de données […]
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 […]
Fabric Database: Advanced Vector Search Features
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. […]
Fundamentals Week 2025 is Coming This Month! Get Your Tickets ...
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Scales & Measurements
The post Scales & Measurements appeared first on SQLServerCentral.
Create Raw Zone Tables using Generative AI: Data Engineering with ...
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this […]
Retour à chaud de la FabCon 2025
Ce matin, j’ai eu la chance d’être présent à Las Vegas à la Keynote de la 2eme […]
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 […]
Sponsoring SQL Saturday Richmond This Week
On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. […]
Managed Instance Gotchas – Error Conditions
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]
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 […]
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 […]
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 […]
[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 […]
The CREATE DOMAIN Statement
One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does […]
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 […]
Query Exercise Answer: Finding Email Addresses
For this week’s Query Exercise, your mission had two parts: Do a first pass search through the Users […]
Improving the Performance of UPDATE Statements in SQL Server
Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]
The Wide World of GiST Indexes
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets […]
Why Your Azure SQL DB Hyperscale Bill is Higher Than ...
tl;dr: if you use Azure SQL DB Hyperscale’s auto-scaling, it’s probably not cutting your bill down because like […]
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
The post SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG appeared first on SQLServerCentral.
Dynamic T-SQL Script Parameterization Using Python
When working with SQL Server, there are times when you need to build SQL scripts dynamically. In many […]
Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
MySQL vs PostgreSQL – String Datatypes
A very common task in creating a database is to store string data. For example, words, paragraph(s) […]