TSQL Tuesday – But I was Late
I was late to the game having discovered the Blog Post the day after entries were allowed. Despite that, I...
2010-01-14
835 reads
Jason Brimhall
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
640 reads
Professional Communications
This past week I had the opportunity to have lunch with a vendor at his clients’ site. As a part...
2010-01-10
519 reads
Goals For 2010
Like a lemming in the DBA community, I too am going to post my 2010 goals. I am looking to...
2010-01-08
466 reads
SSC Syndication
Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com. I will be syndicated there and...
2010-01-07
605 reads
Primary Key Discovery
As a part of my DB documentation process for a large database, I needed a method to quickly show me...
2010-01-05
705 reads
Users Group Participation
I have been pondering over my local PASS chapter and participation. And more specifically about why I should participate, and...
2010-01-04
992 reads
2009-12-21
5,099 reads
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Forums
Restoring On Top II
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)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
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) GOToday, 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 REPLACEWhat happens? See possible answers