Here Are the YouTube Channels We Both Loved.
Last week, I announced that we’ve hit 50,000 YouTube subscribers, and I celebrated by letting y’all submit your […]
Sites anglophones
Building a Dynamic Countdown Timer in Power BI
The post Building a Dynamic Countdown Timer in Power BI appeared first on SQLServerCentral.
How to Use SQL Server Features to Cut Web App ...
A customer taps “Buy Now” on your web app. Half a second passes. The screen hesitates before the […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
Building a Simple SQL/AI Environment
Al is everywhere….almost. In my day-to-day role as a DBA, I don’t really have the opportunity or need […]
We Hit 50,000 YouTube Subscribers! Let’s Run a Contest.
This is kinda amazing to me: our YouTube channel has broken the 50,000 subscriber mark! That’s wild to […]
Microsoft Now Recommends You Set Max Memory to 75% and ...
Somehow I missed this a few years ago, and I bet a lot of y’all did too. Note […]
Side by Side Upgrade to SQL Server 2022
The post Side by Side Upgrade to SQL Server 2022 appeared first on SQLServerCentral.
Announcing Free Fundamentals Week 2025!
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon […]
How Well Does the MSSQL Extension in VSCode Work?
With the retirement of ADS, I decided to take a look at the MSSQL extension for VSCode. This […]
Getting Started with Bayesian Modeling
The post Getting Started with Bayesian Modeling appeared first on SQLServerCentral.
Build a Test Lab of SQL Server 2025 on Windows ...
Problem Now that public preview of SQL Server 2025 CTP 2.1 is out (Community Technical Preview), you have […]
[Video] Office Hours: Database Questions & Answers
In between clients, I hopped onto my Twitch channel to take your top-voted questions from https://pollgab.com/room/brento. If you’d […]
Your Developers Need Cheap SQL Training.
Your developers haven’t ever been to formal Microsoft database training on SQL Server or Azure SQL DB. They’re […]
SQL Server 2025 Makes Memory Troubleshooting Easier.
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots […]
Free Webcasts Tomorrow & Wednesday
I’m teaching my two most important classes live, online, completely free! These are the two fundamentals classes that […]
Parameter Sensitive Plan Optimization in SQL Server 2022
SQL Server 2022 has lot of improved and advanced features compared to its predecessor versions. This includes new […]
Configure SQL Server Alerts for Azure SQL Managed Instance
The post Configure SQL Server Alerts for Azure SQL Managed Instance appeared first on SQLServerCentral.
Revisiting SQL Server Window Functions- A Practical Walkthrough
Introduction Sometimes we just want SQL to be a bit smarter. Maybe we need to figure out who’s […]
[Video] Office Hours on the Beach in Cancun
In retrospect, I should have put on sunscreen – even for just a 20-minute Office Hours session on […]
A Rolling Filtered Index in SQL Server
The post A Rolling Filtered Index in SQL Server appeared first on SQLServerCentral.
Home Office Studio Tour
Ever wonder what it takes to do this stuff behind the scenes? I’ll show you. If you’re thinking […]
A Tribute to Andrew Clarke (a.k.a. Phil Factor)
We are deeply saddened to share the news that Andrew Clarke, better known to Simple-Talk readers as […]
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Introduction In this example, we will show patterns between items stored in SQL Server using Python. We will […]
SQL Server Triggers for Business Rules Automation
The post SQL Server Triggers for Business Rules Automation appeared first on SQLServerCentral.
Workspace Identity Authentication for your Power BI Semantic Models in ...
When you create a semantic model in Power BI desktop, you typically connect to one or more data […]
[Video] Office Hours Back at Home in Vegas
I’m back in Vegas, at least for the moment, so let’s hang out in my home office and […]
Who’s Hiring in the Microsoft Database Community? September 2025 Edition
Is your company hiring for a database position as of September 2025? Do you wanna work with the […]
Free Live SQL Server Classes This Month!
This month, I’m teaching two of my classes live, online, completely free! These are the two fundamentals classes […]
Picking the ON or WHERE Clause for the SQL Predicate
The post Picking the ON or WHERE Clause for the SQL Predicate appeared first on SQLServerCentral.
What is Delayed Durability in SQL Server — And Should ...
Introduction When SQL Server commits a transaction, it doesn’t just update data in memory. It also writes a […]
DevOps vs. SRE: Bridging the Gap, Not Building Walls
The post DevOps vs. SRE: Bridging the Gap, Not Building Walls appeared first on SQLServerCentral.
[Video] Office Hours in Icy Strait Point, Alaska
For the last couple of months, I’ve been trying to get my on-location Office Hours episodes filmed with […]
Why Aren’t People Going to Local and Regional In-Person Events ...
Steve Jones recently posted an update about SQL Saturday’s status, and it includes some news we need to […]
PostgreSQL High Availability Options
The post PostgreSQL High Availability Options appeared first on SQLServerCentral.
SQL Server 2025 RC0 Is Out with New Preview Features ...
The release of SQL Server 2025 keeps inching closer. Release Candidate 0 is out now, and here are […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The JOIN statement is one of the most common operations SQL developers perform. Yet in a world […]
Using psycopg2 to Connect Python to PostgreSQL
Overview The psycopg2 library makes working with PostgreSQL databases in Python much easier. This has been the most […]
Long Short-Term Memory Network for Machine Learning
The post Long Short-Term Memory Network for Machine Learning appeared first on SQLServerCentral.
From Rows to Pages: The Hidden Chaos Behind SQL Server’s ...
Introduction Sampling data is a common requirement in many real-world SQL Server workloads. Whether you are trying to […]
SQLBits 2026 is Going Back to Newport, Wales.
SQLBits 2026 will be back at the International Convention Center Wales in Newport on April 22-25, and I’ll […]
Contained Availability Groups in SQL Server 2022
SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively […]
Save $150 on the Summit with Discount Code BRENT25
The PASS Data Community Summit is the biggest conference in the Microsoft database industry, and over the last […]
MySQL Shell Basic Configuration Management (Part 6 – Backups and ...
In this final part of the MySQL Shell Configuration Management series, we explore how to automate performance […]
Split strings by Regular Expressions in SQL Server 2025
The post Split strings by Regular Expressions in SQL Server 2025 appeared first on SQLServerCentral.
[Video] Office Hours: Docked in Miami Beach
On the last day of my Caribbean cruise, as we pull into port in Miami, let’s go through […]
Make the Comment Section Look Like a Junior DBA’s Search ...
Tomorrow’s scheduled webcast for Mastering Parameter Sniffing is off due to a scheduling issue, so in the meantime, […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
PostgreSQL is an open-source relational database management system valued for its power, standards-compliance, and extensibility. Whether you’re […]
Enable TDE for Databases in a SQL Server AlwaysOn Availability ...
The post Enable TDE for Databases in a SQL Server AlwaysOn Availability Group appeared first on SQLServerCentral.
AI is Like Outsourcing. #TSQL2sday
When you ask data people how they feel about AI, you get pretty rabid, extreme reactions. People either […]