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.
ReadLets 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.
ReadDeploying 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.
ReadAssign Azure roles dynamically through Azure DevOps - part 2
In this blog, you are going to build upon the basis from the first part of the series. The only pre-requisites that you need for this tutorial, is that you've followed along with the first part.
Read