Kč4,990

SQL Saturday Prague 2019 Pre-Con: Software Development Life Cycle for Datab...

Event Information

Share this event

Date and Time

Location

Location

110 00 Praha

Czechia

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

SQL Saturday Introduction

On September 21, 2019 we are organizing SQL Saturday Prague 2019!
Microsoft Data Platform conference, where you can register for FREE!

If you want to gain deep knowledge in one specific topic, don't hesitate and register for one of our full day in-depth workshops held by the best experts in our data engineering industry!

So, are you ready to get cool insights to nowadays DevOps approaches to manage data applications? Choose this one!

Pre-Con: Software Development Life Cycle for Databases as a Part of Nowadays DevOps


Presenter: Data Platform MVP Damian Widera, @DamianWidera

Nowadays the DevOps is the topic number one in many industries and companies. However, in some case, you see that the code repository is or will be the most important topic. The number of tasks could be overwhelming at first glance, however, there is no other way - you have to use the new tools and solutions

The code repository term is not really new but the way it is integrated with the database world is still sometimes questioned. And there are a lot more than that just naming Continuous integration, Continuous Delivery or Continuous Deployment.

I would like to show you tools to efficiently manage database projects (SQL Server Data Tools), how to start working with projects, how to deal with problems you will probably see during daily operations and how to configure and manage the projects' deployment process on different environments.

Workshop Agenda

I will go to the Software Development Life Cycle (SDLC) process in great details from the database point of view. But I will not spend too much time on analysis but rather on the development part.

Of course, there will be an entire module about best practices and how to efficiently use them in the database projects.

After attending our workshop you will be able to do / know:

  • create empty or import existing databases
  • resolve various problems during the import of database
  • manage database project and its objects
  • handling CLR objects
  • store data in a project (static data, dictionary, etc.)
  • what should be a part of project and what shouldn't (Linked Servers, security)
  • where and how to keep SQL Jobs
  • split database project into more chunks and why it's required sometimes
  • cope with unlimited amount of projects
  • avoid known issues like: temp tables, triggers, circular references, OPENQUERY, lack of validation
  • use hybrid approach
  • apply tSQLt Unit Tests

We are going to show you commercial tools as well as some tips& tricks as well.

Requirements

Basic TSQL knowledge
Basic Visual Studio knowledge

The workshop will be done in the Visual Studio 2017 with the newest SSDT installed but you can use older version of the Visual Studio as well

You can take your laptop with you as some of the task I am going to do with you!

Bio

Damian Widera is a software engineer with 18+ years of professional experience in all aspects of software development. Damian participated in a number of projects in international environments and having a very practical knowledge of procedures and tools which are necessary for successful implementation of such projects.
Now he focuses on building solutions based on Microsoft Data Platform environment (including complex database driven systems, database tuning and optimization). Damian is experienced Microsoft speaker and columnist, has been awarded MVP title since 2009 as Data Platform guru. Damian is responsible now for creating and maintaining SQL Server Community in Silesia Region. Damian holds Microsoft Certified Trainer certificate from 2004. Describes himself as an energetic actor.

Share with friends

Date and Time

Location

110 00 Praha

Czechia

View Map

Refund Policy

No Refunds

Save This Event

Event Saved