David.Poole (6/28/2016)

---

The big challenge with statistics is in communicating what the results actually mean. Understanding that point 51.9 vs 48.1 has no significance in a small sample but becomes...

trboyden (6/20/2016)

---

I wouldn't call it a SQL Server issue. SQL Server expects the date to be passed in as "2016-06-20 00:00:00" which is the standard SQL Server datetime format. So...

Kyrilluk (5/26/2016)

---

Good article.

It reminds me that for a very long time, I wasn't that interested in SQL dev, Business Intelligence, etc. I had a very expensive and demanding hobby...

I am really following you here, Steve. I deem an instance/database/task "important" if smelly things slide my way if it doesn't work as expected.

I wish I had time to test...

manie (4/18/2016)

---

roger.plowman (4/18/2016)

---

Personally, I use three triggers on *almost every single table*--BUT 😀

I only use them to create an audit log of insertions, deletions, updates and updates where I have...

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store credentials in plaintext in the...

The same... The answers given...

+1

Nice question. And thanks for the example of "beware of the defaults", because to the naked eye #4 and #5 doesn't look to yield different results. But they do..

Like... what?? If you don't present your case and argue why you think so, then why bother writing a...

Stuart Davies (11/12/2014)

---

It was sparked by new dev here, who couldn't see the difference between any of the four possible answers :w00t:

As the question and answer showed mixed cases, case...

Mark Grout (11/12/2014)

---

The question said "every employee", that should be clear enough, one record per employee. If you DISTINCT, you get list of peoples names, not people.

"There's Brian over there,...

Nice post, Steve 🙂

However, you wrote another editorial on August 19th, 2014, named "Artist or Scientist", which I really took to my heart!

May I quote my favorite part?:

While we need...

"Managers: who needs them?"

I must say, I find the topic slightly provocative. I believe the generic message in the editorial can be said about almost any role people don't understand...

Ed Wagner (10/22/2014)

---

Toreador (10/22/2014)

---

Sean Lange (10/21/2014)

---

A cte does NOT require it to start with a semicolon. The semicolon is statement terminator not a statement beginninator (nod to Lynn Pettis for...

In general, I am in tune with you on this one. But a stray thought came to me right away:

Maybe it take considerable skill to imagine a system correctly?

That is:...