Keep a Spare
I wanted to get working on Katmai a little, but not being brave and seeing the release notes that it...
2007-06-20
1,357 reads
Blog Posts
A Motivational Quote
Normally I don't post this sort of thing to my blog, trying to focus on more technical matters, but this...
2007-06-19
1,682 reads
GO More than Once?
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,371 reads
Gartner Developer Conference
It's been quite a week at the Gartner Application Development and Integration converence here in Nashville. I've never been to...
2007-06-13
2,003 reads
Mirrored Backups Posted on SSC
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,327 reads
Tampa Code Camp 2007
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,343 reads
June Midlands PASS Meeting Canceled
We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in...
2007-06-07
1,302 reads
Katmai Manageability
The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto...
2007-06-06
1,350 reads
Southern BBQ
Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and...
2007-06-06
1,391 reads
SQL Server 2005 Security
It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off...
2007-06-06
1,470 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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