Is antivirus in control of the firewall? I've seen cases where it is and unless you check advanced, it may appear off when it isn't.

No, cross-database ownership chaining is not enabled by default and you couldn't disable it. It used to be, until SQL Server 2000 SP3. After that, you must enable yourself. See...

I would wait until you see updated guidance from Microsoft indicating it's supported on the new OS. I know it won't work on Nano. Nano doesn't have all the required...

cyp901 (3/31/2016)

---

Depending on the size of active directory... This may not be the most efficient way to get the data, especially for group memberships. It has been a minute, but...

I would recommend against the Quest (now Dell cmdlets). They don't release memory very well and you can't force garbage collection on them. So while they are great for small...

Ed Wagner (3/28/2016)

---

ZZartin (3/28/2016)

---

Ed Wagner (3/28/2016)

---

Iwas Bornready (3/28/2016)

---

Steve Jones - SSC Editor (3/25/2016)

---

DBA_Rob (3/25/2016)

---

I can't think of a SQL Server environment where I didn't end up needing to turn on...

No. The CREATE DATABASE ENCRYPTION KEY command can only specify AES or Triple DES, both with are FIPS 140-2 compliant.

More here:

Instructions for using SQL Server 2008 in FIPS 140-2-compliant mode

Yes, sp_helprevlogin is the best way. It'll create two stored procedures in your master DB.

Filtering down the logins to extract and putting into a script is easy. Wrote about it...

More to Gail's point:

Page Life Expectancy isn’t what you think…[/url]

The most overlooked area: "soft skills."

- How clearly you can communicate.

- How well you work with others.

- How organized you are.

DBAs and system administrators generally get a bad rap for...

This depends greatly on your I/O and very much becomes a question of cost vs. performance. Do you have any kind of numbers around that?

According to the preliminary view of Books Online for SQL Server 2016, there is no indication that it has:

About Log Shipping (SQL Server)

Compare this with the article for Database Mirroring...