Data analysis is all about wrangling massive datasets. To do that efficiently, you need a database that can handle the pressure. That's why data analysts turn to relational databases,...
2024-09-25 (first published: 2024-09-14)
89 reads
Let's be honest – SQL can be a bit of a beast. At first glance, it seems simple enough. But as you dive deeper, the complexity ramps up. Suddenly,...
2024-09-23
63 reads
My company is moving from an Azure PostgreSQL single server to a flexible server. We want to set up managed identity/Entra access instead of having roles with passwords for...
2024-09-23 (first published: 2024-09-05)
63 reads
I get many of the same questions about Microsoft Purview, so I wanted to list those common questions here along with their answers. If your question is not answered...
2024-09-23 (first published: 2024-09-12)
274 reads
I have often made an effort to attend conferences in the past to grow my career. Even today, when I speak at a conference, I’ll try to go to...
2024-09-23
18 reads
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family, or friends and colleagues, or colleagues and family – mixing a medley of ingredients that...
2024-09-20
18 reads
I wanted my own custom image in our internal Redgate Clone cluster, so I decided to make one. This is an overview of how this works. This is a...
2024-09-20 (first published: 2024-09-09)
135 reads
Today I have uploaded SQL Server Quickie #47 to YouTube. This time I’m talking about Azure SQL Database. If you are interested in learning more about this very interestingh...
2024-09-20 (first published: 2024-09-05)
223 reads
Let me be extremely clear up front, this is not my original work. I saw this post on DBA.StackExchange.com and I wanted to share and promote it. Nice work...
2024-09-18 (first published: 2024-09-02)
133 reads
Introduction In this post, the second in our series, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server 2022 to take a snapshot...
2024-09-18 (first published: 2024-09-01)
312 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers