It sure would be grand to have interesting interviews
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
538 reads
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
538 reads
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
919 reads
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,144 reads
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
518 reads
Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We...
2013-10-09
535 reads
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on...
2013-09-30
1,257 reads
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,266 reads
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
521 reads
Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...
2013-09-19
696 reads
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
522 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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