Are you mystified by SQL Server performance? Do you wonder why sometimes your SQL statements runs fast but other times, they run painfully slow? Do you wish there was a pragmatic set of steps you could go through to troubleshoot performance problems that didn't require you to have a PhD in database internals? If so, this talk is for you.

In this talk, I'll describe database performance from a developer's point of view. I'll show how you can accurately measure the performance of any SQL statement, how to understand what the statement is doing when it runs and what you can do to improve this performance. I'll show how the right database indexes help SQL Server locate the data your application needs very efficiently and what you need to know to create effective indexes for your application. Finally, I'll discuss how you can use built in capabilities in SQL Server to find your worst performing statements and tables that are missing indexes so you can quickly find and solve your biggest performance bottlenecks. At the end of this talk, you will no longer regard database performance as black magic, but instead be able to confidently analyze and solve any performance problems you encounter.

Lost in the forest of front-end build systems out there? Check out Gulp! Gulp makes it super easy to minify, concatenate, and optimize your assets in an easy piping build stream. There are only a few commands to learn, so writing complex tasks (like you would in another system) isn't a thing in Gulp. In this talk, I will walk through what Gulp is and create a working gulpfile that can be used across endless front end projects that minifies, concatenates, and optimizes assets, as well as live reloads the browser using browser-sync.

This session takes a deep dive into the performance space as it relates to ASP.NET Server Side Code issues, geared towards assisting those that know their code is not performing as well as it should, but unsure of where to start. A methodical process will be introduce that will help to guide users through the diagnostic process, regardless of the toolsets used. Various tools will be discussed, including built in Visual Studio Tools, third-party tools, and third-party monitoring solutions to illustrate the methods available to get the information needed, the specific tools are not important, but the resultant data.

Attendees will learn high-level concepts of performance optimization including the concept of benchmarking, controlling environmental states, and validation that test scenarios are real-world. After attending the session, regardless of the toolsets available at work attendees should have a better understanding of how to approach, and resolve, their performance issues. Real-world examples, and data will be outlined.

Being a major player in the FinTech space we take protecting our client’s information seriously. Client information must be protected as it flows from system to system but also when it comes to rest (where it is stored long term). Even if those systems aren’t even written in the same technology. Encrypting data presents some very unique challenges like scalability and performance since every system upstream and downstream needs to call the system. It is something that always needs to be on, perform at high scale, and yet still be easy to use and integrate with for other development teams. In this session I’ll walk you through how we built an encryption platform from the ground up, some technologies we used, why we chose them and how developers use the platform using one of our open source frameworks.