T-SQL Tuesday 61: A Season of Giving
Tis the season for TSQL Tuesday. Not only is it that season again, but it is also the Holiday season.
During...
2014-12-09
751 reads
Jason Brimhall
Murder in Charleston
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-12-08
805 reads
Murder in Charleston
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-12-08
5 reads
SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to stay in the Nation’s capitol for more than just...
2014-12-08
3 reads
SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to...
2014-12-08
548 reads
Audit Database File Size Changes
Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared...
2014-11-26
2,579 reads
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is...
2014-11-26
17 reads
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering of the community has just reached it’s 5th anniversary....
2014-11-11
3 reads
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering...
2014-11-11
580 reads
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has...
2014-11-07
624 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