AFAIK, the lowest windows version supported by 2016 is above the highest version supported by 2005, so... as was said before... not supported.

In-place upgrades with no other changes, same hardware, same...

Eric M Russell (8/2/2016)

---

Nadrek (8/1/2016)

---

Eric M Russell (8/1/2016)

---

2016 can potentially be several orders of magnitude faster than 2008, if you also want to invest in re-architecting your database to leverage...

Eric M Russell (8/1/2016)

---

2016 can potentially be several orders of magnitude faster than 2008, if you also want to invest in re-architecting your database to leverage things like Clustered ColumnStore,...

Documentation will not tell you if SQL 2016 will be faster, in your particular environment, with your particular queries, with or without additional work.

Documentation will tell you that you can...

I would count this as a very important release - the In-Memory/Hekaton tables can finally have foreign keys (even if they must reference a primary key), which takes them from...

As always, please be sure to know your requirements, and whether your particular calculation considers a Leap Day (Feb 29 birthdate) baby to have their birthday on Feb 28, or...

Personally, I either convert from DATETIME to DATE (reduce storage, and to the day is actually MORE accurate per the business requirements), to DATETIME2(2) (reduce storage to 6 bytes with...

Ed Wagner (12/23/2015)

---

Another important point about it is that it's a well-known SQL login with sysadmin privs. If an attacker knows a login, they can use it in an...

One way to use the "SA" account is as a last ditch fallback account.

Assign it a large, truly random password, known by the DBA's, and then only use it for...

GilaMonster (11/23/2015)

---

Not touching that with a bargepole (and please can you edit your post in case someone tries to run whatever that is?)

Wipe that machine and get your IT security...

No less than 18 years old, including some no-longer-used stored procedures that could only have worked on SQL Server 7.0 or earlier.

Personally, I prefer to treat "short-term bandaid" solutions as...

Very fuzzily!

Craig Mullins is probably the genesis of my use of the term, though my use is not at all the...

I checked "Other" for the systems design part - network, encryption, hardware, storage, etc. design.

Beyond that, like it seems most of us, I checked a few - I assumed Development...

Maddave (6/22/2015)

---

I've used the Sql compliance manager from Idera at the last company I worked for. https://www.idera.com/productssolutions/sqlserver/sqlcompliancemanager

...

It's not a flawless solution as a domain admin could in theory...