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.
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.
ReadBuilding quality Powershell modules
When working in multiple teams, it might become quite difficult to follow code styling rules for your Powershell modules that you publish to your fellow engineers. How can you make sure that the team adheres to code styles rules? Is it possible to protect your main branch before relasing your proffesional Powershell module?
Read