Why Are Stored Procedures Too Hard?
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
513 reads
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,171 reads
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,360 reads
The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to...
2008-07-15
467 reads
I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went...
2008-07-14
1,004 reads
One of the things I use to identify how well a company is managed is by looking at how (well)...
2008-07-13
1,623 reads
My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately...
2008-07-13
1,403 reads
SQLSaturday #5 in Olympia is progressing nicely. Greg, Russ, and team have locked in a venue and with registration just...
2008-07-11
408 reads
I did quite a bit of reading during a recent week off including two biographies. One was Boyd: The Fighter...
2008-07-10
390 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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