Category Archives: Presentations

Unit Testing T-SQL Code

Posted on October 18, 2017 by

Abstract Unit testing has become an integrated, expected part of most software development teams. Many database developers have yet to implement unit testing as a regular habit. This session will look at two-unit testing frameworks and show how to implement … Continue reading →

Posted in Presentations | Tagged ,

A Tour of SQL Server Security Features

Posted on October 18, 2017 by

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading →

Posted in Presentations | Tagged , , , ,

Including Your Database in a DevOps CI/CD Process

Posted on March 31, 2017 by

Abstract DevOps is changing today’s software development world by helping us build better software, faster. However many organizations struggle to include their database changes with their application deployment. In this session, we will examine how the concepts and principles of … Continue reading →

Posted in Presentations | Tagged , ,

Who’s Touching My Database

Posted on October 11, 2016 by

Abstract: As databases become more critical to the operation of our organizations, we are being asked to audit and report on access to both data and the configuration of our systems. SQL Server has a number of features that can … Continue reading →

Posted in Presentations | Tagged , ,

Bringing DevOps to the Database

Posted on September 12, 2016 by

Abstract: DevOps is a hot topic in today’s software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can … Continue reading →

Posted in Presentations | Tagged , , , , ,

Testing T-SQL Made Easy

Posted on May 12, 2016 by

Abstract: 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 … Continue reading →

Posted in Presentations | Tagged , ,

Getting Started with Encryption in SQL Server 2016

Posted on April 18, 2016 by

The release of SQL Server 2016 gives developers a number of ways in which they can securely encrypt and protect their data. In this introductory session, you will learn about the encryption options in SQL Server 2016, watching Always Encrypted, … Continue reading →

Posted in Presentations | Tagged , , , , ,

End to End Always Encrypted in SQL Server 2016

Posted on April 16, 2016 by

Abstract: Protecting our data from unauthorized access becomes more and more important all the time, however it has been difficult to ensure sensitive data is encrypted in SQL Server. The new Always Encrypted feature in SQL Server 2016 makes this … Continue reading →

Posted in Presentations | Tagged ,

Redgate DLM Demo Slides

Posted on November 17, 2015 by

I had someone ask about the DLM Demo slides, so here they are: DLM-Demo.pptx I’ll put together an overview of the demo as well that you can read about.

Posted in Blog, Presentations | Tagged

Using Automated Tests to Raise Code Quality

Posted on November 2, 2015 by

Abstract Agile development practices can speed the development of applications and increase the rate at which you can deploy features for your customers. But unless you include a high level of test coverage in your code, these practices can also … Continue reading →

Posted in Blog, Presentations | Tagged , , , ,