Past Meetup

Data Platform User Group (Python, SQL, R)

This Meetup is past

55 people went

Location image of event venue

Details

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 / networking.
18:00 – 19:00 – Using Python in SSMS (Pete Moore)
19:00 – 19:20 – Break (food / drinks).
19:20 – 20:20 – Azure SQL DB migration readiness with Power BI (Steve Morgan)
20:20 – 20:30 – Feedback (via Microsoft forms) then off t’pub.

Using Python in SSMS
Using Python from the comfort of your own SQL Server Management Studio

The noise started far away: you need to learn Python, it whispered. We ignored it for a while because we could. Besides we were busy, busy architecting databases, busy writing T-SQL and busy learning all of the other stuff on the MS Data Platform. Real data. Then something happened: you could code Python from within SSMS. The whisper had become deafening. This was now part of T-SQL coding. This was us.

The Python had infiltrated our world, but what did it mean for us, the SQL folk? Did we need to up-skill? What now? Did we need new technology? Textbooks? New education?

Or could we just ignore it? This decade’s LINQ (sorry LINQ folks)? This talk tackles these questions by coaxing Python out of its natural environment and debating the pros and cons of: SQL vs Python, Native Python vs Python in SSMS; and, ultimately, why we might just be able to have the best of both worlds - all from the comfort of your own SQL Server Management Studio.

About Pete Moore
Pete is a Data Scientist specialising in R, Python, and SQL. He is the founder of Look at your Data Ltd and available for freelance work*, you can view his CV here: https://goo.gl/rvLhy1

Prior to Look at your Data, Pete was an IT Director.

He is a present-day student at the Data Science MSc at the University of Dundee.
*or permanent work, but it needs to be really, really good

Azure SQL DB migration readiness with Power BI

Working how ready your SQL estate is to migrate to one of the Azure SQL DB environments is a key decision point in the migration life cycle. In this session I'll be showing you how to use the Data Migration Assistant to interrogate your SQL estate and then present the results in a pre-built Power BI report.

About Steve Morgan
Steve Morgan has 20+ years’ experience as a data base engineer & architect with the last 15 focused on Data Warehousing, BI & Analytics. For a large part of that time he was an independent contractor working across many sectors and organisations usually in project recovery scenarios. In September 2017 he joined Microsoft as a Data Platform TSP (that’s Architect to you & me) where he helps customers in the Health Care sector navigate the Microsoft Data Platform technologies both on-premise and in Azure.