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

Bill Talada (8/1/2014)

---

Views might work for a small subset of DDL changes since views are rarely update-able when based on more than one table. How can you handle a...

I agree. You don't want to necessarily enable this by default.

That being said, I think you'd need to use dynamic SQL to build a script that would do this. I...

If someone is changing the encryption status, they're creating a lot of load to decrypt, and you'll create load to encrypt.

Don't automatically fix this. Catch it with monitoring (Check the...

Sean is correct in that you need some way of ordering things so that you know what table you are getting data from. Since you're trying to ensure all data...

My reminder is set.

Do we have a draft order?

Koen Verbeeck (8/11/2014)

---

GilaMonster (8/11/2014)

---

Maybe a throttle on posting new threads. A human can't post multiple threads in a...

First advice, don't chase the money. It will lead you to jobs that you might not otherwise like. The higher you go in salary/rate, the fewer jobs you have, and...