September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
4 reads
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
4 reads
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group. We have had to...
2012-07-30
5 reads
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las...
2012-07-30
1,595 reads
You may or may not have noticed that over the past several months I have been somewhat absent from my...
2012-07-18
941 reads
You may or may not have noticed that over the past several months I have been somewhat absent from my blog. Very few articles if any have been produced....
2012-07-18
4 reads
When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more painful (maybe even demoralizing) with the larger the number...
2012-07-17
9 reads
When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more...
2012-07-17
1,552 reads
When was the last time you had to find something within your database? Did it feel more like a child’s...
2012-07-11
1,280 reads
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say...
2012-07-11
12 reads
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2012-07-02 (first published: 2012-06-25)
4,484 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,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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...
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