SQL Server DevOps with Kevin Cunnane and Eric Kang
DevOps with SQL Server? Yes! While at Ignite in Orlando, Carl and Richard sat down with Kevin Cunnane and Eric Kang to talk about the latest set of tooling in SQL Server to facilitate incorporating SQL Server databases into your DevOps workflows. Databases seem to be the biggest obstacles in the continuous deployment process - how do you make them part of the process? Kevin and Eric talk about the SQL Server Data Tools as a mechanism to allow database schema to be part of your source code and to be able to build deltas for version changes. Lots more tools in the show links, check them out!
Guests:
Kevin Cunnane
Kevin Cunnane is a Senior Software Engineer for Microsoft. He has been one of the lead developers on SQL Server Tooling for the last 6 years - SSDT, Database DevOps, and now the all new multi-OS tools such as the VSCode MSSQL extension. He is eager to learn how you work with data and how Microsoft can make your day to day job better.
Eric Kang
Eric Kang is a Senior Program Manager in Data Platforms at Microsoft. The key focus areas are SQL Server tools and developer experiences including SQL Server Data Tools in Visual Studio, Continuous Integration and Deployment solutions and multi-os tooling experience such as the mssql extension for Visual Studio Code.
Links:
- JSON Generator https://www.json-generator.com/
- SQL Server Data Tools https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
- MSSQL Extension for Visual Studio Code https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql
- MSSQL Extension at GitHub https://github.com/Microsoft/vscode-mssql
- Visual Studio Code https://code.visualstudio.com/
- SQL Server PowerShell https://docs.microsoft.com/en-us/sql/relational-databases/scripting/sql-server-powershell
- PolyBase https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide
- BDD for SQL Server https://github.com/vassilvk/slacker
- Test Driven Design for SQL Server http://tsqlt.org/
- MSSQL-Scripter https://github.com/Microsoft/sql-xplat-cli/blob/dev/mssql-scripter
- SQL Tools Service https://github.com/Microsoft/sqltoolsservice