Tag Archives: presentations

Manual v Automation

Posted on December 12, 2016 by

I’ve got my work cut out for me. This week is SQL in the City 2017. One of the sessions I need to present is a Manual DBA database deployment against an automated CI/CD process with the Redgate tools. To … Continue reading →

Posted in Blog | 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 , ,

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 ,

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 , , , ,

A Practical Approach to Version Control

Posted on October 19, 2015 by

Abstract Chances are, your team has several point-in-time backups for your databases. After all, they’re essential for recovering the system in an emergency. And, chances are, you’ve got a version control system (VCS) to provide the same capabilities for your … Continue reading →

Posted in Blog, Presentations | Tagged ,

Version Control for Databases

Posted on October 8, 2014 by

This is based on my Team Based Development with Version Control talk, which has evolved a bit. Abstract Getting your database under version control is ultimately a way of communicating changes and collaborating with team members, maintaining an audit trail … Continue reading →

Posted in Blog | Tagged , , ,

Get Testing with tSQLt

Posted on September 20, 2014 by

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, where it can be used in an automated deployment pipeline, … Continue reading →

Posted in Presentations | Tagged , ,

Two in Two Days

Posted on August 20, 2014 by

It’s a busy week for me. I’ve got quite a few articles to review, feedback to write for Stairway Series authors, review and changes of some PowerPoint decks for later this month, and two User Group presentations. This is on … Continue reading →

Posted in Blog | Tagged , , , ,

Apologies to my CI for Databases Attendees

Posted on July 21, 2014 by

I have to apologize to everyone that attended my Continuous Integration for Databases talk at SQL Bits. I ran over, a few demos didn’t work, and my machine flaked more than expected. I know those things happen, but I still … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment