I don't like this as if the rebuild and...

+1 here for me. I like the SQLFool script, but hear good things about MInion

One further note, if you're going to do this programmatically, and more than once, you'll get the same issue with filenames. Perhaps if you restore you want to have the...

One note I'll add, at the one company where we did this every month, it was self funded. The company didn't really contribute, and it was a good sized company...

chill8 (8/7/2015)

---

At Ford in the group I am currently in we don't do any team building since the team is of a global nature. So it makes it hard...

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