Actions and Detail Panel
PASS Manchester SQL Server User Group - 19th October 2016
Wed 19 October 2016, 17:30 – 21:00 BST
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at PASS Chapter 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 – 18:30 Round Table discussion and Nuggets - ALL Take stock and get the latest news in the SQL Server and Azure Data Platform field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.
18:30 - 19:30 - First Session.
19:30 - 19:50 - Break. Time for pizza.
19:50 - 20:50 - Second Session.
20:50 - 21:00 - Feedback, Prize Draw and Close.
Finally: Drinks down the pub
Twitter, Cloud and Power BI walked into a bar. The bartender looks up and says “I don’t have time for your Dashboard.”
Speaker: Ian Pike
A review of a PoC I’ve been working on around Customer Sentiment analysis using Twitter, SSIS and Power BI. I’ll walk through the background of the PoC, the tools I used and the tips and tricks learnt along the way.
I’ll be creating a Power BI Dashboard and some insights of using this technology. Giving anoverview of the Twitter API, the data storage and processing, also the ways to get sentiment score. This is all done in Azure and how this can help you innovate and become a “disruptive” influence in your company.
About Ian: Ian is a Database Specialist Tech Lead at Swinton Group. Ian has over 20 years’ experience in developing, architecting and implementing database solutions. He specialises in data and SQL Server solutions and is currently investigating Azure and cloud adoption. Ian also loves developing anything related to SSIS, SSDT and Power BI.
A regular SQL community attendee and supporter, but new in the field of speaking.
Tune the query, not the plan
Speaker Kevan Riley
Summary: Execution plans are a great resource when trying to tune a query, but often we get hung up on trying to fix what we consider to be 'bad' operators, for example table scans vs clustered index scans; scans vs seeks; sort operations. In this session we will take a look at some misconceptions, step through what SQL Server is doing and see if we are actually improving the performance when change the plan to have 'better' operators.
About Kevan: Kevan Riley (MCSE:Data Platform) has been working with SQL Server since 1999 in a variety of DBA and DB developer roles. He now works as a freelance SQL Server Consultant in the UK and is no more happier than when knee-deep in performance tuning. He can be often found contributing at ask.sqlservercentral.com and getting involved with the SQL community at UK user groups, SQL Saturdays, SQLBits and SQL Relay.
Date and Time
58 Whitworth Street