Tag Archives: presentations

Testing T-SQL Made Easy

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

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

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

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

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

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

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

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

Creating Your First Technical Speaking Opportunity

Abstract: This session will cover the basics of choosing a topic, writing an abstract, building a slide deck, and finding an opportunity to deliver your presentation. This is a short introduction to beginning to speak about technical topics. Length: 30 … Continue reading

Posted in Presentations | Tagged ,

High Performance Encryption

It is becoming more and more important to protect your data from anyone that should not access it, including the DBA. Learn how you can use column level encryption as well as TDE to protect your data files, with minimal … Continue reading

Posted in Presentations | Tagged ,