Azure DevOps

Powershell

Dynamic inventory your Azure Virtual Machines with PSDocs

Are your teams spawning Azure Virtual machines like sandwiches going over the counter? Do you want to dynamically create an inventory of your Azure VMs and share it with your stakeholders? Do you want to identify which Azure VM belongs to which environment and department? Glad to have you hear.

Read
Powershell

Document your Azure DevOps pipeline templates

When working on your precious pipeline templates that you write in YAML, it can be a burdensome to document each parameter individually. Documentation is also overlooked, as you always seem to be busy with other things, but eventually you'll be glad you did it. What if you can make it more fun and easier to do?

Read
Powershell

Building Azure DevOps REST API extension

Quite recently I was facing an issue whereas a new service was introduced which needed deployment through Azure DevOps remotely. Normally spoken I would fallback in Windows Remote Management (WinRM) and use it in combination with the Invoke-Command cmdlet to create in conduction with the New-Service cmdlet. Unfortunately, WinRM was disallowed by the Network Security Groups (NSGs) on the Azure VMs. Luckily the RPC protocol was allowed, giving us the ability to use the native sc.exe command line tool.

Read

Deploying SQL Server objects with database automation

Database automation helps complex and time consuming tasks to be repetitive and simple across environments. Many times, database administrators are responsible for provisioning and configuring SQL Server objects like SQL Server Agent jobs, triggers, security, functions and even tables that are outside the Software Development Lifecycle of the database on each environment in a traceable manner.

Read