drsql@hotmail.com


SQLServerCentral Editorial

A rose by any other name would not be a rose

William Shakespeare once wrote in the play Romeo and Juliet: “What's in a name? That which we call a rose, by any other word would smell as sweet.” It is a beautiful sentiment in that context, and even still you might say that there is some truth to this saying in a lot of ways.  […]

You rated this post out of 5. Change rating

2023-11-04

1,643 reads

SQLServerCentral Editorial

Confidence

Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately […]

(1)

You rated this post out of 5. Change rating

2023-10-07

85 reads

SQLServerCentral Editorial

What Counts For a DBA: Manners

When most people were young, they had someone telling them to "Mind your manners." Such classics as: "Keep your elbows off of the table," "Use a fork," "Put on deodorant," as well as "Don't chew with your mouth open" were bandied about like there were laws of nature. However, manners differ significantly from laws in […]

(2)

You rated this post out of 5. Change rating

2023-08-12

138 reads

SQLServerCentral Editorial

Keep your Resume Reasonable

The other day, I was in a Twitter discussion interviewing people for technical positions. This reminded me of one of my favorite things to do in interviews… reading the list of qualifications/skills and asking questions about its contents. If you put it on the resume, I assume you know something about it and are willing […]

You rated this post out of 5. Change rating

2023-07-15

138 reads

SQLServerCentral Editorial

Software Flexibility (Avoiding the next hack)

As computer scientists, it often feels like our job is to tell the business user, "No, we can't do that because the software you asked for, and we built, doesn't allow it ..." Then, after a long and relatively silly meeting where your soul dies a little, the business user typically gets 80% of what […]

(2)

You rated this post out of 5. Change rating

2023-06-10

103 reads

SQLServerCentral Editorial

Empathetic Design

An old sport saying goes like this “I could beat them with one arm tied behind my back.” Well, after six weeks with my arm in a sling, I am in awe of whoever tries that because everything is a lot harder. Like washing your hand and then drying it, becomes more of a challenge […]

(1)

You rated this post out of 5. Change rating

2023-05-20

101 reads

SQLServerCentral Editorial

Review Early and Often

Several years ago, I was brought in on a project to review a database design. I was provided a time for a meeting. No written requirements were available, but I generally knew what the system was supposed to do. No before/after schema images showed what was being changed were available. Still, I was assured that […]

(4)

You rated this post out of 5. Change rating

2023-03-25

108 reads

SQLServerCentral Editorial

Consider Sharing Your Knowledge At User Groups and Conferences

The first time I spoke in front of a group of people over 20 years ago about a programming topic, I was scared to death. I could barely sleep the night before, obsessing about the material and practicing it repeatedly. When I finally did sleep, it felt like minutes before I awoke, and it was […]

You rated this post out of 5. Change rating

2023-02-25

83 reads

SQLServerCentral Editorial

Fear of "What If"

Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly […]

(2)

You rated this post out of 5. Change rating

2023-02-06 (first published: )

226 reads

SQLServerCentral Editorial

What Counts for a DBA: Skill

Practice makes perfect:” right? Well, not exactly. The reality of it all is that this saying is an untrustworthy aphorism. I discovered this in my “younger” days when I was a passionate tennis player, practicing and playing 20+ hours a week. No matter what my passion level was, without some serious coaching (and perhaps a […]

(1)

You rated this post out of 5. Change rating

2021-08-14

249 reads

Blogs

Building the Team: Roles and Responsibilities in FinOps

By

In my experience, FinOps success has never been just about tools or dashboards. It...

Tooling for Success: The Best FinOps Tools and Technologies

By

As a DevOps person, I know that to make FinOps successful, you need more...

From Planning to Practice: Setting Up Your FinOps Framework

By

As someone who works in DevOps, I’m always focused on creating systems that are...

Read the latest Blogs

Forums

Restoring On Top II

By Steve Jones - SSC Editor

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)

By Terry Jago

Comments posted to this topic are about the item SQL Art 2: St Patrick’s...

Breaking Down Your Work

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Breaking Down Your Work

Visit the forum

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)
GO
Today, 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 REPLACE
What happens?

See possible answers