To add, the service account for the SQL Server service must have rights to the mdf/ldf files.

To add on with Perry, the upgrade/recovery won't run until the database comes online, so you're stuck. This only really makes sense in an upgrade scenario.

You need to use replication...

I think it's either tSQLt or the MS Unit Testing Framework.

tSQLt is all in T-SQL, it's easier to write tests for db people, and it includes more scaffolding that's DB...

There are ODBC drivers for Linux. Not sure they work on the Rasberry Pi (should test), but the new v13 in preview is supposed to support more OSes.

No, SQL Compare does schema.

Data Compare does data, which is what jobs and packages are rows in the tables, but it doesn't work with system tables. Asking someone to see...

I'm still not quite sure what you mean with the language barrier, but maybe this helps.

A trigger is a stored procedure that runs when data in a table is modified....

I have never skiied in Utah. I planned last fall, but got jammed up with some family stuff and cut my trip short to get home. Still on my list...

The drop down remembers the last choice you made, so it is a binary on/off based on your last post.

g.britton (2/19/2016)

---

In our case, our VCS is in a different, untrusted domain from production servers. So, while the idea has some merit, we would likely not have any direct...

David.Poole (2/18/2016)

---

I've found that Google Authenticator is practical for authenticating onto AWS.

I wish I hadn't put a strong password on my phone. The number of times I've wanted to...

Thanks. We have someone looking at this as we did see some spam issues.

GilaMonster (2/22/2016)

---

Bandwidth. Latency.

My current...

TheFault (2/22/2016)

---

Gary Varga (2/22/2016)

---

Given that there are even cloud sandboxes for most things now it does beg the question why anyone would not use cloud hosts. There are issues that...

Grumpy DBA (2/22/2016)

---

Thanks to Steve (and those who agreed with him) on the book suggestion Ready Player One, I took it to Canyons-Park City and read it on the plane...

First, expensive. I've looked at them quite a bit. They...