Travel for 2010
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 reads
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 reads
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
543 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
561 reads
I’ve written here and there about my attempts at time management and the idea that as you spin more and...
2009-09-21
602 reads
Just received a note from Dave Noderer that the 2010 South Fla Code Camp will be February 13th in Mirarmar,...
2009-09-21
530 reads
My friend Kevin had sent this to me after I wrote The Boss Is Always Right but before it was...
2009-09-20
701 reads
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-18
1,080 reads
Last week I posted Part 1 and Steve Jones gave some grief about not posting some pictures (rightfully so) of...
2009-09-17
835 reads
Bet you’re ready to disagree, right? I’ve had this on my list to write about for a while. One trend...
2009-09-17
1,355 reads
Simon is a prolific blogger, at rough look averaging 10-15 posts per month, and almost all of them are SQL,...
2009-09-16
792 reads
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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