T-SQL Tuesday #050 – Automation
In my developer life, my motto was ‘Automate all the things’ and since transitioning to a DBA role, my motto...
2014-01-14
622 reads
Jason Carter
T-SQL Tuesday #48 – Cloud Atlas
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will...
2013-11-12
544 reads
Second Presentation – Lessons Learned
Since my presentation at Orlando SQL Saturday seemed to go well (standing room only, all positive feedback) I submitted to...
2013-11-11
516 reads
Restore Script from Backup Directory – Modified
As a DBA your job is to protect the data, whether that be from corruption, attack, developers or any other...
2013-11-07
530 reads
First Presentation – Post Mortem
So it is done, it being my first presentation at a professional event. As you may recall, I recently presented...
2013-09-18
320 reads
SQL Saturday Orlando – My First Presentation!!!
I’ve submitted presentations before to CodeCamp and SQL Saturdays before, but have never been selected to present due to terrible...
2013-07-21
288 reads
Shifting of the Tides and my Career
Watching my career progression over the last year, an outside observer would think that I’m playing career path hop-scotch, or...
2013-06-15
543 reads
Time Based Power Settings
Just recently I was part of an online presentation in which the intended audience was unable to install any of...
2013-04-04
231 reads
Disk Space Checker
One method my company deploys our software is in a dedicated hosted environment. In this situation, we partner with a...
2013-03-28
1,167 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