Jason Brimhall


Blog Post

Feb 2011 S3OLV Meeting

I am getting this out extremely late.  I seriously have good excuses for that.  Due to my location and Charley feeling ill, we will be doing the S3OLV UG...

2011-02-09

2 reads

Blog Post

T-SQL Tuesday #15 DBA Automaton

Often, we hear about DBA's automating everything under the sun.  Why?  It simplifies the job and creates time to work on other projects.
Related Posts:

Automating like an Enterprise DBA January...

2011-02-09

7 reads

Blog Post

Immersions Training

The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills.  Later that week an announcement was made...

2011-02-08

4 reads

Blog Post

Immersion in Internals

Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas.  This is not...

2011-01-26

972 reads

Blogs

A Wellbeing Day at Redgate

By

It’s a day off for Redgate today. This is our annual wellbeing day, where...

Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!

By

Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...

What is ALM in Fabric?

By

As someone who’s worked with data for over 20 years and with many cloud...

Read the latest Blogs

Forums

A Quick Restore

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Restore

Guarding Against SQL Injection at the Database Layer (SQL Server)

By Terry Jago

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

By JSB_89

I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...

Visit the forum

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 REPLACE
What happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance.

See possible answers