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

Getting Started with Encryption in SQL Server 2016

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

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

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

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 ,

Avoiding a DBA’s Worst Days with Monitoring

SQL in the City Abstract: When things go wrong with a database, it can be the start of the worst day of a DBA’s life. Join Steve Jones as he examines the problems uncovered by The DBA Team and how … Continue reading

Posted in Presentations | Tagged , | 1 Comment

Intermediate T-SQL: Window Functions

This is the third hour of a three hour set of presentations on intermediate T-SQL techniques and features. This presentation covers the window functions that are available in SQL Server. Some of these functions were introduced in SQL Server 2005 … Continue reading

Posted in Presentations | Tagged

Intermediate T-SQL: PIVOT, UNPIVOT, and APPLY

This is the second of a series of talks I put together on intermediate T-SQL topics that many database developers might not understand. In this talk, we cover the other join-type operators that exist in the FROM clause, outside of … Continue reading

Posted in Presentations | Tagged

Intermediate T-SQL: Writing Cleaner Code

This session is an intermediate T-SQL session that helps users learn how to write better T-SQL code by covering a few items that many database developers might not be aware of. In an hour, users will lean how to: write … Continue reading

Posted in Presentations | Tagged