A Prompt AI Experiment
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
2 reads
Blog Posts
Fabric Real Time Data: Making the Shift from Batch to Live Insights
Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations transform raw information into actionable insights. For decades, leaders have relied on batch processing as...
2025-09-17 (first published: 2025-08-25)
68 reads
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs encounter: accessing a SQL Server instance when you don’t have the SA password, and no...
2025-09-17 (first published: 2025-09-02)
561 reads
SQL Server Is Slow (part 1 of 4)
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at you that SQL Server is slow? Stop. Don’t Open SSMS Yet. You’ve heard it...
2025-09-17
Installing Old Versions of PowerShell Modules with Their Dependencies
I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...
2025-09-16
6 reads
Scaling PowerShell – Lessons from a Technical Interview
Recently, I was in a technical interview where the topic of running PowerShell at scale came up. Although I’ve worked with PowerShell for quite some time, I realized I’d...
2025-09-16
17 reads
How to Reset the SA Password When You Get Locked Out
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved...
2025-09-15 (first published: 2025-08-27)
409 reads
In Memory of Andrew Clarke, AKA Phil Factor
One of the parts of getting older that really sucks is I seem to attend more funerals than weddings. It’s a sad fact of file, and this was one...
2025-09-15
179 reads
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries. They are navigators of complexity, interpreters of signals, and stewards of trust. Technology has transformed...
2025-09-15
3 reads
SQL Server Log Shipping: The Tried and True of DR
It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....
2025-09-15 (first published: 2025-08-27)
163 reads
Blogs
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers