Getting Started with Technical Presentations
I was talking with a gentleman last night after the Greater Charleston .NET User Group about career development. He's not...
2009-04-17
787 reads
I was talking with a gentleman last night after the Greater Charleston .NET User Group about career development. He's not...
2009-04-17
787 reads
I went to pay for the Prius this morning; it’s finally done!
Front seatbelts (2) - $412
Rear seatbelts (2) - $260
Front door...
2009-04-17
774 reads
Sure that many informations that we can have from the SQL Server 2008, are organized in system views in each...
2009-04-17
910 reads
I’ve been managing backups of my video files using USB hard drives for a year, and I’m fed up. I...
2009-04-16
941 reads
If you've never looked at one of these they are compilations of some of the best/most popular articles since the...
2009-04-16
535 reads
The event schedule for SQL Saturday Pensacola has been published. This event will be held on Saturday, June 6 at...
2009-04-16
792 reads
In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to...
2009-04-16
5,580 reads
Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review,...
2009-04-15
2,424 reads
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
582 reads
I just had a call with John Baldwin who is leading the effort in Birmingham and there plenty of action...
2009-04-15
303 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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