TheFault (6/15/2016)

---

Having worked at a company who are supposed 'industry experts' in data security, I can tell you it is no better behind closed doors at such places. PCI audits...

I'd go with the ADO.NET driver and SSIS, personally. Haven't done it, but if you're just moving data, this is fairly straightforward. Even the programming part isn't bad. I would...

My vote is never, never combine the drives unless this is a LUN from some storage system. You can have multiple files in one filegroup or multiple filegroups, but manage...

Meet 3-5 new people. Just say hi, introduce yourself and ask what they do. Or why they're there. Spend 3-5 minutes getting to know them. More if you want, excuse...

Yes and...

Yep, click the discuss link on the main page for the question. Or check the author's forum.

No need to answer to discuss. I rarely answer 🙂

Ichiro closing on Rose' record: http://espn.go.com/mlb/story/_/id/16198037/pete-rose-counting-ichiro-suzuki-japan-hits-record

For the record, I don't think he's the MLB hit leader, but maybe the world baseball hit leader for sure. He's been amazing. 1200 in...

From MS:

Use -P "", double quotes, which should work. I'm guessing this might work for SQLCMDPASSWORD as well.

If not, can you use isql/osql instead?

No idea. I'm not even sure how to set a password to NULL. I can set it to blank, but not NULL, at least not that I see in 2014/2016.

If...

That won't scale well, as you'll end up with wide tables as the clients grow, where many of the columns are null.

The other way to do this is customize the...

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.