Be Cautious Offering Guidance
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,325 reads
The Scary DBA
Speaker of the Month, August 2013
I’m trying out a new blog post series, mostly for myself as an exercise. I’m going to pick one speaker...
2013-08-02
628 reads
Azure for Prototyping and Development
Psssttt!
Developers. Man, have I got something good for you.
Are your DBAs slowing down your development processes? Are they keeping you...
2013-07-29
1,742 reads
24 Hours of Education
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more...
2013-07-24
565 reads
A Tale of Two Hotels
This is a long and convoluted post about my experiences at two hotels, but it has a point for DBAs...
2013-07-15
830 reads
SQL in the City London 2013
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
728 reads
Getting Started With SQL Server 2014 the Easy Way
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,150 reads
I Don’t Care
It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...
2013-06-24
737 reads
Azure First
Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...
2013-06-20 (first published: 2013-06-17)
2,251 reads
Praise and a Suggestion for AlwaysOn
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are...
2013-06-10
817 reads
Blogs
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Black Box vs. Gray Box vs. White Box Testing
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Webinar Series – SQL Server Indexing
I’m starting a webinar series about SQL Server indexing with the fine folks of...
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