This would actually make a good problem solving interview question.

Assuming you're selecting into a table, one simple approach is to use something like the following to determine...

So, if a major hack attack, or an odd unexplained IT disaster, does happen to occur on Friday 13, then it may not be purely a coincidence, for the same...

OK, two more separate screw-ups have occurred after the data breach. I'm beginning to lose faith in the IT guy over at Equifax.

Someone Made a Fake Equifax Site....

... This is the first time I've seen an IT employee blamed. BA said an IT systems failurean IT systems failure with their major issues. Yahoo and Target were hacked,...

T-SQL is a high level declarative language that generally doesn't involve a lot of branching (although every organization has a handful of 2,000+ liners). So, I'm guessing that Code Coverage...

If is the database isn't building a dimensional model, a star-schema model, or computed summary tables, then it's not really a "data warehouse".

This topic reminded me of some writers and artists who (inadvertently or deliberately) destroy the first versions of their work, but then go on to produce a subsequent version for...

Even the best developers can write bad code when they're under the influence of adrenaline, sleep deprivation, and poor requirements. Just like professional authors have editors, it helps to have...

To effectively scale to TB sized tables, an enterprise class RDMS like SQL Server or Oracle must be paired with an enterprise class DBA.

I'm not sure what you're asking, but if what you're saying is that there is one database view created for each application dashboard, meaning that each new application dashboard requires...