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

Automation · Continuous Integration · Deployment · SQL Server · SSIS · Technology

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

Let’s start this by describing the scenario with which the approach described below will be useful to you: You are using SQL Server 2012/2014 You have a separate server/instance for each staging environment (Development, Acceptance, Production, etc.) You would like to automate SSIS project deployments to your target environments You would like to automate managing SSIS package… Continue reading Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 1