Manchester SQL Server User Group

Manchester (UK) SQL Server User Group

Network, learn, ask a question, meet fellow SQL Server Professionals and have some pizza - these are all things that happen at 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.

For details of all up and coming meetings and to register for events, please see our Meetup page here https://www.meetup.com/Manchester-SQL-Server-Meetup/

Follow us on  Twitter manssug or Facebook Manchester User Group

Next Meeting: Wed, Oct 19 2016

Manchester Pass Chapter

Register Here : https://www.eventbrite.co.uk/e/pass-manchester-sql-server-user-group-19th-october-2016-tickets-27663092053?aff=eac2

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

 

 

Session 1

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

Summary:

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 an overview 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.

 

Session 2

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.



 

Attachments

PASSChapterLogo.jpg

sql_micro_sm.gif

 rg-logo.png

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