Duration & rows returned are in rpc_completed and/or sql_batch_completed Extended Events. That's how I'd capture this data if required. To my knowledge, you're correct, this is absolutely not in the...

Break it all down into pieces for testing. The easy part is the database name of course. But, next, test that you're capturing only statements with ALTER in them. See...

If you do a large scale data purge, you may also see a very empty database file.

Shrinking a file is not the end of the world. If you have, let's...

A timeout is caused when resources are unavailable, causing excessive waits. So, something is going south there. You've narrowed it down to the EMC backup solution running. What do the...

Not sure I agree here. There is a lot of paperwork, and both your agent and the lender ought to be walking you through these items. There are checklists...

Spin up containers. Easier, faster. Or, a VM on Azure. Again, easier & faster. Especially just for testing stuff out.

Database or not, listen to me, listen to Jeff, listen to both of us, you should be able to access a file system and retrieve these objects for display without...

X,

You're not wrong. It's not the choices I would make, but the way you've laid it out, they're not bad choices.Others may not agree, but I'd say that others can...

Just noticed this.

Minor nit.

I'm all about clarity. The more the better. So, with that in mind, naming two different columns in two different tables, ID, especially when we're going to...

Is it only consisting of pdf, images, videos? If so, a relational database would be a poor choice.You might want to look to some other kinds of data storage that...

I'm weird as a DBA. I'm all in on new stuff. I love Entity Framework and other ORM tools. I'm good with semi-structured and unstructured data management systems. I love...

Oh boy.

Are there strong opinions on natural keys versus artificial keys?

Yes.

You may get some very strongly worded responses to this question, depending on who sees it and how they respond....

• This reply was modified 6 years, 10 months ago by Grant Fritchey. Reason: typo

Let's, just for a minute, assume that the use of WITH(NOLOCK) was ok to do.  It's stupid to mark every single table with the hint especially if you ever...

Honestly, this sounds like the DBA job of the future. The easily automated stuff, server allocation, SQL Server installs, backups, consistency checks, all these things, should be already automated. The...

PIRATE!!!!

Except Alice says no.