Software Development Life Cycle for databases as a part of nowadays DevOps, Aktiviteten AB, fredag, 13. september 2019

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.
 
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!
 
 Damian Widera is an SQL Server MVP & MCT
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 possesses practical knowledge of procedures and tools which are necessary for successful implementation of such projects.
Now he focuses on building solutions based on Microsoft SQL Server environment (including complex database driven systems, database tuning and optimization).

Software Development Life Cycle for databases as a part of nowadays DevOps

Hitta fler händelser omkring dig
Få rekommendationer händelse baserat på din Facebook-smak. Hämta den nu!Visa mig lämpliga händelser för migInte nu