Play the T-SQL Alphabet Game
I recently had the opportunity to play the T-SQL Alphabet Game, which was introduced to me by SQL Server MVP,...
2009-01-21
1,253 reads
Blog Posts
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
686 reads
Conficker / Downadup Worm One More Time
Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...
2009-01-20
909 reads
Fake LinkedIn profiles with links to malware
This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...
2009-01-20
918 reads
Getting Information Where We Want It
I’ve been running every day, over 100 days in a row now, and one of the things that has helped...
2009-01-20
850 reads
Netbooks & Alternatives
A while back I mentioned that Radio Shack had an interesting promotion on a netbook and debated at what price...
2009-01-20
1,299 reads
Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've...
2009-01-20
1,137 reads
Kindle Review – How I Read
In the last 4 months of having the Kindle, I’ve gone through a few different ways of reading on it...
2009-01-19
959 reads
We Are Microsoft charity challenge
I got the opportunity to participate in the We Are Microsoft Charity Challenge (under the umbrella of GiveCamp) in Dallas...
2009-01-19
696 reads
Book Reviews - Worthwhile?
Lately I've been thinking (again) about books and book reviews, mostly because I'm looking to see if it makes sense...
2009-01-18
914 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