The Exceptional DBA’s Code of Conduct
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
729 reads
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
729 reads
"You can have everything in life that you want if you will just help enough other people get what they...
2009-12-08
738 reads
Starting Wednesday, December 9, 2009, I am on vacation until Monday, January 4th, 2010. Instead of traveling somewhere else for...
2009-12-08
401 reads
In case you haven’t discovered this for yourself, SQL Server Profiler is one of the most powerful tools that come...
2009-12-07
1,399 reads
Devenius Software is offering a free tool to help you manage SQL Server encryption keys. Its called the SQL Encryption...
2009-12-05
550 reads
2010 is beginning to look like a great year for SQLSaturday events this year. Already, there are nine planned, and...
2009-12-05
414 reads
While I have been working for Red Gate Software for nearly three years, it was only until this year that...
2009-12-05
754 reads
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen...
2009-11-30
1,450 reads
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
66 reads
Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of...
2009-11-26
1,437 reads
Next Monday, Marchg 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