Introducing Managed Backups in SQL Server 2014
Some of the new functionality of 2014 is straight forward, non-controversial and easily welcomed by the community. Think, updateable column...
2013-12-17
2,347 reads
The Scary DBA
SQL Server 2014 Backup to URL
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....
2013-12-11
1,719 reads
Speaker of the Month, December 2013
This will be my fifth speaker of the month post. Do a search to see the others.
I try to find...
2013-12-06
619 reads
Windows Azure Views
It’s kind of fun to see Azure development artifacts on display. I’ve posted about them before, a couple of times....
2013-11-19
875 reads
Cargo Cult Data Professionals
Ever since David Moutray introduced me to the concept of cargo cult programming, it’s been running round and round in...
2013-11-12
978 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,483 reads
More Azure Goodies
Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new...
2013-11-12 (first published: 2013-11-05)
1,781 reads
Speaker of the Month, November 2013
Yeah, I’m a couple of days late. Tough. My blog. My rules.
Speaking of rules. Speaker of the Month is chosen...
2013-11-04
652 reads
Query Tuning in Dallas
Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...
2013-10-29
675 reads
SQL in the City, US Tour 2013, Recap
Red Gate visited three cities this year with our SQL in the City event; Pasadena, Atlanta and Charlotte. I just...
2013-10-22
837 reads
Blogs
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...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
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