Kevin Kline

Many great developers, DBAs, and architects get their day-to-day work completed on time and with reasonable quality while never fully understanding what’s happening behind the scenes of their database systems.

What sets apart the most credible, trusted, and influential members of an IT team from the rest? What habits and behaviors do they exhibit that result in being treated with respect, while other team members of equal technical skill on the same team are virtually ignored?

When organizations are small and simple, information technology is often thought of as just a means to support the business. But as organizations grow in complexity and sophistication, they begin to realize that their data is a true asset with enormous value requiring proactive management.

Installing an on-premises SQL Server is easy. But configuring SQL Server to make performance the top priority of all configurable aspects of service usually takes years of study and experience to do well.

In this session, we’ll go deep into the internal behavior of SQL Server CPU, including the internal and external memory pressure, worker thread management, and how to troubleshoot CPU problems.

Using SentryOne Plan Explorer, a 100% free product, DBAs and Devs write better performing SQL code in a fraction of the time otherwise possible. Plus, troubleshooting existing SQL code becomes a fast, easy, and visually vibrant experience.

Migrating an existing on-premises SQL Server application to the cloud can be a daunting task that consists of many complicated steps. In this webinar, we will focus on what is perhaps the MOST important step of the process – those that lead up to the actual move to the cloud.

Whether you are hosting in your office, in a data center, or in the cloud, SentryOne covers monitoring, alerting, and tuning to help you get the most out of your servers – including servers that aren’t running SQL Server.

SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all.

Skilled SQL developers know that the SQL Server Query Optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself?