How to process images and analyze charts with AI
In this article, we will see how to handle images with AI. Sometimes we need to import the […]
Sites anglophones
Replicating MySQL databases in Docker Containers
In my prior article, “Running a relational database with Docker”, I showed how to spin up a […]
Dimensional Modeling Case Study Part 3 – Dynamic Days Dimension
Background In this case study series, we’ve explored how to use age and tally tables to support various […]
Load Data into Snowflake Using Native Snowflake Connector for Python: ...
In our ongoing exploration of Snowflake data loading strategies, we’ve previously examined how to use pandas with […]
[Video] Office Hours at the Barcelona Pavilion
I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I […]
Securing the Data Layer: Why SQL Developers Should Care About ...
Editor: This is AI generated, which is against our policy. The Hidden Risks Above the Database In today’s […]
Query Exercise Answers: Returning Routes in the Right Order
In your most recent Query Exercise challenge, I gave you these two tables: DROP TABLE IF EXISTS dbo.Stations; […]
SQL Server 2025 : Zstandard Backup Compression
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
Guide to Decoding SQL Server Bulk Insert Error Files
Learn how to work with SQL Server’s ERRORFILE option to isolate problem records, decode cryptic error messages, and […]
TempDB Resource Governor Space Controls in SQL Server 2025
TempDB is a system database in SQL Server that manages temporary objects for all databases on a […]
SQLBits Added More Capacity to My Workshop! Move Quick.
I’m coming to London this month for SQLBits, and my Thursday workshop “Faster, Cheaper Cloud Databases” workshop sold […]
The good, the bad, and the awful taste muscle memory ...
When I was traveling a while back, I grabbed a small white metal tube out of my […]
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Performance tuning in Azure SQL Database can feel like solving a puzzle—get it right, and your queries fly; […]
Sponsoring Scenic City Summit
For the second year in a row, Simple Talk will sponsor Scenic City Summit in Chattanooga, TN, […]
Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation
PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group […]
SQL Automate – A DBA’s Time-Saving Toolkit
Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to […]
Index Scans and Table Scans
The post Index Scans and Table Scans appeared first on SQLServerCentral.
Oracle ASM: A Simple Solution or Another Complexity? (part 1)
For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure […]
[Video] Office Hours in the Detroit Airport
I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to […]
Query Exercise: Return Routes in the Right Order
I’mma be honest with you, dear reader: this query exercise stems from a client problem that I couldn’t […]
Performing a Bulk Insert in SQL Server
Learn how to use the BULK INSERT command to import large data sets into SQL Server.
Managing Fabric Lakehouse objects with the new CLI: Data Engineering ...
Microsoft Fabric has been evolving since its general availability in November 2023. Developers have asked for a command […]
Who’s Hiring in the Microsoft Database Community? June 2025 Edition
Is your company hiring for a database position as of June 2025? Do you wanna work with the […]
MySQL vs. PostgreSQL: Date and Time Data Types
Date and time data types are important because they help track and manage time-based information in databases. […]
DMV Comparison for SQL Server 2019 vs Azure SQL Database
The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
When you create a data pipeline in Microsoft Fabric, you typically use one or more connections. A connection […]
Moving from SQL to MongoDB’s MQL
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Power BI Mistakes to Avoid – Part 2
The post Power BI Mistakes to Avoid – Part 2 appeared first on SQLServerCentral.
Sentiment Analysis & Key Phrase Detection
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to […]
Using Parameters with DAX in Report Builder
This is something we expect to be simple, but it has a lot of secrets. Using parameters […]
Running a MySQL database in a Docker Container
Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting […]
[Video] Office Hours: Recovering from a Cold Edition
While recovering from a nasty cold, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 […]
How to easily connect and query your SQL Server Data ...
Editor: Thanks for this. It’s not bad, but what it’s lacking is showing how to use ODBC from […]
Review: SSMS Copilot vs Other AI Tools
I use AI tools constantly in my work, so when the new SSMS v21 came out with Copilot support, […]
Our Anniversary Sale Ends This Week!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
DISTINCT and UNION: What happens when you use them together?
When I was perusing my LinkedIn feed the other day, I came across this thread about using […]
Free Webcast Tomorrow: Mastering Server Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
Top 5 Power BI Common Pitfalls
The post Top 5 Power BI Common Pitfalls appeared first on SQLServerCentral.
Introduction to GitHub Actions Part 2: GitHub-hosted runners
The post Introduction to GitHub Actions Part 2: GitHub-hosted runners appeared first on SQLServerCentral.
Azure Databricks Liquid Clustering: A Comprehensive Guide
Editor: This looks very AI written. You are using lots of lists and not really explaining things in […]
Data Encoding Schemes
You probably noticed that when you get a bill or bank statement, it uses the current modern […]
How SQL Server 2025’s Optional Parameter Plan Optimization Works
About three years ago, SQL Server 2022 introduced Parameter-Sensitive Plan Optimization (PSPO). At the time, I explained that […]
SQL Server Developer Standard Edition: A Gift to Developers!
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
How I Configure SQL Server Management Studio v21
Several years ago, I wrote a post about how I configure older versions of SQL Server Management Studio, […]
SQL Server 2025 is in Public Preview!
On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public […]
SQL STRING_AGG Function Use and Examples
The post SQL STRING_AGG Function Use and Examples appeared first on SQLServerCentral.
New Objects in SQL Server 2025 – And Thousands of ...
The first public preview of SQL Server 2025 dropped yesterday, and here’s what’s new under the hood as […]
How to Migrate Data to a New SQL Server Database
This guide demonstrates how to efficiently migrate existing data, including data from SQLite, into a SQL Server database.
SQL Server 2022 on Ubuntu 24.04 step by step
Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it […]
First LLM Technical Editor Test – Office and Web-based Copilot ...
Next up, I am going to give Microsoft Copilot its chance to check for technical inaccuracies in […]