More Surface
I’m continuing to work with the Surface.
BOOM
I just had my first crash. I was in IE when I tried to...
2012-11-02
1,160 reads
The Scary DBA
Surface, Surface, Prepare to Surface
More stuff about the Surface.
Web browsing works extremely well so far. I enjoy how you can swipe to move back...
2012-11-01
802 reads
Microsoft Surface Update
Let’s talk some more about the basic keyboard. I’m really surprised at how well it works. But, it’s absolutely going...
2012-10-31
1,440 reads
Microsoft Surface
I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the...
2012-10-31 (first published: 2012-10-28)
3,271 reads
Scary Reading List for Halloween
I know I focus on community, SQL Server, professional development and process. But you need to do other stuff occasionally...
2012-10-26
730 reads
Clustered Indexes Have Statistics Too
It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index...
2012-10-22
1,160 reads
SQL In The City: Seattle
If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...
2012-10-17
1,144 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,466 reads
Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
2,997 reads
Interviewing a DBA
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...
2012-09-26 (first published: 2012-09-24)
3,350 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