Defensive Database Programming Chapter 01
Today I am finally getting around to the review of the first chapter as promised. I talked about the book...
2010-06-07
799 reads
Today I am finally getting around to the review of the first chapter as promised. I talked about the book...
2010-06-07
799 reads
The S3OLV monthly meeting is being held this Thursday. We will be meeting at the same location and time as...
2010-06-07
488 reads
Have you ever been required to update your SQL Server environment and needed to test it? I know, rhetorical question....
2010-06-04
662 reads
At long last I am bringing the next installment in this mini-series. You can find the rest of the articles...
2010-05-25
1,430 reads
Last week I posted an article about plagiarism. This is a follow-up to that. After posting that blog article, Steiner...
2010-05-24
938 reads
Recently I received a new opportunity via email. Steve Jones at SQLServerCentral sent me an email to see if I...
2010-05-21
649 reads
A new article for the SQL Standard is now available. You can find the article here. The article is by...
2010-05-20
605 reads
Today I ran into an interesting website. While I was trying to locate information concerning a SQL Saturday event, I...
2010-05-20
536 reads
Today I ran into an interesting website. While I was trying to locate information concerning a SQL Saturday event, I...
2010-05-20
715 reads
The last post in the series on finding the sizes of your tables showed us how we could find that...
2010-05-19
1,434 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
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...
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