SQL Search 1.0 Beta Available
Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you...
2010-01-28
1,414 reads
Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you...
2010-01-28
1,414 reads
Managing T-SQL source code has never been easy, and has often been the bane for many T-SQL developers. Later this...
2010-01-28
579 reads
The devLINK 2010 Technical Conference’s call for speakers is now open, and you can find information about speaking at the...
2010-01-25
497 reads
I have recently updated and revised my DBA Best Practices Checklist, which is hosted on www.Simple-Talk.com. The goal of the...
2010-01-22
809 reads
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
1,756 reads
This is a reprint of my editorial at SQLServerCentral.com. There is a lively discussion at the SSC forum on this...
2010-01-21
414 reads
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
645 reads
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
974 reads
I just heard that two of my presentations have been accepted for the European PASS Conference 2010 in Neuss, Germany,...
2010-01-21
688 reads
This past Tuesday, Microsoft officially announced that SQL Server 2008 R2 will be available in May 2010. See the announcement...
2010-01-21
671 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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