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

SDK style database development - part 2

If you went through the first part of this tutorial series, you are going to add an existing project side-by-side you're working project. This is also known as a **composite** project, where you will create a reference to the other main database project, and also include the tSQLt DacPac as a reference for deployment, as this includes all the objects to run tSQLt tests. So, if you did not follow along with the first series, make sure you do that first to follow along with this second part! If you're already there, let's get started

Read

SDK style database development

SQL Server Data Tools (SSDT) is one of the modern development tools to build SQL Server databases. SSDT development is done in Visual Studio, which even in recent years have become smaller in size of the required installations needed to start developing, Microsoft have launched a new release of the SQL Database Projects extension for Azure Data Studio and VS Code. Inside this release, a new preview for an SDK-style SQL project based approach has been introduced, introducing several advantages especially for developers that ship through CI/CD pipelines or are working cross-platform.

Read
Powershell

Lets start exploring Crescendo

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 for short) and use it in combination with the Invoke-Command cmdlet to create in conduction with the New-Service cmdlet. What if WinRM only cannot be used? Are there any other protocols that I was able to use? In this case, I used the RPC protocol, as in many native tools, it is possible to use it in conduction with a computer name parameter. In this blog, I will explore the native sc.exe command line tool.

Read