Gratis

PASS Avond over CI met SQL Server bij Schuberg Philis

Evenementgegevens

Deel dit evenement

Datum en tijd

Locatie

Locatie

Schuberg Philis

271 Boeing Avenue

1119 PD Schiphol-Rijk

Netherlands

Kaart bekijken

Vrienden die gaan
Beschrijving van het evenement

Beschrijving

Alex Yates will be our guest speaker tonight.

Alex loves DevOps. He also loves databases.


Alex has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He's most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica - so he's keen to meet anyone who researches penguins.
A keen community member, he helps organise the London Continuous Delivery meetup and SQL Relay. He blogs at workingwithdevs.com, speaks wherever they'll let him and manages the DLM Digest monthly email: a report on the latest database DevOps news/tutorials.
He's quite fond of nutella. And otters. (Not together.)


Agenda:


17:30 - 18:30 Guests arriving and having something to eat
18:30 - 18:45 Welcome at Schuberg Philis
18:50 - 19:50 Getting CI right in SQL Server

This isn't the dark ages any more. You've learned that you need to put your database in source control and you're competent with source control systems like TFS or Git. You've also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.
However, you haven't really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins. You still haven't written as many automated tests as you know you should. Even if you have you aren't sure how the process should work for SQL Server builds and tests.
In this session I'll talk through the two most common ways to automate your database builds/deploys and the pros and cons of each. Then I'll show you how to use tSQLt to build a suite of tests that can be run as part of your build process, giving you confidence in the quality of your code.


19:50 - 20:10 Short break
20:10
- 20:30 Database drift, cheese graters and Elton John

A bit of fun that explores the relationship between hot-fixes on production and physical pain. Set to music.





20:30 - 21:15 Database DevOps Anti Patterns

(aka. How to screw up your ability to deliver database updates in 16 simple steps)
A cheerful review of the 16 most popular strategies for screwing up your ability to deliver your users' data requirements.

21:15 - 22:00 Networking

The evening is completely free of cost thanks to our generous host Schuberg Philis.

Delen met vrienden

Datum en tijd

Locatie

Schuberg Philis

271 Boeing Avenue

1119 PD Schiphol-Rijk

Netherlands

Kaart bekijken

Sla dit evenement op

Evenement opgeslagen