SSDT
Deploy SSIS from command line:
- https://stackoverflow.com/questions/55365581/deploy-ssis-project-using-tfs-command-line
- https://github.com/sabinio/AssistDeploy (powershell)
Automate performance test:
- https://www.sabin.io/blog/automating-sql-server-performance-testing/ (Generally check sabin.io)
Generic automatic deployment:
- https://www.sqlservercentral.com/blogs/source/richie-lees-sql-stuff (Richie lee)
- https://github.com/RichieBzzzt/PoshSSDTBuildDeploy/blob/master/README.md deploy with variables
Deploy DacPac with dbatools/powershell:
Use regular .csproj over .sqlproj to make pipelining a lot easier. Also allows nuget packages for database dependencies and much more:
- https://jmezach.github.io/post/introducing-msbuild-sdk-sqlproj/ (Jonathan Mezach)