SQLBits 2020
Start to See With tSQLt
Unit testing with databases is fairly new and is not yet embraced within database development.
We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt
Unit testing with databases is fairly new and is not yet embraced within database development.
Many database developers do not do any unit testing or don't do it in a automated way.
tSQLt is a unit testing framework that enables developers to create sophisticated unit tests for databases.
You can create a whole bunch of different kind of unit tests. From really simple to very complex.
In this session we'll talk about unit testing in general, unit vs integration testing, test driven development and of course tSQLt.
Come to this session if you want to learn how to implement tSQLt in your development procedures
I can assure you that it's going to make your life so much easier in the end.
Speakers
Sander Stad's previous sessions
Streamlining Power BI with PowerShell
Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone.
This session explores how PowerShell automation simplifies and streamlines these tasks.
Saying no is OK
In the high-demand IT field, professionals often struggle with overcommitment and work-life balance. This presentation, "Saying No is OK," offers practical insights and strategies for IT professionals to assertively manage their workload and protect their well-being. Learn the art of saying no, how to prioritize, and maintain professionalism while achieving a healthier work-life balance. Join us for a transformative session that will empower you to succeed while setting necessary boundaries.
Unveiling the magic of CI/CD for SQL Server using GitHub Actions
In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.
Github and Azure DevOps Duet - SQLBits edition
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
Battle tested project planning with Azure Devops boards
Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?
Start to See With tSQLt
Unit testing with databases is fairly new and is not yet embraced within database development.
We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt
Solving the dev DB problem with Docker and dbaclone
Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.