Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
---|---|---|---|---|
12-12-2018 15:00 | Jim Wooley | Breakout Session (60 minutes) | Application Development | Entity Framework Performance Monitoring and Tuning |
12-12-2018 16:00 | Thomas Liddle | Breakout Session (60 minutes) | Application Development | Getting Started locally with SQL Server and Kubernetes |
12-12-2018 17:00 | Geovanny Hernandez | Breakout Session (60 minutes) | Database Administration and Development | Lets go deep in SQL Server Unit Testing with Visual Studio |
12-12-2018 18:00 | Hamish Watson | Breakout Session (60 minutes) | Database Administration and Development | tSQLt - How to Unit Test Your Database Code for Free |
Event Date: 12-12-2018 15:00 - Category: Breakout Session (60 minutes) - Track: Application Development
Event Date: 12-12-2018 16:00 - Category: Breakout Session (60 minutes) - Track: Application Development
This session involves installing, connecting and working with a local (on your laptop or desktop) Microsoft SQL Server Express instance on Kubernetes. The goal is to show an administrator or developer how to get started with Microsoft SQL Server locally using components like minikube, Kubernetes, Helm and SSMS. We will explain each component used in the setup, how to install them and finally connect SSMS to our Microsoft SQL Server instance on a local Kubernetes installation.
Event Date: 12-12-2018 17:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
When you start to google search about how to start implementing Unit Testing for SQL Server you always find tSQLt as the first result returned, however, the extremely low number of downloads tell us about the issue with this implementation. Some possible causes could be explained, such as the lack of a free UI tool for executing the tests, but I have been working with many full-stack developers and one of the most important complaints is related to the fact that AAA (Arrange-Act-Assert) is not native and they can’t feel a soft transition in their regular tasks for Unit Testing with Databases.
In this presentation, I would like to focus on how to get a better performance through the SQL Unit Test feature of Visual Studio, how to overcome the problems.
Event Date: 12-12-2018 18:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
This session will introduce you to tSQLt - a unit test framework - which allows data professionals to easily unit test their code in the same manner that application developers have for decades. One of the best aspects of tSQLt is that allows the unit tests to be written in T-SQL, which means that DBAs do not have to learn another language and more importantly they can use it in SQL Server Management Studio. The other aspect of tSQLt is that it is a free open source framework which means you can also contribute ideas/features back.
In this session we will look at how to implement tSQLt, use it in a variety of ways and how even if you have no existing unit tests and a large code base, you can start writing tests now to make the deployment of your database code safer.