I'm not sure what you mean by given constraints limitation.

If you want to change add a column to a table that is based on an FK to some new table,...

Sean Lange (6/14/2016)

---

TomThomson (6/14/2016)

---

Interesting question.

Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work across instances and(ii) resource govenor...

Moving to SQL 2016 Admin.

Haven't seen this or seen a report. What does the setup log note?

There are lots of scripts here on the site that manage deleting old backups. I'd look through one of them and modify: http://www.sqlservercentral.com/search/?q=delete+old+backup&t=s&sort=relevance

As Kevin said, other languages do this better....

Does this help: http://www.sqlservercentral.com/Forums/Topic1182295-391-1.aspx

Usually SSPI has to do with the service account on the server not connecting to AD correctly.

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