DBA in Space: Behind the Scenes—Questions 2 & 3
Part 1 of Question 2—The question.Part 2 of Question 2—The follow up to the question.This is a continuation of my...
2011-11-21
643 reads
Part 1 of Question 2—The question.Part 2 of Question 2—The follow up to the question.This is a continuation of my...
2011-11-21
643 reads
This is a continuation of my DBA in Space journal.
In the opening of the first episode of DBA in Space,...
2011-11-18
633 reads
This is a continuation of my DBA in Space journal.
In this next series of blog posts, I am going to...
2011-11-17
683 reads
This is a continuation of my DBA in Space journal.
Friday, September 16, 2011
OMG. (This is the first time in my...
2011-11-16
613 reads
This is a continuation of my DBA in Space journal.
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...
2011-11-15
557 reads
The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.
Filming DBA in...
2011-11-14
727 reads
In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it...
2011-11-14
792 reads
(I’m ‘standing in for Brad, who is busy ..er.. somewhere, and I found this unpublished piece by Brad and I....
2011-11-03
1,418 reads
Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is...
2011-11-01
500 reads
Today we have a guest post from Steve Jones.
I survived SQL in the City in LA, and thanks to everyone...
2011-10-31
1,554 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,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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