Browse by Tags

All Tags » T-SQL (RSS)
15 February 2011 10:05

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:
13 February 2011 09:49

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: , ,
27 September 2008 07:36

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 | 2 comment(s)
Filed under: ,