Ed

Ed Leighton-Dick is a SQL Server performance and architecture expert and Founder/Principal Consultant of Kingfisher Technologies, a consultancy focused on SQL Server performance, architecture, and security. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQL Saturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQL Saturday events, and Iowa Code Camp. Ed can be reached through his blog, edleightondick.com, and on Twitter at @eleightondick.

Blog Post

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they...

2018-07-10

216 reads

Blog Post

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...

2018-07-10

17 reads

Blog Post

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...

2018-07-10

6 reads

Blog Post

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...

2018-07-10

4 reads

Blog Post

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...

2018-07-10

5 reads

Blog Post

10 Years Young

It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the...

2018-06-12

299 reads

Blog Post

10 Years Young

It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...

2018-06-12

10 reads

Blog Post

10 Years Young

It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...

2018-06-12

5 reads

Blog Post

10 Years Young

It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...

2018-06-12

4 reads

Blog Post

10 Years Young

It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...

2018-06-12

3 reads

Blogs

Tooling for Success: The Best FinOps Tools and Technologies

By

As a DevOps person, I know that to make FinOps successful, you need more...

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...

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