Tired of talking about theory and want to hear about real production SQL Server issues and the methods I used to troubleshoot them?
We’ll take a look at real performance problems from an actual Enterprise SQL Server environment. We will walk through the methods my team and I used to troubleshoot them, and show how we resolved some of our most challenging performance issues.
Methods that work in this kind of environment will work in any environment. You can apply these techniques whether your environment is small, medium, or large. You will learn to use the tools and methods we use to troubleshoot performance like execution plans, wait statistics, live query statistics, index analysis, and more. The issues we tackle problems like long blocking chains, contention on system tables in tempdb, queries that normally run fast but occasionally run really slow, and generally slow queries.
Save with early bird pricing until July 10th only $99.
Normal price is $129.
Securing SQL Server Processes with Certificates
You can also catch me on for the free day of training being offered on Saturday. I will be presenting a session on Securing SQL Server Processes with Certificates. Check out the description below. You can also preview the materials for this session on the SQLSaturday Columbus event site on the schedule page on directly from the session page (yes, slide deck and demo code is already uploaded).
What do you do if the DBA won’t let you enable the Trustworthy setting?
Things like Trustworthy and cross-database ownership chaining open up huge security threats. Fortunately, there’s a better way.
You can secure things like cross-database operations, service broker communication, and high-privileged stored procedure execution with certificates via a process call signing. Additionally things like CLR assemblies that need external access can be executed safely using signed assemblies instead of enabling Trustworthy.
This session will cover common processes that can be secured through certificate signing, show how to sign the processes, and cover some basics of certificate management.
Note: this session does not cover securing SQL Server connections with SSL or self-signed certificates.