philcart (2/23/2016)

---

We've been hit with CryptoLocker 5-6 times already. Each time it's been a network share in one of the branch offices that's been affected.

The Infrastructure guys here have become...

If you have collation conflicts, then add a collation statement to the queries to resolve things. That's better than wrapping queries in this try..catch.

Here's an example: http://www.sqlservercentral.com/articles/Administration/collate_part1/875/

Can the table be changed on any node, or is there a master table that controls writes?

It's easier if there is a master, but you can implement Peer to Peer...

There would be a table for grades. ZZMartin provided an example.

The idea here is to not get locked into changing tables constantly. You should have a table for the subject,...

As Jamie wrote. Have a specific, curated set of data. Know the opening state, make the change, query for the end state, which you should know.

To do this right, you...

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...