Congrats

Jeff Moden (7/3/2016)

---

From what I've heard, it's because they don't...

You cannot attach the same database to two instances. You can attach two copies to different instances, but when you attach the database, the SQL Server service takes an exclusive...

There's a few articles on JSON here, including some pre-SQL 2016 - http://www.sqlservercentral.com/articles/SQLCLR/74160/

What do you mean by #4? Take a backup from each instance? There isn't a thing as an instance-database. If you want to take a backup from each instance, you...

Does this help: http://www.somacon.com/p586.php

Is there more code for the alert? That will track status, but not alert for disabled.

It is possible that a wrong password can lock an account, check the policy on...

Did you run the SQL Server install? Did you run the SSMS install?

Do you have a service called MSSQL running?

Jeff Moden (6/29/2016)

---

GilaMonster (6/29/2016)

---

Jeff Moden (6/28/2016)

---

Steve Jones - SSC Editor (6/28/2016)

---

Jeff Moden (6/25/2016)

---

While I agree that it probably has fewer bugs...

Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

Points awarded back.

My apologies.

manie (6/28/2016)

---

Steve, that there is my problem with Microsoft. If I develop an application...

Beatrix Kiddo (6/29/2016)

---

In the Venn diagram of the UK, all English people are British, but not all British people are English :-D. One of the best way to wind up...

Excellent

below86 (6/29/2016)

---

I had my SSC account tied to my work email, and the password was saved by IE. So when I lost my job and couldn't remember the password...

Definitely more complex, but has the advantage of not being dependent on tools in the future. It's got more places things could break, but they could also be recovered.

However, there's...