Continuous Integration of SQL Server with Ike Ellis
Ci with SQL Server? Are you crazy? Carl and Richard talk to Ike Ellis about what it takes to get databases changes happening as smoothly as application changes. Really! Ike talks about the concept of database lifecycle management and how it is orthogonal to application lifecycle management. The tricky bit is managing the data! And to help with that, Ike discusses a great tool chain of source code management, testing and deployment tools that work with databases like SQL Server and integrate into your usual development lifecycle toolchain as well. This is some next level DevOps thinking!
Guests:
Ike Ellis
Ike Ellis is a five-time Microsoft MVP for SQL Server. In March, he co-wrote "Developing Azure Solutions" with Zoiner Tejada and Michele Leroux Bustamante. He has spoken at SQL PASS Summit and TechEd. For his day job, he's a partner in a San Diego-based software studio, Crafting Bytes.
Links:
- Autorun for Windows https://technet.microsoft.com/en-us/sysinternals/bb963902.aspx
- Fluent Migrator on GitHub https://github.com/schambers/fluentmigrator
- Database Lifecycle Management on MSDN https://msdn.microsoft.com/en-us/library/jj907294(v=sql.110).aspx
- RedGate SQL Source Control http://www.red-gate.com/products/sql-development/sql-source-control/
- FlyWayDB http://flywaydb.org/
- Ready Roll http://ready-roll.com/
- SQL Server Data Tools in VS2015 https://msdn.microsoft.com/en-us/mt186501.aspx
- tSQLt http://tsqlt.org/
- RedGate SQL Compare http://www.red-gate.com/products/sql-development/sql-compare/
- Octopus Deploy on DotNetRocks https://dotnetrocks.com/default.aspx?showNum=1002
- CraftingBytes http://www.craftingbytes.com/
- Ike's Blog http://ikeellis.com/