Welcome to Salvo(z)

Top Posts for 365 days ending 2012-12-15 (# of Views)

I was preparing a demo for a presentation and needed to generate some random dates within a specified timeframe.  I came across the following SQL that worked well for demo purposes and am recording it on my blog since it may prove to be useful in the future.

Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented by Akshai Mirchandani and Allan Folting of Microsoft.

When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or replace characters.  I recently used the Script Component in SSIS to cleanse some ticket tracking data and thought I’d write a blog post that outlines the implementation.

‘Why School?: How Education Must Change When Learning and Information Are Everywhere’ by Will Richardson provides an excellent synopsis of how our school systems must transform to prepare students for the 21st century and beyond.