Notes on the Jacksonville Code Camp 2009
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
I'll define a brown bag lunch as a training event held at lunch time where someone on the team does...
2008-09-08
1,100 reads
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
357 reads
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
295 reads
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,110 reads
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
295 reads
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
398 reads
Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.
2008-09-02
9,701 reads
When I teach my introductory (and free) Successful Technical Speaking class to try to help beginners enter the world of speaking,...
2008-09-01
407 reads
It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to...
2008-08-31
1,773 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