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

Continuous Integration · Deployment · SQL Server · SSIS · Technology

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

Continuing Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 1 Download SSISProject containing: DeploymentDemo SSIS Project SimpleSSISDeploy.ps1 Step 2: Add Parameters.xml to the SSIS Project Before SQL Server 2012, configuration data for SSIS package such as server names, database names, and SMTP servers can be stored in XML files, environment variables, or a separate configuration… Continue reading Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 2

SQL Server · SSIS

How to “downgrade” SQL Server Integration Services 2014 packages to 2012

The Problem A few months back, I built an SSIS 2014 project using Visual Studio 2013 that is supposed to serve as a template for future data warehouse projects. Our servers are still in SQL Server 2012, but the upgrade has been approved and so it made sense to create the template project in VS 2013.… Continue reading How to “downgrade” SQL Server Integration Services 2014 packages to 2012