
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 […]
Je viens de passer près de 40 ans de ma vie dans le domaine des bases de données […]
It’s a tale as old as time. You want to read data. Your mate wants to write […]
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. […]
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
The post Scales & Measurements appeared first on SQLServerCentral.
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this […]
Ce matin, j’ai eu la chance d’être présent à Las Vegas à la Keynote de la 2eme […]
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. […]
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]
Introduction I was happily resting in Samaipata, a pre-Inca temple admiring the ruins with our guide when a […]
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution […]
The post Basic Regex Emulator for SQL Server appeared first on SQLServerCentral.
In February 2025, Microsoft introduced new T-SQL functions in Azure SQL Database and SQL Database in Microsoft Fabric […]
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 […]
One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does […]
Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can […]
For this week’s Query Exercise, your mission had two parts: Do a first pass search through the Users […]
Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets […]
tl;dr: if you use Azure SQL DB Hyperscale’s auto-scaling, it’s probably not cutting your bill down because like […]
The post SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG appeared first on SQLServerCentral.
When working with SQL Server, there are times when you need to build SQL scripts dynamically. In many […]
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
A very common task in creating a database is to store string data. For example, words, paragraph(s) […]
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s […]
Regular expressions are a way of doing complex string searches. They can be really useful, but they have […]
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]
The post AI Tools for Job Seekers – Salary appeared first on SQLServerCentral.
L’utilisation par défaut de VEEAM backup combiné à SQL Server détruit vos journaux de transactions… Le saviez-vous ? […]
“They put their password WHERE?!?” Personally identifiable information (PII) is freakin’ everywhere. When companies first start looking to […]
This is part of a series of posts from Aisha Bukar comparing MySQL and PostgreSQL. You can […]
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
The second I wrote down the idea for a blog posts on Distractions, I knew there had […]
Because it’s important to know when adversaries are scanning the network searching for vulnerabilities, misconfigurations, unpatched systems or […]
There comes a time when the built-in ORM just isn’t enough. You might have complex queries or performance-critical […]
The post Data Streaming Databricks in Azure appeared first on SQLServerCentral.
As we approach the first public releases of SQL Server 2025, it’s fun to start spelunking through things […]
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Overview Amazon RDS allows users to create multiple databases within a single database instance. And connections to each […]
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Deploying a DACPAC to an Azure SQL Database is a critical step in ensuring your database changes are […]
The post INFO.VIEW DAX Functions Usage and Examples appeared first on SQLServerCentral.
The post The State of the Database Landscape in 2025: Insights and trends appeared first on SQLServerCentral.
if you’re going to work with databases, you probably ought to know something about data. In particular, […]
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
I’m in Iceland this week, land of fire and ice, a place I keep coming back to over […]
The holidays truly are over, and it is time to hit the road again here at Simple […]
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided […]
Starting next Tuesday, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]