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

Thursday,

September

10

Parameter Sniffing and the Query Store in SQL Server 2016

Join us on Thursday, September 10 for the next meeting of the Louisville SQL Server Users Group! We will meet at the Humana Training Center in the Waterfront Plaza in downtown Louisville (10th Floor, East Tower).  We plan to have food arrive at 11:30am, with the meeting starting at 11:45am and ending at 1:00pm (our normal schedule).

We have TWO meeting sponsors this month – Redgate and our Silver sponsor Mirazon:

Founded in 1999, Redgate delivers over 40 tools to help database developers ship changes to their databases more often and more safely. With over 91% of Fortune 100 companies using their software, Redgate continues to focus on customer feedback, improve their tools, and provide world-class training through their SQL in the City training program. Visit http://www.red-gate.com.

Mirazon is a Louisville-based IT consulting company that specializes in Microsoft, storage, wireless and networking solutions. Mirazon’s architects, engineers and project managers are certified in a wide array of technologies, including: Microsoft, VMware, Citrix, Veeam, X-IO and DataCore storage, Cisco, Ruckus Wireless, Dell servers and networking, Fortinet firewalls, and many other solutions. Visit http://www.mirazon.com today!

Please come out for our September meeting, thank our sponsors, and learn about Parameter Sniffing and the Query Store in SQL Server 2016!!

Featured Presentation:

Parameter Sniffing and the Query Store in SQL Server 2016

Sreeni Julakanti, Enterprise DBA Humana, Inc.

Troubleshooting performance problem (particularly related to parameter sniffing) is one of the most challenging and most often faced situation in a DBA’s life. In SQL Server 2016, Microsoft has come up with an Interesting tool called the “Query Store”. The Query Store records everything about query compilations and execution statistics. It collects and presents detailed historic information about all queries in a simplified way and reduces the time required to diagnose and resolve issues faster, even allowing you to observe changes in query performance over time. In this presentation, I will provide an overview of the Query Store and discuss its features, benefits, and implementation.

About Sreeni:
Sreeni Julakanti is an Enterprise DBA at Humana, Inc., currently working in an Architect role while supporting over 16,000 databases on 1,500 different SQL Servers. He primarily works on troubleshooting performance Issues and fine tuning various database designs and processes. Sreeni holds an MCITP certification in SQL Server and is an active member of the Louisville SQL Users Group, participating in monthly meetings and presenting on topics including SQL Server Statistics and SQL Server Plan Cache Internals.