Yes, we're all familiar with the deployment or upgrade that stole Christmas. That's why...

In fact, I might argue that apart from Hekaton, this wasn't necessarily worthy of a full release. PowerBI, BPE, the cardinality estimator changes, some Azure improvements and AlwaysOn changes, all...

Gary Varga (12/19/2014)

---

I think that this all leads to a two tier Internet. This is like the early days of the web where AOL (I think) users had a simplified...

Assuming we did have the technical framework in place to make someone globally "forgotten", what's to prevent the bad guys from abusing the system? This reminds me of that 1995...

In the aftermath of the Enron probe, NSA leak, and Sony hack, I'd suggest executives take their controversial shop talk offline to a bar or the golf course. I know...

paul.kemner (12/18/2014)

---

I just want to claim copyright on all my life data. Then if someone's using it without paying the price I set, I'll go all "RIAA" and seize their...

I'm in favor of scrubbing information that can be proven incorrect (ex: a news story originally got the name wrong) or data that is private without any public value (ex:...

If you have an application that routinely deletes records that were previously inserted, then it implies there is something wrong with the design. Deleting records in a relational database is...

Michael Meierruth (12/18/2014)

---

Eric M Russell (12/17/2014)

---

DonlSimpson (12/17/2014)

---

As a side note, on some RDMS platforms, various stubbed values are treated literally as NULL. For example, Oracle treats an empty string as...

DonlSimpson (12/17/2014)

---

spaghettidba (12/16/2014)

---

Use 0 if the value exists and it is 0.

Use NULL if the value does not exist or is undefined.

If you used 0 when NULL was more appropriate,...

Eirikur Eiriksson (12/16/2014)

---

Eric M Russell (12/16/2014)

---

Eirikur Eiriksson (12/16/2014)

...

There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is...

Eirikur Eiriksson (12/16/2014)

...

There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is not null, otherwise ignores it,...

For columns containing a foreign key enforced with a constraint, you have no choice but to not use NULL, because the primary key can't contain a NULL. Even if there...

Database developers, at least in my corner of the universe, typically save our stored procedures as scripts which get checked into source control and maintained for subsequent versions. However, when...

We have that in Visual Studio. Most of my T-SQL code changes are done in VS/TFS.