A lot of organizations don't have version control systems in place for the database. Even if they are, change scripts are being generated manually for deployment process causing significant risks to the releases. In this demo, we will demonstrate patterns that can be used for taking care of database deployments and minimizing the risks

 
2 favorite thumb_down thumb_up 1 comment visibility_off  Remove from Watchlist visibility  Add to Watchlist
 

Outline/structure of the Session

  • 5 min: Common problems with Database Deployment?
  • 5 min: How are they being addressed?
  • 20 min: Continous Integration for Database Project using SQL Server
  • 15 min: Q&A

Learning Outcome

  • Implement Version Control System for Database
  • Continuous Integration for Database
  • Implement Database Deployment within Release

Target Audience

Release Engineers, Developers, DBA, DevOps Engineers

Prerequisite

None

schedule Submitted 1 week ago

Comments Subscribe to Comments

comment Comment on this Proposal
  • Leena S N
    By Leena S N  ~  1 week ago
    reply Reply

    Hi Srini,

    This is a very relevant topic. I think the outline needs more details about what will be covered in the demo i.e. how do you structure the 30 minutes.

    Also, please add a video of your earlier talks for us to understand your presentation style.

     

     


    • Liked Alan Cooper
      keyboard_arrow_down

      Alan Cooper - Working Backwards

      Alan Cooper
      Alan Cooper
      Founder
      Cooper
      schedule 1 month ago
      Sold Out!
      45 Mins
      Keynote
      Intermediate

      Using examples from his award-winning design consultancy, Alan Cooper shares the secret to his success: working backwards. Working backwards means taking the time to ask the hard questions before wading into unfamiliar territory. It can be scary (and for some, frustrating), but it's the only way to innovate.

    • 20 Mins
      Talk
      Intermediate

      Story is a profoundly important device to unite design teams around a shared product vision. This powerful communication tool helps us retain information and empathize with others. As companies scale and teams sprint through product iterations, it’s easy to lose sight of how your product should fit into the lives of your customers. The best way to keep everyone pointed in the right direction is with a clear, compelling story—a story that will unite and guide teams towards success.

      But how do we fold storytelling into our design practice? Aarron Walter uses real-world stories of product teams at Disney, Apple, Airbnb, Twitter, and more to show how storytelling improves team communications and elevates design practice.

    • Liked Gopi Kallayil
      keyboard_arrow_down

      Gopi Kallayil - 9 Principles of Innovation at Google

      45 Mins
      Case Study
      Intermediate

      Since its founding, Google has created six products that each have at least a billion monthly users. Google continues to innovate rapidly, and in many new areas. The organizing principles and cultural elements that drive this monster of innovation are a hot topic among designers. So what are they? Find out in this engaging talk by Google’s Chief Evangelist, Brand Marketing.

    • Liked Mihail Sestakov
      keyboard_arrow_down

      Mihail Sestakov - Running Shared Services Teams: DevOps, Infrastructure, Security, Networking

      45 Mins
      Talk
      Intermediate

      Shared Services Teams, such as DevOps, Infrastructure, Security, Networking, etc., for a variety of reasons do not receive agile training and coaching specific to their needs. This often results in failure to consistently deliver expected outcomes, resulting in costly delays in overall delivery, often undetected until it is too late.

      Shared Services Teams are expected to simultaneously:
      - build assets, such as delivery pipelines, networking, cloud, infrastructure, etc. on time and on budget, and
      - support Agile Development Teams and Operations, often at short notice.

      These two different types of tasks are typically managed in the same way and usually as a dual priority Kanban, which is not addressing their different nature, thus causing costly delivery delays.

      This talk explores this Dual Nature of work and the difficulties arising from addressing both types by a single team. The lecture presents experience with Coaching different types of Shared Services Teams.

      It shows ways how their specific needs can be addressed at various agile maturity levels, including areas such as Governance, Capacity Optimisation, Supplier Reliability and Support Mix Optimisation.

    • Liked Michael Chik
      keyboard_arrow_down

      Michael Chik - Improv-ing your Coaching Skills

      90 Mins
      Workshop
      Beginner

      Improv your coaching skills (pun intended) and your team performance! On a superficial level, improv techniques introduce play and fun into every team. On a deeper level, it helps you create a culture of safety, experimentation and true collaboration. It helps people to welcome change, uncertainty, open up and helps infuse teams and individuals with a dose of EQ. It also helps you to improve your own coaching skills! Wanna know more? Come and find out! This workshop will introduce you to improv by throwing you heads-first into one exercise after another.

    • Liked Nick Balestra
      keyboard_arrow_down

      Nick Balestra - Painless micro frontends delivery

      Nick Balestra
      Nick Balestra
      Senior Engineer
      OpenTable
      schedule 1 month ago
      Sold Out!
      45 Mins
      Case Study
      Intermediate

      While microservice architectures allowed teams to scale delivery of independently deployable services, most frontend layers are still run as monolithic applications. Similar to server-side applications, frontend layers often grow into large monoliths that are difficult to maintain and evolve. Building, deploying and consuming frontend components across a diversity of teams and web applications can be a daunting task, especially at scale. To address this issue, at OpenTable we enable fast-moving teams to easily build and deploy front-end components using OpenComponents, an open-source, battle tested, front-end microservice architecture for painless component delivery.

      The idea behind micro frontends is to enable multiple teams to work seamlessy together by fostering end-to-end ownership of independently developed, tested and deployed features.

      Think about UI as the composition of features which are maintained by independent teams. These teams could be cross-functional allowing them to develop such features end-to-end, from a database to user interface and independently deploy them.

      During this session I'll explain how OpenComponents works, how do we use it at OpenTable and how we allows teams to build ship and consume frontend components at runtime across teams and web applications at scale.

    • Liked Srini Kadiam
      keyboard_arrow_down

      Srini Kadiam / Mohan / Umesh Kumar - Workshop: Implementing DevOps Practices using Visual Studio Team Services

      480 Mins
      Workshop
      Advanced

      This is a hands-on workshop, be prepared to write code and do some work. You will learn something either by doing or teaching.

      As part of this workshop, using Visual Studio Team Services, participants will get hands-on experience to learn and practice

      • Setting up build
      • Continuous integration
      • Agile testing practices - unit, integration, UI, performance, and security
      • Automated deployments
      • Infrastructure provisioning
      • Setting up release workflows
      • Database deployment
      • Container-based development and deployment using Docker
    • Liked Srini Kadiam
      keyboard_arrow_down

      Srini Kadiam / Mohan / Umesh Kumar - Demo: Helping your team to get started on DevOps Journey using Visual Studio Team Services & Docker

      45 Mins
      Demonstration
      Intermediate

      Most organizations and teams talk about DevOps practices. Most of them might find it difficult on how to get it started. If you are a Microsoft shop, this would be a good session for you and your team. In this session, we will demonstrate different DevOps practices using Visual Studio Team Services & Docker