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...

Read up on third normal form, primary keys, index covered joins.

I guess this an effort on the part of Microsoft product teams to better synchronize shared code bases, builds, and testing between SQL Server 2016/2017 and Azure SQL Database, which...

I've worked with Oracle in the past as well, and I can adapt to differences in syntax. However, a harder pill to swallow is that in Oracle, '' IS NULL....

I trust Microsoft, particularly the SQL Server team, to do this right and to do it for the right reasons. It's probably the best engineered software product in the world.

I'm not concerned about alleged health risks associated with eating GMO food; that's not the risk people should be concerned with. The way I see it, the real potential threat...

Here is where I've found PowerShell particularly useful:
- Iterating across multiple servers. In my case that's hundreds of servers.
- Integration with Windows, things like gathering disk...