SSWUG Fall 2010 Virtual Conference This Week
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a...
2010-10-18
562 reads
StrateSQL
4-Weeks to PASS Summit 2010 Countdown – Lunch
There are now 4 weeks until the PASS Summit and a few times now I’ve discussed ( 1, 2, 3 ) some...
2010-10-14
776 reads
Finding Missing Values from an Array
Missing NumbersToday a developer came up to me and wanted help solving a problem he was running into with a...
2010-10-13
1,056 reads
Return of Index Analysis Part 3
Let’s Anaylze An Index!Time for part three of my continued Index Analysis query. The previous posts in this series are:...
2010-10-13
972 reads
Index Black Ops Part 6 – Fill Factor vs. Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-11
3,682 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
891 reads
5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
730 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,096 reads
Return of Index Analysis Part 2
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-06
1,028 reads
SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
740 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...
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...
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