casachs 74147 (8/6/2015)

---

The problem with amateur data analysis is that the person doing the analysis doesn't necessarily have the full business or operational context necessary to do a full analysis...

Miles Neale (8/6/2015)

---

Thanks Steve, I have been working with both Power Pivot and another OpenData Portal Product that provides machine readable data to the public for our state. We...

DavidL (8/6/2015)

---

Data, visualizations, etc. as a field gained a lot of steam in the 70's when Semiology of Graphics: Diagrams, Networks, Maps was published -- it didn't get translated into...

Alvin Ramard (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack in interviews...

scoan (7/30/2015)

---

I can imagine us all using candid comments in our code. If we were to add a comment regarding authentication, and if that comment were to consider the...

https is on the list. I've asked for it, but that's out of my control.

Nothing has changed as far as requiring passwords in a new way. We still cookie a...

Edition decisions haven't been made. Until SQL Server 2016 gets closer to RTM, it's a complete guess as to what will be included and what will be outside of the...

Eric M Russell (8/4/2015)

---

Am I right in thinking that to connect to a typical SQL Azure instance, you would need both a proper SSL certificate and an accountname / password...

I'd do both, but I'd also try to determine which is important in your current environment. What does your workload do more often?

count the records in the PK, group on that.

use a having clause with the count() > 1

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack in interviews published? Not really as a cheat sheet,...

And as a side note, I didn't try this from memory, or fail to test it. I changed the names of my logical files on an instance here.

However. Where things...

Points awarded back and question corrected. My apologies for the error.

LOL, that's funny. Maybe one in the past. This question went in a...

Jack Corbett (7/31/2015)

---

Cadavre (7/31/2015)

---

Brandie Tarvin (7/30/2015)

---

Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing...