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 James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
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