Does the password have to be NULL? Or can it be blank? Can you set the SQLCMDPASSWORD environment variable?

The docs definitely support that this should work. My guess is SQLCMD...

FWIW, the ODBC driver that will support Always Encrypted is in preview, not GA : https://msdn.microsoft.com/en-us/library/mt637351%28v=sql.110%29.aspx

As Erland mentioned, this is completely server side, so anyone with access to the server,...

Make sure you are backing up MSDB with new permissions, and you script out changes you make as these won't be in a new instance if you have a disaster.

I...

Maybe. What if someone adds it and deletes it and adds it back?

I can see users doing this.

Rod at work (6/13/2016)

---

I never really thought about who pays for a data breach. I assumed the company did, but your article Steve shows me its likely the insurance company...

Enjoy InsideSQL. I would love to come, but the timing doesn't work and I'm a bit traveled out.

There are systems that do this, like Sharepoint and some vendor applications. Almost completely they usually perform poorly and don't run well. Data gets duplicated or lost because there isn't...

Use a compare tool, like SQL Compare. These will let you see what's different between databases and generate a script you can run. SQL Compare can even be driven from...

Someone set the port to 1433 for the named instance?

How would you solve this on paper? If you explain what you'd do, or make an attempt, we are happy to help. However, as Eddie noted, we aren't looking to...

That's what you need to fix. You have an authentication failure with the mail server. You need to get the SMTP server config, and what type of authentication they...

Certainly in the past, no: https://blogs.msdn.microsoft.com/cindygross/2009/07/07/x64-windows-upgrade-from-32bit-sql-server-to-64bit-sql-server/

And not still: https://technet.microsoft.com/en-us/library/ms143393.aspx

This is cross platform.

The only thing I know to do here is

a) install a named instance. Backup and restore dbs.

b) script...

BTw, if you want to play with Mongo, Redgate invested in 3T, and you can use their tools to work with the db: http://3t.io/mongochef/

Brandie Tarvin (6/10/2016)

---

[

We're currently using a data warehouse for this. The ETL isn't too nasty, but it took us forever to figure out the best way for our different systems...

I realized I haven't upgraded any instances.

I've got a 2012 one handy I can upgrade, so once I get Dev edition down, I'll try it.