SQL Saturday Prague 2019 Pre-Con: Software Development Life Cycle for Databases (DevOps), Praha, Pátek, 20. Září 2019

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 knowledgeBasic 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.

Pátek, 20. Září 2019, Praha, SQL Saturday Prague 2019 Pre-Con: Software Development Life Cycle for Databases (DevOps)

Další populární události
Získat doporučení na události na základě vašeho vkusu z Facebooku. Získej ho ihned!Ukažte vhodné akce pro měNyní ne