Steve Jones - SSC Editor (11/30/2016)

---

Eric M Russell (11/30/2016)

---

I totally don't understand why someone would publish sample programming code on the public web and then expect other folks not to...

Years ago, Adam Machanic developed a load testing tool for running either batches of T-SQL statements or stored procedure calls.

http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx

https://www.brentozar.com/archive/2015/05/how-to-fake-load-tests-with-sqlquerystress/

Also, you can leverage the WAITFOR command to execute a T-SQL...

I totally don't understand why someone would publish sample programming code on the public web and then expect other folks not to use it or even expect folks to ask...

mjh 45389 (11/30/2016)

---

Eric M Russell (11/30/2016)

---

If we eliminate cows as a source for green-house gas emissions then next up will be human produced gas emissions... particularly that of west coast...

First, not everyone has a SSN, and another problem is that it's not verifiable. How do I know that John Smith's SSN is 111-22-3333?

If you identify someone by their email...

David.Poole (11/30/2016)

---

What I'd like to see is a framework to support whistle blowers.

By all means insist on evidence but whistle blowers need protection. Most companies have a whistle blower...

If we eliminate cows as a source for green-house gas emissions then next up will be human produced gas emissions... particularly that of west coast vegetarians.

Will Vegetarian Humans...

Whatever user requested to see the data pivoted into this cross-tab format should do it themselves within the reporting tool.

Create a Matrix (Report Builder and SSRS)

https://msdn.microsoft.com/en-us/library/dd207149.aspx

Office Excel 2010 Tutorial: Pivot...

What you've described is a terrible application for a traditional Row-Store / B-tree indexed table, but a ColumnStore index can help mitigate this type of dynamic access pattern. If this...

I often use a datetime stamp as the leading column in a clustered and/or primary key. Many types of entities are naturally unique within the context of time, and also...

Brad Allison (11/30/2016)

---

This topic is very timely and interesting as just yesterday I heard that the Breitbart company now wants to capitalize on working with data within the White House...

David.Poole (11/28/2016)

---

What puzzles me is that developers aren't much better at data modelling. Surely you have to be pretty good to come up with a decent object model in...

I'm thinking that Thanksgiving is a British holiday inherited by the US, since Jamestown and Plymouth were British colonies at the time the first Thanksgiving was celebrated.

One day we'll have a device that can scan a person's DNA and produce a unique and repeatable 16 byte hash code. No name, social security number, date of birth,...

web designers building databases...

interns defining business requirements...

database administrators interfacing with clients...

executive management playing golf ...

everybody supervising themselves...