OFF-TOPIC: God is Still Good, Even as We Mourn
Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly...
2009-10-30
1,918 reads
Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly...
2009-10-30
1,918 reads
Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....
2009-10-29
890 reads
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,671 reads
It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...
2009-10-27
6,140 reads
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,870 reads
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,666 reads
I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's...
2009-10-22
925 reads
SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.
2009-10-21
5,948 reads
Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than...
2009-10-19
2,249 reads
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,358 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