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
101 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)
143 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)
1,429 reads
Secure Logic Apps with OAuth Authorization
I’ve used Logic Apps a couple of times over the past years for simple workflows, like sending an email (still not supported in ADF, booooo), reading a SharePoint List...
2025-09-17
168 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
160 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)
788 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
571 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
65 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)
219 reads
A New Word: Anderance
anderance – n. the awareness that your partner perceives the relationship from a totally different angle than you – spending years looking at a different face across the table,...
2025-09-12
506 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers