I use SQLQueryStress too, have always found it useful to run a simple load test to reveal issues. Getting the workload right in terms of parameters is the hard part.

Nice article. Eye opening for me as I always do US centric work and first/middle/last is the common pattern (in names and in the db). Correct spelling of names is...

Good intro, I learned some stuff!

The lack of header support, or the ability to store/relate stronger meta data seems like a serious weakness. I'm thinking about a lake with 1000's...

I wonder if being considered a spy make just be the right way to go! What do you do? Ah, well, I can't really talk about it.

Years ago I stopped in to see my boss, just taking a break really. He was about to leave and invited me to join him at a meeting with the...

Gary, the interesting part for me is that people ask a developer "what are you working on?" and they ask me "what do you do?". Both are about getting to...

Apologies on that!

Tried rebuilding the clustered index? I wonder if you're hitting a limit due to previous table/column changes.

I was just thinking this would make a pretty good TV type game show. QOTD Olympics? QOTD Survivor? Hard enough without time pressure:-)

Glad you all enjoyed the question. I like to mix it up now and then on the complexity scale, and yes, some of the answers were fairly comical:-)

I think there...

Magnus, I'll send a note to have the question updated about ESCAPE_SQUOTE. Can't believe I missed that.

Nicely written Phil!

I remind new consultants/employees that there is typically an urge to "do something" fast to prove worthiness. Gathering knowledge is "doing something". Better to take some time, understand...

Learning, then a pause, then revisiting has been a common pattern for me (though I hadn't thought about it until you wrote the editorial!). Maybe it's two patterns. One is...

Hugo, is there really a difference? In both cases its clearly something unusual being done and I'd argue in both cases a "why" comment would be appropriate.

Lynn, it by Plugable, see http://www.amazon.com/Plugable-UD-3900-Universal-Docking-Ethernet/dp/B00ECDM78E/ref=sr_1_1?ie=UTF8&qid=1460034655&sr=8-1&keywords=plugable+usb+3.0+dock. About $90. I'm using their two port USB switch in front of it, kinda KVM'ish.

Seems to work fine. Only issue I have now...