Deploy SSIS packages from TFS/VSTS Build/Release

Automating BI projects, based on Microsoft tooling, was always a bit painful. Personally, all of the things shipped with SSDT seemed a bit unloved from a Microsoft side. What I would like to show you in this post is how I managed to automate the build and deployment of my Integration Services Projects (.dtproj type). […]

Get Users SID with PowerShell

What is a User SID? It is user’s unique identifier, usually used in application to relate to a user in a unique way. Microsoft defines SID in the following way: A data structure of variable length that identifies user, group, and computer accounts. Every account on a network is issued a unique SID when the […]