Louisville SQL Server and Power BI User Group

Welcome to the Louisville SQL Server & Power BI Users Group!

Our group is generally made up of folks that hail from the Derby City and surrounding Ohio River Valley area, who all have a passion for Microsoft SQL Server and the technologies that surround it. 

We are a diverse group with skills ranging from "accidental DBA's" to senior administrators, seasoned developers to big data analysts and all of the other backgrounds that fall in between.

Do you love to learn? 

Do you love sharing what you know about the complex challenges of working with SQL Server?

Then come join us, and make yourself at home.  

 

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.

Supplementary Materials

The following event attachments are available to you:

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids