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 – 18:10 Sponsor Session.
18:10 – 19:10- First Session.
19:10 – 19:30 - Break. Time for pizza.
19:30 – 20:30 - Second Session.
20:30 – Feedback and Close and head for drinks down the pub
Using Python in SSMS - Pete Moore
Pete is a Data Scientist specialising in R, Python and SQL. He is founder of Look at your Data Ltd and available for freelance work*, you can view his CV here: https://bit.ly/2wuRQpH
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.
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 knew 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.
*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.