Did some research on a test instance and got it right.

Interesting question.

I sat up...

I like NULL as the deault choice. All other values have a tendency to create confusion at some point in the future in my experience. Most people have a good...

Good question early in the morning. Had to do some math to get the brain going.

I was not aware of this. You are right.

There's an article on the MSDN blog about tracking...

You can check the status of your restore operation with the dynamic managment view sys.dm_exec_requests

To view only RESTORE/BACKUP operations you can include a where clause:

SELECT *

FROM sys.dm_exec_requests

WHERE command In (...

Good question.

I have installed three new SQL Server 2016 instances this week, so this question was quick and easy to answer.

Eric M Russell (6/21/2016)

---

However, the best way to serve your community, your country, and humanity in general is simply to live life with integrity. Put in an honest days work,...

Mark Dalley (6/20/2016)

---

The boss of a friend of mine (not in IT) said once: "You are allowed to drive into a ditch, provided you come out again undamaged."

Well, maybe. I...

Even if your database is in simple recovery mode it still has a log file. This error message indicates that this log file is missing or corrupted. If data and...

It's surely good to have such a fine level of granularity to tune users access rights. Even though we don't have any use cases for such fine-tuning atm, I can...

We use a text messaging service which is totally disconnected from our IT infrastructure to communicate with our organization during different types of outages.