Monday, June 3, 2019

Continuous Deployment (CD) with Azure DevOps, SSIS, and SQL Server Database Projects

›
What are we doing here? This is the second part of a two-part series covering 1) CI (continuous integration/build) and 2) CD (continuous d...
Sunday, November 18, 2018

How to Share Power BI Reports On Your Website (for free)

›
Let's say your a geek and you're traveling the country in your 30 year old Airstream trailer and you have a bunch of data you'...
Wednesday, May 9, 2018

How to Execute an SSIS Package on Azure from On-premise or IaaS Server

›
So you have SSIS packages deployed to Azure using ADFv2 and an Azure-SSIS Integration Runtime but you still have on-premise or IaaS SQL Serv...
Thursday, May 3, 2018

Integration Services Catalogs Node Not Visible in SSMS When Connecting to Azure Server w/ Azure SSIS Integration Runtime

›
So you went through all the steps to configure and deploy SSIS on Azure using an Azure SQL Server, Azure SQL Database (for SSISDB), Azure Da...
Tuesday, May 1, 2018

SSRS Continuous Deployment PowerShell Script using ReportingServicesTools

›
Way back in 2010 I wrote a post  about how to use RS.exe to automate the publishing of SSRS objects such as reports, datasource, folders, et...
Monday, April 30, 2018

PowerShell PSSecurityException: UnauthorizedAccess

›
I just fought with this for close to an hour and the solution was REALLY simple so I thought I'd try and save someone else an hour of th...
Thursday, April 26, 2018

Continuous Integration (CI) with Azure DevOps, SSIS, and SQL Server Database Projects

›
What are we doing here? This is the first part of a two-part series covering 1) CI (continuous integration/build) and 2) CD (continuous de...