For PoSh, for sure. Not sure how complex, but it has piping and I know I can run PS locally to connect to Azure databases. I assume SSIS can.

In terms...

I did find this: http://blog.bugrapostaci.com/tag/latin1_general_ci_as_ks_ws/. That makes some sense, but I'm not sure why we wouldn't set the default for servers to be _KS_WS as well? It shouldn't matter in...

Ugh, you are right. I was checking a few random columns.

Sys.objects has the name in the default, but type in the other collation. That is crazy. I'll try to find...

Link should be fixed. Also here: http://events.doctorswithoutborders.org/index.cfm?fuseaction=donorDrive.personalCampaign&participantID=2216

You can use alerts (http://www.sqlservercentral.com/articles/alerts/89885/), though I'm not sure these are better than a job with a query in it. I think they'll both function similarly.

I am not sure if...

You have a few choices for copying specific tables.

1. Build an SSIS package to export those tables

2. Build a PoSh/bcp script to export those tables.

3. replicate those tables to a...

There's no switch for this in SQL Server. It's strictly administrative.

The only time this would come up is if you were audited. You'd just need to ensure you have the...

I tend to agree with Steve (sgmunson) here. Most of the responses are accurate, but annoying.

I agree this should be a setting in SSMS. Regardless of the technical aspects of...

Personally, I like the synonym approach since it's a layer of abstraction. If I needed to move to 3 tables, or implement partitioning, or anything else, I like having a...

Brandon J Williams (8/13/2014)

---

My point is that replication novices are quick to point the finger at replication when it's not replication that is the problem.

We actually haven't done much in...

Microsoft didn't do it that I can see. I've checked my US default 2008 and 2012 instances. Both of them have the objects at the same collation as the master...

Do you mean the service account password? Or your password for SQL Server?

The former needs to be done with Configuration Manager to ensure rights are maintained. Your password is like...

Robert.Sterbal (8/14/2014)

---

We have hundreds of thousands of you in the SQL Server community. ...

There are 1,742,404 logins on the site

is the ratio of logins to people closer to 10-1...

In case any of you missed it and want to ensure a picture gets posted to The Thread... http://www.sqlservercentral.com/articles/Editorial/114685/

Jason Shadonix (8/3/2014)

---

We use synonyms here and there, and have never had any issues with them "not working".

We use SPs over SQL code in our application whenever possible....