The primary database I work with could be best described as an operational data store; containing time versioned copies of tables from multiple OLTP data sources. There are high volume...

Regardless of what formal process you follow and which tools you use for the delivery mechanism, many of us have known for years that it's best to perform iterative deployments.

Views are also a good way to abstract the application from the underlying data model: hiding columns the application doesn't need, computed columns, row filtering, or switching in a new...

Not to be confused with a "BlackOps" deployment, which is when (hypothetically speaking) a feature currently in prototype or beta is deployed to production temporarily, perhaps under a special schema...

We have a PowerShell script that installs SQL Server using all of our internal best practices.
It will download and run the mssql setup executable for appropriate version and...

"You cannot escape it no matter where you run, for wherever you go you are burdened with yourself. Wherever you go, there you are." —Thomas a Kempis

I don't know why SQL injection is presented as a fundamental flaw of relational databases. Code injection is a much broader security issue that can target all tiers of an...

Here is an example of a good introduction to data warehousing by, Jack Zheng, a Kennesaw State University professor. Within only a few slides, he not only provides an overview...

I'd say the blog post is a good five minute introduction to data warehousing for an audience who has never heard of the topic, but it may be a tad...