Testing T-SQL Made Quick and Easy

2016

TL; DR

Everyone tests their code, but most people use ad hoc, non-repeatable testing with simple queries. This session will show you how to begin implementing testing into your development process, giving you a growing library that improves code quality.

Session Details

Everyone tests that code, but most people run a query, execute a procedure and run another query. This ad hoc, non-repeatable testing isn't reliable, and encourages regression bugs. In this session you will learn how to begin introducing testing into your development process using the proven tSQLt framework. You'll run tests with a click of a button, using an ever growing test suite that improves code quality. You will see how to handle test data, exceptions, and edge cases.

3 things you'll get out of this session

Steve Jones's previous sessions

Blogging for the Tech Professional

Blogging is a fantastic way to attract prospective employers that want to learn more about skills. This can raise your profile, help you guide the interview process, and even help you become an MVP.

Including Your Database in a DevOps CI/CD Process

Many organizations want to build software in a DevOps framework, but struggle to include the database. Come see how Continuous Integration, Testing, and Continuous Deliver can work with a database.

Get Testing with tSQLt

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.

Branding Yourself for a Dream Job

Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.

Continuous Integration for Databases

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.

Searching Binary Data in SQL Server 2012

A look at binary data in SQL Server and full-text searching of the content of binary files.

Preparation for Disaster

Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepa