
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 […]
Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to […]
The post Index Scans and Table Scans appeared first on SQLServerCentral.
For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure […]
I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to […]
I’mma be honest with you, dear reader: this query exercise stems from a client problem that I couldn’t […]
Learn how to use the BULK INSERT command to import large data sets into SQL Server.
Microsoft Fabric has been evolving since its general availability in November 2023. Developers have asked for a command […]
Is your company hiring for a database position as of June 2025? Do you wanna work with the […]
Date and time data types are important because they help track and manage time-based information in databases. […]
The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.
When you create a data pipeline in Microsoft Fabric, you typically use one or more connections. A connection […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
The post Power BI Mistakes to Avoid – Part 2 appeared first on SQLServerCentral.
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to […]
This is something we expect to be simple, but it has a lot of secrets. Using parameters […]
Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting […]
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 […]
I use AI tools constantly in my work, so when the new SSMS v21 came out with Copilot support, […]
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
When I was perusing my LinkedIn feed the other day, I came across this thread about using […]
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
The post Top 5 Power BI Common Pitfalls appeared first on SQLServerCentral.
The post Introduction to GitHub Actions Part 2: GitHub-hosted runners appeared first on SQLServerCentral.
You probably noticed that when you get a bill or bank statement, it uses the current modern […]
About three years ago, SQL Server 2022 introduced Parameter-Sensitive Plan Optimization (PSPO). At the time, I explained that […]
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
Several years ago, I wrote a post about how I configure older versions of SQL Server Management Studio, […]
On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public […]
The post SQL STRING_AGG Function Use and Examples appeared first on SQLServerCentral.
The first public preview of SQL Server 2025 dropped yesterday, and here’s what’s new under the hood as […]
This guide demonstrates how to efficiently migrate existing data, including data from SQLite, into a SQL Server database.
Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it […]
Next up, I am going to give Microsoft Copilot its chance to check for technical inaccuracies in […]
Last week, Microsoft Fabric went down yet again for hours on multiple continents. Oh, you didn’t hear about […]
Working with SSMS can sometimes be quite frustrating, but there are many options provided to make your day […]
The post Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security appeared first on SQLServerCentral.
Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the […]
Introduction Removing SQL Server Data File Without Downtime is one of important activities in enterprise production scenarios. Managing […]
The post SQL ASCII Function Use and Examples appeared first on SQLServerCentral.
Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of […]
Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered […]
Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to […]
Learning something new has elements of bliss and terror. We all know the bliss of learning something […]
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your […]
In my last post I described issues that might stop your migration to a SQL Server Managed […]
In more than 10 years of experience, I have dealt with cases where someone has performed incorrect […]
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
The post Evaluating the Randomness of SQL Server Random Number Functions appeared first on SQLServerCentral.
In the fast-paced world of business, fast, effective data management is crucial. One of the places where […]
Working with dates in SQL Server is something almost every developer runs into. You might need to figure […]