T-SQL - Sparks from the Anvil

Browse by Tags

All Tags » T-SQL (RSS)

Supercharge your SSDT database projects using T4 to auto-generate T-SQL code!

There are many techniques that data warehouse developers could learn from other parts of the software industry and automated code generation is one of them. Most database developers have at some point in their careers written T-SQL code to query the SQL...
Posted by DrJohn | with no comments

The most dangerous SQL Script in the world!

In my last blog entry, I outlined how to automate SQL Server database builds from concatenated SQL Scripts . However, I did not mention how I ensure the database is clean before I rebuild it. Clearly a simple DROP/CREATE DATABASE command would suffice;...
Posted by DrJohn | with no comments
Filed under:

SSIS: Building SQL databases on-the-fly using concatenated SQL scripts

Over the years I have developed many techniques which help automate the whole SQL Server build process. In my current process, where I need to build entire OLAP data marts on-the-fly , I make regular use of a simple but very effective mechanism to concatenate...
Posted by DrJohn | 2 comment(s)
Filed under: , ,

MDX + T-SQL: Combining relational and multi-dimensional data into one query result set

How to combine relational and multi-dimensional data into one query result set using OpenQuery...
Posted by DrJohn | 9 comment(s)
Filed under: ,