[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: […]
Sites anglophones
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 […]
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity […]
[Video] Office Hours in Camden Harbor
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions […]
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like […]
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
The post Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud appeared first on SQLServerCentral.
Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt […]
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong […]
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
“How do my peers do this?” The latest best practices ...
The post “How do my peers do this?” The latest best practices for IT architects implementing a major […]
What are Warehouses in Microsoft Fabric?
The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral.
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...
Last but not least, the Community Keynote. Hang on to your hats, this is going to be […]
Is your organization using MongoDB? Help the Redgate Flyway team ...
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points. appeared first […]
How to get your security team on board with your ...
The post How to get your security team on board with your cloud migration appeared first on SQLServerCentral.
Scheduling SQL Agent Jobs on Alternating Weeks
Bi-week… semi-week… fortnight… « every two weeks » Recently on the SQL Community Slack group, someone asked if there was […]