Damian is Microsoft MVP and Certified Trainer with 20 years of experience. Now trying to share the passion and knowledge among others. He runs the blog with his daughter as she is really passionate about technology

Coffee poured into a mug

Weekly reading #30

Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...

2019-11-11

41 reads

Weekly reading #30

Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...

2019-11-11

11 reads

Image

Interview with Bob Ward

This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...

2019-10-30 (first published: )

375 reads

Coffee and Granules

Weekly reading #29

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...

2019-10-21

26 reads

Weekly reading #29

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...

2019-10-21

8 reads

Joe Picture

Interview with Joe Sack

This is the seventh interview we have done. This time our guest is Joe Sack! Joe is Principal Program Manager for Azure SQL Database with a focus on query...

2019-10-11 (first published: )

314 reads

Coffee

Weekly reading #28

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

2019-10-10

32 reads

Blogs

From Planning to Practice: Setting Up Your FinOps Framework

By

As someone who works in DevOps, I’m always focused on creating systems that are...

“We love to debate minutiae”

By

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

By

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Read the latest Blogs

Forums

Restoring On Top II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring On Top II

SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)

By Terry Jago

Comments posted to this topic are about the item SQL Art 2: St Patrick’s...

Breaking Down Your Work

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Breaking Down Your Work

Visit the forum

Question of the Day

Restoring On Top II

I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:

-- run yesterday
CREATE DATABASE DNRTest2
GO
USE DNRTest2
GO
CREATE TABLE NewTable (id INT)
GO
Today, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today
USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO
RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACE
What happens?

See possible answers