[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? […]
Sites anglophones
Sending resource alerts on Managed Instance using db_mail
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
Why Don't You Upgrade in Place?
Ask a senior-level SQL Server or Windows administrator about doing in-place upgrades and you’ll likely get a negative […]
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s […]
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes […]
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where […]
Configuring an SSIS ForEach Loop for Multiple File Types
The Problem The SSIS Foreach Loop component has a limitation when it comes to selecting different sets of […]
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address […]
Searching an Encrypted Column
When encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic […]
Running Azure CosmosDB queries from SQL Server using ODBC driver
The post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral.
MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect […]
[Video] Office Hours: Sunshine Edition
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
[Video] Office Hours: Really Good Questions Edition
Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: […]
SQL GROUP BY Alias – An Oracle feature that would ...
The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared […]
What Would You Ask Your Predecessor? Get Answers with ChatGPT.
So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, […]
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […]
What is subsetting, what are the advantages, and how does ...
The post What is subsetting, what are the advantages, and how does it make test data management easier? […]
Identify log write limits on Azure SQL Managed Instance using ...
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
How using a database monitoring tool helps DBAs create value ...
The post How using a database monitoring tool helps DBAs create value for the whole organization appeared first […]
Window Function Basics – PARTITION BY
One of the things that I’ve done over the last year to improve my T-SQL skills is learn […]
Learn Spark SQL Date and Time Functions
The post Learn Spark SQL Date and Time Functions appeared first on SQLServerCentral.
SQL Server: Optimize for Ad Hoc Workloads – use or ...
I used to believe this option was something almost absolute: it should be enabled as best practice. […]
How Has Inflation Affected Your Salary? Let’s Find Out Together.
The 2020s have been tough: a pandemic, a recession, layoffs, and inflation. Inflation makes things particularly tricky because […]
Plansplaining, part 20. SQL Graph (part 1)
The post Plansplaining, part 20. SQL Graph (part 1) appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? December 2023 ...
Is your company hiring for a database position as of December 2023? Do you wanna work with the […]
Understanding SQL Join Types
Understanding how to join the data in one table to another is crucial for any data analyst […]
GitHub Copilot – Our Best Ally to for T-SQL
Introduction Previously, we wrote about Copilot and showed how to install and work with it. A GitHub copilot […]
Championing DevOps: A Panel Webinar
The post Championing DevOps: A Panel Webinar appeared first on SQLServerCentral.
PowerShell Commands to Administer Virtual Machines on Amazon AWS – ...
The post PowerShell Commands to Administer Virtual Machines on Amazon AWS – Part 2 appeared first on SQLServerCentral.
ChatDBA: ChatGPT 4 Answers 5 Office Hours Questions
Every now and then, someone asks a question on PollGab about why I don’t use ChatGPT to answer […]
Getting Started with DDL statements of Cassandra Query Language
Article Overview In this tutorial, we’ll learn the essential DDL concepts of Cassandra query language (CQL) and how […]
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
[Video] Office Hours: Live on Black Friday Edition
On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento. […]
TABLOCK Hint can Negatively Impact SQL Server Concurrency
The post TABLOCK Hint can Negatively Impact SQL Server Concurrency appeared first on SQLServerCentral.
Using the Import Extension in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Working with Azure DocumentDB: SQL & NoSQL Together
The post Working with Azure DocumentDB: SQL & NoSQL Together appeared first on SQLServerCentral.
[Video] Office Hours: Black Friday Promo Edition
In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now! Here’s […]
BrentOzar.com Cyber Monday Week Sale
Every November, we run a huge sale here on my training courses, apps, and online services. Now’s your […]
When an update doesn’t update
Tell me if you’ve heard this one before: I changed data from my application, but when I […]
Time Series Data Mining Example with T-SQL when Adding New ...
The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral.
Ensuring a Single Row Table
Single row tables in data modeling Single row tables are a fact of our life as as a […]
Warehouse Load Patterns – Part 1 – Requirements and General ...
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
It’s Black Friday! Time to save big on SQL Server ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
Black Friday returns to SQLServerFast
The post Black Friday returns to SQLServerFast appeared first on SQLServerCentral.
Unpivoting Multiple Sets of Columns in SQL Server using CROSS ...
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my […]
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present […]