I wonder if the coding world doesn't need a paradigm shift from pursuing correctness to pursuing excellence. Those are two very different things.

Pursuing correctness often devolves into "The Gospel...

Can't say that I've used them directly beyond the aforementioned SUM and AVG, etc., as I prefer to create a data set for the people who want to do analysis...

Okay, so I'm sitting in my cube today contemplating my typical Adjacency List employees table and of course the equally typical recursive CTE contraption I use to query it hither...

At the risk of being Captain Obvious, like most naming conventions the best strategy is to pick one that works and use it consistently whether it's a table, column or...

One of my first databases was a cookbook for my favorite grill recipes.

For the really fundamental stuff (backups/restores, normalization, stored procedures, query plans, et multiple cetera) version isn't all that...

Our office here has 1 physical box running SQL Server (two including my dev machine).

Nearby there is a datacenter that manages 5,000+ databases on all kinds of database engines and...

In the comments of the SQL Server Blog article someone mentioned the cost issue, to which the team quickly responded by pointing to a study by Forrester Consulting (commissioned by...

Luckily this has made me get rather OCD about testing, getting users involved and getting feedback from them before I change anything in the real world - it's rare I...

This isn't really as far-fetched as it sounds. The question is the level of decentralization involved.

Our unit isn't on the company network, doesn't use company-provided equipment and has its...

Interesting idea, except duress codes don't change behavior of the alarm systems themselves. The alarms are disabled, but the authorities are immediately dispatched to the location.

An attacker doesn't need...

Pick up a book called "No-Tech Hacking". It's certainly an eye-opener on this topic if it doesn't scare the **** out of you first.

Grant is right: We can't...

Spot on. Five years ago I didn't know squat about SQL Server, though long before I had taken the time to learn and understand the basics of normalization, at...

iposner (4/13/2015)

---

There's another issue here too: The demands of developers to be able to deliver solutions without the RDBMS knowledge to ensure a successful implementation.

Is this a consequence of a...

Five years in and I'm still fixing things - and having a whale of a fun time doing it.

The scale of my business unit means I work on both ends...

Heck, I'd kill for some kind of apprenticeship/mentoring program. I'm perfectly comfortable hacking all this out on my own, but I know there's AN AWFUL LOT I'm missing.

I use...