Notes From The January 2012 OPASS Meeting
OPASS meetings are held at Logans Roadhouse in Sanford now, I think the fourth location over the past couple years,...
2013-01-21
696 reads
OPASS meetings are held at Logans Roadhouse in Sanford now, I think the fourth location over the past couple years,...
2013-01-21
696 reads
I’ve had the Nest Thermostat on my wish list for a while. It has looked like an interesting bit of...
2013-01-06
998 reads
I bet if you think about it there are lots of times when people ask what you think about a...
2013-01-05
856 reads
Last year I purchased two Kindle Fires for the family to use. The UI could be just a little bit/slow...
2012-12-31
1,524 reads
Looking back at 2012 I feel like I’ve written less than I planned to, and in some ways done less...
2012-12-31
1,463 reads
One of the simpler pleasures in life is having an idea and putting it up for discussion. Not all ideas...
2012-12-23
902 reads
I wanted to save this link to the Microsoft Support Lifecycle page and thought I’d share as well. It’s a...
2012-12-22
1,175 reads
Steve Jones sent me a link to this post about Intelligence vs Effort months ago, since then I’ve looked at...
2012-12-22
787 reads
Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.
2012-12-14 (first published: 2002-07-31)
10,688 reads
Last weekend I was in Tampa for SQLSaturday #168 and made sure to make some time for family. The most...
2012-11-26
909 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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