Quite the title, so let me set the stage first. You have an Azure Data Factory instance (or Azure Synapse Pipelines) and you have a couple of linked services...
2026-03-04 (first published: 2026-03-03)
61 reads
We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode...
2026-03-04 (first published: 2026-02-23)
26 reads
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll see companies like OpenAI, Anthropic, Gemini, Lovable, and Poolside AI dominating the conversation. Different names,...
2026-03-03 (first published: 2026-03-02)
19 reads
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may not know the history, T-SQL Tuesday started back in December 2009 when Adam Machanic (Blog |LinkedIn)...
2026-03-03
9 reads
It’s a day off for Redgate today. This is our annual wellbeing day, where everyone gets the day off. Well, not everyone, but anyone that has to work today...
2026-03-02
9 reads
I just need a few hours of your time… We get a variation of this request a LOT. So now it’s time to do something about it! Ad Hoc...
2026-03-02
10 reads
continuing from Day 1 where we covered the history of AI and GPT family, today on Day 2 i would like to discuss what came next after Generative AI...
2026-03-02
12 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed: AI, Performance & Beyond will take place! This hands-on training is designed to help DBAs,...
2026-03-02
18 reads
I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way....
2026-03-02 (first published: 2026-02-18)
425 reads
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-02
1 reads
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers