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 […]
Sites anglophones
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 […]
PASS Summit 2023 – Redgate Keynote – The New Database ...
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […]
[Video] Office Hours at Megunticook Falls in Camden, Maine
While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered […]
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […]
Office Hours, Silent Film Edition
Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how […]
SQL Server Table Design Guidelines – Data Types, Designing for ...
The post SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys appeared first […]
How to join the free PASS Data Community Summit Livestream ...
There’s nothing quite like attending PASS Data Community Summit in person to reconnect with friends and make new professional connections […]
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]