PASS Manchester Data Platform User Group

Network, learn, ask a question, meet other folk, get fed - these are all things that happen at PASS user group events. These events are a really great opportunity to socialise in an informal learning experience.

Remember to tell your friends and the people you work with; make sure you register as soon as you can.

17.30 – 18:00 Registration and networking

18:00 – 19:00 Erin Stellato - Plan Stability through Plan Forcing with Query Store

Intermittent performance issues due to parameter-sensitive queries are a DBA's nemesis. By the time you're notified of an issue, sometimes it's gone away...or someone else has restarted the instance or cleared the plan cache, and any data you could use is gone. Capturing the different plans for those queries can be tricky, but with Query Store it becomes very simple - the hard part is deciding what plan you like best. The Query Store feature, introduced in SQL Server 2016 and also available in Azure SQL Database, captures query performance data, and it allows you to manually force a plan for a query. In SQL Server 2017 and Azure SQL DB, the Automatic Plan Correction feature will force plans for you. Sound scary? It's not. In this session we'll explore both manual and automatic plan forcing through demos so you understand how it works, what to expect, and what to watch out for when you implement it in your environment.

About Erin - SQLskills Principal Consultant

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Email: Erin@SQLskills.com
Website: http://www.SQLskills.com
Full Bio: http://www.sqlskills.com/about/erin-stellato/
Blog: http://www.SQLskills.com/blogs/Erin
Twitter: http://twitter.com/ErinStellato
SQL Server MVP since 2012

19:00 – 19:30 - Break. Time for pizza.

19:30 – 20:30 - Chris Adkin - Kubernetes For The Microsoft Data Platform Professional

With the announcement of SQL Server 2019 Big Data Clusters, Kubernetes is entering the world of the Microsoft data platform professional. This is a container orchestration framework, but what does this mean, why do you need this and what do you need to be aware of when using this new platform, attend this session to find all of this out.

20:30 – Feedback and Close and head for drinks down the pub