Richard Swinbank
banner
richardswinbank.net
Richard Swinbank
@richardswinbank.net
Data Engineering, DataOps, Business Intelligence | Data Engineer | Author | CompSci PhD | He/him
Why, thank you #Microsoft, thank you @justrie.bsky.social! #mvpbuzz
April 16, 2025 at 5:43 PM
How Spark pushed me down a well 😄 - my contribution to this month's #tsql2sday: https://richardswinbank.net/spark/two-aggregate-pivot
February 17, 2025 at 9:33 PM
Excited, delighted,... ignited(?) – I'm so happy to have been renewed for another year as a Microsoft Data Platform MVP that I'm running out of adjectives! Super-pleased to remain in the company of some very skilled people. Thank you @Microsoft, MVP Program & @IrishSQL! #MVPBuzz
February 17, 2025 at 9:33 PM
Excited, delighted,... ignited(?) – I'm so happy to have been renewed for another year as a Microsoft Data Platform MVP that I'm running out of adjectives! Super-pleased to remain in the company of some very skilled people. Thank you @Microsoft, MVP Program & @IrishSQL! #MVPBuzz
February 17, 2025 at 9:33 PM
Super-excited to announce that the second edition of my book "Azure DataFactory by Example" is now available! 🎉 You can find it at https://buff.ly/490TwYJ (US) or https://buff.ly/43IEmWA (UK) and probably some other places too 😊 #Azure #DataFactory @AzDataFactory
February 17, 2025 at 9:33 PM
Delighted to receive this box of swag from @microsoft after being unable to attend #MVPSummit in person -- thank you 😊. Pablo says thanks for the box! #mvpbuzz
February 17, 2025 at 9:33 PM
Day 3 at this year’s aviation-themed #sqlbits! Sun’s out, (top) guns out 😎
February 17, 2025 at 9:33 PM
I'm delighted to announce that the 2nd edition of my book Azure Data Factory by Example will be released on April 7th 2024 😊. Available for pre-order right now at https://buff.ly/490TwYJ (https://buff.ly/4914Xjb in the UK), perfect for those (very) late Christmas presents... 🎅
February 17, 2025 at 9:33 PM
Hey @PenguinBooks I’m racing through @richardosman’s Thursday Murder Club, even without your unexpected assistance! Can you help?
February 17, 2025 at 9:33 PM
OK, so *apart* from the chance to network with great people, eat a free lunch, meet the experts and get a whole day of free #Microsoft #DataPlatform training... what has @DataRelay_uk ever done for us?!
February 17, 2025 at 9:38 PM
Time for more @MSPowerBI deployment! In this post, I accelerate creation of new reports by building their deployment pipelines automatically 🚀. Create your report, push it to Git, see it appear in #PowerBI 😀 https://buff.ly/3PYJBwt
February 17, 2025 at 9:38 PM
Super-excited to report that I've been awarded #Microsoft #DataPlatform #MVP for 2023/4 🎉. Working in this community with so many skilled, committed colleagues is a privilege I'm abundantly grateful for, and this is the icing on that large, delicious cake 😊🎂 @MVPAward #MVPBuzz
February 17, 2025 at 9:38 PM
Communicating technical complexity to non-technical colleagues can be tough -- but it's essential if you want to explain why you're going to need 6 months to build a report 😂. Feel free to use my one-slide explainer if it helps! https://buff.ly/46iMH4f
February 17, 2025 at 9:38 PM
In my new blog post I look at how to deploy standalone/shared @MSPowerBI datasets through multiple environments, and how to bind thin reports to different source datasets automatically during deployment 😊 https://buff.ly/45JtrfV #PowerBI
February 17, 2025 at 9:38 PM
One of my favourite features of Azure #DevOps pipelines is reusability -- in this blog post I simplify @MSPowerBI report deployment using reusable YAML templates https://buff.ly/3nI4FLV #PowerBI
February 17, 2025 at 9:38 PM
More @MSPowerBI & Azure #DevOps! In this post, I'm using Azure DevOps pipelines to deploy to multiple #PowerBI environments -- automatically 😃 https://buff.ly/3nI4FLV
February 17, 2025 at 9:38 PM
Version controlling a @MSPowerBI PBIX file along with all its data can be problematic, for reasons of both size and privacy 🔏. In this post https://buff.ly/3NvFiaT I look at managing #PowerBI datasets separately, without data, and deploying them using Azure #DevOps pipelines!
February 17, 2025 at 9:38 PM
After deploying an obsolete version of a buggy @MSPowerBI report to the wrong workspace, I realised it wasn't the report I meant anyway 😒. Time to invite #DevOps to this party. https://buff.ly/3UkHROg #PowerBI
February 17, 2025 at 9:38 PM
Wish you were volunteering at @SQLBits? Sign up at [email protected]! Blood not required.
February 17, 2025 at 9:43 PM
Delighted to see my blog posts on Automated Testing for Azure #DataFactory https://buff.ly/3ZOxlkl referenced in Microsoft's How-to guide on Managing ADF with #DataOps https://buff.ly/3YSdmjj 😊. @AzDataFactory
February 17, 2025 at 9:43 PM
Er, anything we should know @Azure_Synapse? 😊 #azuresynapse
February 17, 2025 at 9:43 PM
This month's T-SQL Tuesday #tsql2sday is all about dynamic SQL. Here's my contribution: a whistle-stop tour through some ETL object generation from metadata -- writing SQL code that writes SQL code! https://buff.ly/3RWDUMF
February 17, 2025 at 9:43 PM
Just cleaning up after Data Relay 2022 @DataRelay_uk. Looking forward to 2023 already 😊 #datarelay #datalaundry
February 17, 2025 at 9:43 PM
New blog post -- fixing the inscrutable "Argument {0} is null or empty. Parameter name: paraKey" in #Azure #DataFactory. https://buff.ly/3yCasnF
February 17, 2025 at 9:43 PM
So yesterday I received this hoodie -- and today I've found out I'm allowed to wear it for another year 😊. Thanks @MVPAward, @IrishSQL, @ClaireS_MS, delighted to be a part of this amazing community! #MVPBuzz
February 17, 2025 at 9:43 PM