Kamil Nowiński
Kamil Nowiński

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

We will go to the Software Development Life Cycle (SDLC) process in great details from the database point of view. But we will not spend too much time on analysis but rather on the development part. We would like to show the usage of the Octopus application.
Of course, there will be an entire module about best practices and how to efficiently use them in the database projects.

At the end, we would like to touch the cloud and show how to migrate the existing on-premises database to the Microsoft Azure SQL Database and how no to get into troubles.

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
  • migrate project to Microsoft Azure (Cloud!)
  • use hybrid approach
  • apply tSQLt Unit Tests
  • make a deployment manually and automatically (Octopus)
  • distinguish (finally) all three types of “Continuous”
  • some helpful PowerShell scripts

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 most of the task we are going to do with you!

You will have access to all codes we present plus you will get printable version of the slide deck