You’re comfortable with PowerShell and you’ve honed your T-SQL skills over the years, but what about the Bash scripting language? With the release of SQL on Linux a lot of DBAs are wondering how they might manage SQL on this new and unfamiliar operating system. While PowerShell Core is available and has come a long way, it still needs to be installed and certainly has some limitations. Bash on the other hand is available on almost any Linux system and can be incredibly powerful.
Lots of people have used the
OUTPUT clause in an
DELETE statement, but many may not know just how flexible it is, and what hidden gems there are in the documentation. In this post we are going to look at two interesting and surprising use cases for the