Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've had a good discussions about networking since I wrote the first two parts, with a focus on the value of networking.
2009-01-23
1,698 reads
Had a bit of an oddity show up during some testing today when trying to disable log shipping on the primary server using SSMS. My test scenario was such that our secondary server was not available any longer (had been renamed) and when I tried to disable the log shipping...
2009-01-22
1,294 reads
I originally wrote this in French while working at LaCaisse.com "Why do you care, as a DBA (or a developer for that matter), about what is happening in the transaction...
2009-01-21
1,896 reads
We all have those things that happen at work that somehow turn into something other than expected, and sometimes in quite humorous fashion. I've got a few to share over the next couple months, but had to start with this one!
2009-01-19
160 reads
I didn't want to go on this trip, but I agreed to do it. Now I regret it. My flight to Chicago was fairly uneventful, but it was running late. At 4:30CST the pilot says we should be on the ground in 30 minutes, which is good since I have to get to...
2009-01-19
198 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers