The Exceptional DBA for 2011
Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last...
2011-05-25
916 reads
Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last...
2011-05-25
916 reads
Hi, All. Just some thoughts on a passing scene. Didn't expect to blog today. Many projects in the queue, but...
2011-05-25
1,307 reads
Earlier this year, I had started off with a bang. I think I had 51 posts in January with a...
2011-05-25
558 reads
Wednesday I will be presenting for the PASS BI/DW group a session on Data Mining in Excel. This is a...
2011-05-24
1,194 reads
Thank you to everyone reading this site - Please enjoy your stay!
HelpWithSQL has hit double digits in posts! I hope everyone...
2011-05-24
616 reads
Another great event coming to NYC this Thursday, May 26, 2011 @ 6PM! The NYC SQL Server User Group presents a...
2011-05-24
1,232 reads
I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr...
2011-05-24
924 reads
I’m working my whole professional work life (around 11 years) with SQL Server, and
have see so many pitfalls in configuration...
2011-05-24
1,625 reads
Prayer Cat Prays
Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll...
2011-05-24
554 reads
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,434 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