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 […]
Archives de l’année : 2025
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. […]
SQL Server 2025 – Change Event Streaming
Les missions que je réalise au quotidien pour mes clients sont diversifiées. Et c’est « Win-Win » comme disent certains, […]
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 […]
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.
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 […]
Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ...
Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing […]
SQL Server 2025 – AI ready enterprise database from ground ...
SQL Server 2025 is poised to redefine the landscape of database management with its innovative AI-ready enterprise database […]
Announcing Public Preview of DiskANN in SQL Server 2025
We are excited to announce the public preview of DiskANN in SQL Server 2025, a significant advancement in […]
Fabric Is Just Plain Unreliable, and Microsoft’s Hiding It.
Last week, Microsoft Fabric went down yet again for hours on multiple continents. Oh, you didn’t hear about […]
Helpful Management Studio Settings and Features
Working with SSMS can sometimes be quite frustrating, but there are many options provided to make your day […]
Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud ...
The post Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security appeared first on SQLServerCentral.
What are the Key DevOps Performance Metrics You Should Track?
Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the […]
How to Safely Remove a SQL Server Data File Without ...
Introduction Removing SQL Server Data File Without Downtime is one of important activities in enterprise production scenarios. Managing […]
SQL ASCII Function Use and Examples
The post SQL ASCII Function Use and Examples appeared first on SQLServerCentral.
[Video] Office Hours at the Hoover Dam
Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of […]
MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL ...
Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered […]
Predicting When SQL Server Will Hit the CPU Wall
Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to […]
Introduction to PostgreSQL for the Data Professional
Learning something new has elements of bliss and terror. We all know the bliss of learning something […]
SQL ConstantCare Badges
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your […]
Managed Instance Gotchas – Configuration Items
In my last post I described issues that might stop your migration to a SQL Server Managed […]
Recovering data in SQL Server without full backup
In more than 10 years of experience, I have dealt with cases where someone has performed incorrect […]
Free Webcast Tomorrow: Mastering Query Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
Evaluating the Randomness of SQL Server Random Number Functions
The post Evaluating the Randomness of SQL Server Random Number Functions appeared first on SQLServerCentral.
Parent – Child Task Automation in Snowflake via Task Graph
In the fast-paced world of business, fast, effective data management is crucial. One of the places where […]
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and ...
Working with dates in SQL Server is something almost every developer runs into. You might need to figure […]
Real-time Data Streaming in Snowflake
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to […]
[Video] Office Hours: Speed Round!
Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round: Here’s what […]