Ask SQL Family - SQL Player's show

ASF 020: Pawel Potasinski interview

Do you know which conference was inspired by the SQLBits conference?How to make a success as a team at work?What’s important in your public speaking?CTO at Clouds On Mars, former Microsoft employee as Data Insights Product Manager for Poland. In 2007 Pawel started Polish SQL Server User Group (PLSSUG), currently known as Data Community Poland, an official PASS Chapter in Poland. Pawel has been a speaker at many conferences in Poland and worldwide (e.g. SQLDay, SQLSaturday, European PASS Conference). Six times Microsoft Most Valuable Professional (MVP). Father of three. Avid runner.This talk has taken place during SQL Saturday #824 in Krakow (Poland) on 9th February 2019 (Saturday).Interviewers: Kamil Nowinski, Michał Sadowski.

ASF 019: Simon Whiteley interview

How many bicycles he has got at home and where was the destination of last year of a 400 km trip? Which tool among Azure is the closest to his soul? What exactly is hiding behind the term "Modern Data Warehouse"? When Azure Data Factory (Mapping) Data Flow will be publicly available? Also, we will try to answer the fundamental question: is the SSIS dead or alive? Find out the answers on these questions and much, much more.As Chief Cloud Architect with Adatis Consulting, Simon Whiteley has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Most recently, he has turned his head to the clouds, advocating new methods of getting insight to the right people. Whether it's automating file ingestion into Azure Data Lakes, applying massive compute via SQLDW & Data Lake Analytics, or simply shifting your current SSIS packages into the cloud, he can help. Big believer in the wider data community - Regularly present on cloud analytics architectures and runs the SQL Surrey PASS chapter & co-organises the London PASS Chapter. Simon is a strong advocate of the use of modern development practices in the SQL World. Data Geek, Cloud Herder, Speaker, Cyclist, Microsoft Data Platform MVP and general Tech-Nerd.This talk has taken place after London SQL Server User Group meeting in London (UK), CodeNode on 29th January 2019 (Tuesday). Interviewer: Kamil Nowinski.

ASF 018: Mladen Prajdic interview

How many people do live in our guest's country? What can give you a valuable perspective? How can you convince your boss to upgrade SQL Server to a newer/latest version on enterprise platform?Mladen Prajdić is a Data Platform MVP from Slovenia. He's been professionally programming for over 15 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performance and IoT applications. He's a regular speaker at various conferences and user-group meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).This talk has taken place during SQL Saturday #782 Slovenia conference in Ljubljana, on 8th December 2018 (Saturday).Interviewers: Kamil Nowinski & Michal Sadowski.

ASF 017: Alex Whittles interview

Which unusual mean of transportation Alex use from time to time? Why monitoring of data quality does matter and what is the very efficient contrary of SCD in SSIS in BI loading process? Which skill is important if you want to jump into the IT market?Find out the answers on these questions and much, much more.Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.Alex has an MSc (Master of Science) in Business Intelligence, is a chartered engineer, and a member of Mensa. Community leadership includes being on the SQLBits committee, Director of SQL Relay, founder and leader of the Birmingham Data Platform user group.Alex is also a regular speaker at many SQL Server events around the world including SQL Relay, SQLBits, SQL Saturdays, 24 HOP and the PASS Summit.This talk has taken place during Data Relay (formerly SQL Relay) conference in Reading (UK), on 11th October 2018 (Thursday). Interviewers: Kamil Nowinski.

ASF 016: Chris Webb interview

How did Chris Webb start working with SSAS? What is the future of SSAS On-Premise? How often the Direct Query has chance to being used in Power BI? What was the story of the beginnings of Chris' consultancy company?Check these things and much more in this episode. Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in general. He has been blogging about Microsoft BI for over 10 years, and racked up over 1000 posts on his blog! Also he speaks at a number of conferences including SQLBits, the PASS Summit, the PASS BA Conference, SQL Saturdays and user groups.The author of "Power Query for Power BI and Excel", a co-author of few other books and also he co-authored the white paper "Planning a Power BI Enterprise Deployment" for Microsoft.This talk has taken place during Data Relay (formerly SQL Relay) conference in Birmingham (UK), on 10th October 2018 (Wednesday).Interviewers: Kamil Nowinski.