DevOps + SQL

Sign in to queue

Description

In this session, we will look at the current state of the art and future of SQL Server and SQL Tools in DevOps practice. Using database CICD automation in Visual Studio Team Service as the key scenario, we will walkthrough how to enable SQL Server 2017 in Docker container to boost-up dev and test productivity and look into database development solutions in Visual Studio 2017 supporting both migration and state-based database projects.

For more information, check out this course on Microsoft Virtual Academy:

Day:

2

Track:

Stream B

Session Type:

Breakouts

Code:

B117

Embed

Download

Download this episode

Download captions

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

  • User profile image
    Juan Carlos Andreu

    Sorry, but horrible speaker. Bad demo. And CiCd loop is broken because the migration changes from must be created manually, or at least that´s what he showed and you should know that it is the MOST important part of cicd for databases. Its the holy grail of this and he skipped it?

    BTW CC are gibberish.

    DO NOW WATCH THIS EPISODE.

  • User profile image
    erickang

    @Juan Carlos Andreu: Hi Juan, thank for the feedback and the points are well taken :) I intended this session as an overview and availability of multiple solution choices rather than a technical session. 

    It is right that a VS solution should not have both state-based and migration-based database projects together. I wanted to show both project types in one screen to show the different approaches and it should have made it confusing for audiences.

    For migration-based approach, it requires developers expertise and knowledge to get it correct and run it through the CICD pipeline. The failure history in CICD for migration-based project again was not intended to show the technical correctness but showing the history of success and failures that could occur in practice hence another confusion. The point is well taken too.

    And sorry about the CC.

    Regards,

    Eric

Add Your 2 Cents