Others · Photograhpy

Vanie Castro Takes Pictures

In case you haven’t received a mail, or have not been forced to look at it on my phone or in a computer, then you probably don’t know about.. http://vaniecastrotakespictures.com It’s a new domain dedicated purely for photographs I took and soon will take. Thanks to 500px, it doesn’t take too much resources now to… Continue reading Vanie Castro Takes Pictures

SQL Server · SSAS

How to Implement Slowly Changing Dimension Type 2 in SQL Server Analysis Services

The other day somebody asked me how I could implement Slowly Changing Dimension Type 2 (SCD Type 2) in SSAS. I wasn’t able to give the answer right there and then, so I decided to create a demo video to answer his question and as a note to myself for future uses. This is my first ever demo… Continue reading How to Implement Slowly Changing Dimension Type 2 in SQL Server Analysis Services

Automation · Continuous Integration · SQL Server · SSIS · Technology

Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 3

Continuing: Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 2 Download SSISProject containing: DeploymentDemo SSIS Project SimpleSSISDeploy.ps1 Step 3: Execute SimpleSSISDeploy.ps1 Last and definitely NOT the least, where all the magic happens – SimpleSSISDeploy.ps1. I put comments where needed, and you can download a zip of all the components, as well as a sample… Continue reading Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 3