Welcome!

Welcome to the Louisville SQL Server Users Group! We represent the SQL Server community in Louisville, the surrounding metropolitan area, and throughout most of Kentucky. As a technical users group, we focus on monthly meetings, but also provide networking, learning opportunities, speaking opportunities, training, and collaboration for SQL Server professionals throughout the Ohio Valley area. Our monthly meetings occur on the second Thursday of each month, either at lunchtime in the downtown Louisville area or in the evening outside downtown. This alternating approach to meeting times and locations allows us to support as many of our users as possible and provides different venue and time options for our meetings and our attendees. We also partner with various volunteer groups to bring special events to the area, such as SQL Saturdays. Those events typically draw large crowds of SQL Server professionals from Kentucky, Ohio, Indiana, Tennessee, and beyond!

 

Next Meeting

Tuesday,

July

25

Kevin Kline #sqlvacation

Kevin Kline will be joining us for a special meeting of the Louisville SQL Server & Power BI user group!!  

Agenda:

10:30AM -11:30AM: End-to-End Troubleshooting for SQL Server
11:30AM - 12:00PM: Break/Lunch 
12:00PM - 1:00PM: Four Ways We Kill the SQL Server Plan Cache

Session 1 - End-to-End Troubleshooting for SQL Server

Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

  • XEvents, Profiler/Traces, and PerfMon
  • Using Dynamic Management Views (DMVs)
  • Advanced Diagnostics Using Wait Stats
  • Reading SQL Server execution plan

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.

Session 2 - Four Ways We Kill the SQL Server Plan Cache

Abstract: SQL Server’s plan cache is one of the largest regions of memory and is used to store all SQL queries and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of queries you write and the way you invoke those queries can have an enormous impact on how the plan cache is maintained, tuned, and optimized. If you don’t do things right, you could end up shooting yourself in the foot and making performance much worse. Attend this demo-loaded session to learn about 4 harmful anti-patterns that developers frequently use without knowing their drawbacks.

This session will answer questions like:

  • What’s currently in the plan cache?
  • How often is the code in my plan cache being reused?
  • Where are the big opportunities to save space in the plan cache?
  • What coding techniques are most likely to make my object recompile unnecessarily or cause SQL Server to cache inefficient query plans?

There are a short list of mistakes that, if you know of them in advance, will make your life as a database developer much easier. Learn to avoid these four harmful anti-patterns which can slow down the plan cache. Learn how to see what is in your SQL Server’s plan cache and how it is behaving. And embrace these recommended techniques to repair poorly performing queries or entirely avoid them in the first place.

Featured Presentation:

Multiple Sessions

Kevin Kline, Principal Program Manager SentryOne

Kevin Kline will be joining us for a special meeting of the Louisville SQL Server & Power BI user group!! Agenda: 10:30AM -11:30AM: End-to-End Troubleshooting for SQL Server 11:30AM - 12:00PM: Break/Lunch 12:00PM - 1:00PM: Four Ways We Kill the SQL Server Plan Cache Session 1 - End-to-End Troubleshooting for SQL Server Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including: XEvents, Profiler/Traces, and PerfMon Using Dynamic Management Views (DMVs) Advanced Diagnostics Using Wait Stats Reading SQL Server execution plan Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it. Session 2 - Four Ways We Kill the SQL Server Plan Cache Abstract: SQL Server’s plan cache is one of the largest regions of memory and is used to store all SQL queries and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of queries you write and the way you invoke those queries can have an enormous impact on how the plan cache is maintained, tuned, and optimized. If you don’t do things right, you could end up shooting yourself in the foot and making performance much worse. Attend this demo-loaded session to learn about 4 harmful anti-patterns that developers frequently use without knowing their drawbacks. This session will answer questions like: What’s currently in the plan cache? How often is the code in my plan cache being reused? Where are the big opportunities to save space in the plan cache? What coding techniques are most likely to make my object recompile unnecessarily or cause SQL Server to cache inefficient query plans? There are a short list of mistakes that, if you know of them in advance, will make your life as a database developer much easier. Learn to avoid these four harmful anti-patterns which can slow down the plan cache. Learn how to see what is in your SQL Server’s plan cache and how it is behaving. And embrace these recommended techniques to repair poorly performing queries or entirely avoid them in the first place.

About Kevin:
Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.