Sean Redmond (12/17/2015)

---

It is the over-compartmentalisation that does it. I was a year into a job as a DBA and I had gotten a grip on what was to be...

It's all very well to say you should keep up with changing SQL Server stuff, but the reality for many of us is our companies either refuse to replace a...

The editorial mentions revoking and reissuing keys for TDE.

To my knowledge that isn't possible. It's not like message exchange, when you encrypt the whole disk you're talking about gigabytes...

Programmers in general (and developers especially) are NOT "software engineers". We are craftspeople. Development is not an engineering discipline (for all it's based on mathematics) it's an art. Anyone who...

Andrew..Peterson (12/1/2015)

---

Steve Jones - SSC Editor (9/14/2015)

---

No,...

Disclose to the vendor, then disclose to the public at some later time, using 3 months.

Vehicles are no different in principle. Recalls happen, and a security fix demands a recall....

Interesting topic.

Personally, I favor putting business logic in the database. As someone already pointed out changing business logic (which is tragically seldom logical or stable) is easier to do safely...

Matt Miller (#4) (9/28/2015)

---

I don't know how you're implementing TDD in a DB setting, but there are lots of opportunities for generic code. Perhaps it's because you're discarding dynamic...

TDD is one of those subjects I'm torn on. On the one hand it is unequiocally a good idea, of COURSE you want to test everything!

On the other hand, as...

Are we actually sure NVarchar(255) searches are inefficient? Since string comparisons are left to right the first 5 (certainly the first 10) characters would almost certainly eliminate the vast majority...

Lynn Pettis (9/14/2015)

I have seen commented code where the comments just got in the way and provided no valuable information beyond what was already there in the code itself. ...

Hate to be argumentative, but such zen code is the sound of one hand clapping...

Rod at work (9/14/2015)

---

I'd like to know how people save the stored procs, views, triggers, etc. in a VCS? Whenever I've used SSMS there wasn't any integration I could see...

That's what's really important; you need to use the system and track your code. It's frees you as a developer, allowing you to clean up your code, remove excess comments,...

hakim.ali (9/11/2015)

---

I'm going to play devil's advocate, and ask this question: why bother with creating or maintaining the ER diagram? What purpose does it serve after the very initial design...