Jeff Moden (6/4/2015)

---

Shifting gears a bit...

Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a thing would...

Nothing is ever simple, and the queries that do this potentially slow way down with a check for banned users....

I tend to agree with Gail here. The data is stored in the mdf/ldf/ndf files. If someone stops the SQL Service, they can restore those files, just as they'd restore...

I like the use of the OUTPUT clause there. Much simpler than trying to build a transaction. It would also work with larger volumes if you changed the where clause...

I've seen some places like this with various models set up, but I don't see surveys there: http://www.databaseanswers.org/data_models/. There is a questionnaire, but it's limited in what it shows: http://www.databaseanswers.org/data_models/student_questionnaires/index.htm

What...

Couple things.

First, back up your certificate now. Even if you turn off TDE, it doesn't hurt to have a copy and someone might turn it on again.

Second, you might have...

there isn't a restore that has taken place, so either there's some storage change (possibly a restore of some sort) or a machine level change if you don't see anything...

The non-DBA's actions certainly could be an issue, but I'd hope that the person doing the auditing isn't a privileged user that can do something dangerous on the system. If...

First, I think you need to slow down and carefully post what happened and what you've seen. There are a few items that don't make sense. When you say database...

Thanks, Peter.

Apologies, Marty. I do try to spell out the acronyms most times, but didn't hear. VCS is Version Control System, also known as Source Control. I'll try to do...

A couple things. In terms of defaults, I think defaults work well, if we know they're defaults. That means that downstream systems and analysis need to know the user allowed...

three words too many 😀

I would like some. I'd like to have an article that focuses on a particular test, why it's written, what it catches, or has caught.

Multiple articles is fine. Using any...

You'd think it was still winter. Seems a bit of short-temperedness going around.

Please vent here and not in threads.

Is there just one? If there's a separate one for VS Online, pass it over.