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 […]
Archives de l’année : 2025
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 […]
Don’t Let Your Kids Drop ACID.
We’re heading towards graduation time. In just a few short months, your high school kids are going to […]
Techniques to query Azure SQL’s new JSON Datatype
The new JSON field type and new functions in Azure SQL brings a new world of possibilities […]
SQL Server Cursor Example
The post SQL Server Cursor Example appeared first on SQLServerCentral.
Jacksonville SQL Saturday 2025 Roundup
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida […]
Who’s Hiring in the Microsoft Data Platform Community? May 2025 ...
Is your company hiring for a database position as of May 2025? Do you wanna work with the […]
MySQL Index Overviews: Hash Indexes
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as […]
Data-Based Movie Reviews: Moneyball
A while back, a friend of mine, who is big into baseball, tried to encourage me to […]
Free Webcast Tomorrow: Mastering Index Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
Understanding MERGE to Insert, Update, and Delete Data Simultaneously
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
Query Lineage in Fabric Lakehouses
I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability […]
Return stored procedure parameter values to a calling stored procedure
The post Return stored procedure parameter values to a calling stored procedure appeared first on SQLServerCentral.
Modern Streaming Architecture Serverless Pool with Spark Streaming
Introduction Many high-volume data sources, including sensors, logs from mobile applications, and the Internet of Things, operate in […]
Announcing Our Anniversary Sale!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
Purging Data from a Large Table in SQL Server
Purging data from a table is a common database maintenance task to prevent it from growing too […]
[Video] Office Hours: Hot Dog Fingers Edition
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, […]
SQL Server 2022 Finally Fixed a SQL Server 2008 Query ...
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan […]
Working with the MongoDB Database Tools
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Meta AI by Facebook: A New Contender in the AI ...
Introduction Meta AI from Facebook is one of the last big technology giants’ contenders in the AI battle. […]
Using try catch in SQL Server stored procedures
The post Using try catch in SQL Server stored procedures appeared first on SQLServerCentral.
Écologie, performance et coûts – un comparatif PostGreSQL vs SQL ...
Bien loin de couter autant qu’Oracle, SQL Server est considéré comme plus puissant que ce dernier et incommensurablement […]
Retrieving Data Using the REST API in Data API Builder
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this […]
[Video] Office Hours: Hello Kitty Porsche Edition
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer […]
How to Load a Date Dimension in Microsoft Fabric using ...
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
Introduction to SQL Commands, Part 3: Retrieving and Sorting Data
In the final part of this series, learn how to use SQL Server’s SELECT command to retrieve, filter, […]
Using the CASE expression instead of dynamic SQL in SQL ...
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Building AI Calls into the First Responder Kit
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your […]