In the vast realm of the internet, where information leaps from one virtual lily pad to another, there exists a delightful niche that croaks louder than the rest – The frog blog! We thought we’d share our top 12 Frog Blogs of all time, from the people who wrote them – The Purple Frog Team.

 

Making the DAX Engine Work for You

Tom suggested checking out Joe’s blog, “Making the DAX Engine Work for You,” as you can gain insights into DAX and enhance your code efficiency.

You can read the full blog here

 

Excel crashes when enabling macros

Purple Frog Systems CEO Alex suggested his blog that was written 8 years ago, that we still use daily – “Excel crashes when enabling macros”. It’s also still among our top 10 most-viewed blogs!

You can read the full blog here

 

Azure Data Factory Pricing – How much is my pipeline actually costing me?

Chantal chose this blog by Nick E from a finance department point of view, she found this blog very helpful and thinks all companies should ask ‘how much is it costing me?’. Nick T also chose this blog, as our project manager, as it helps our clients run more effectively and save them money. It’s one of our aims as a company to support our clients the best that we can.

You can read the full blog here

 

How do I make a multi-line string in Python (so I can ctrl+C my SQL code)

Laura recommends a blog written by Lewis, “How do I make a multi-line string in Python (so I can ctrl+C my SQL code)” as its great for all Python developers using SQL.

You can read the full blog here

 

How the UNICHAR() DAX Function Enhances Power BI Reports

Joe picked a blog he wrote back in July 2021, which provides a way of adding visual enhancement to a Power BI report while being fun at the same time!

You can read the full blog here

 

Synapse Script Activity Error “Argument {0} is null or empty.\r\nParameter name: paraKey”

Callum picked a blog he wrote in November because the error message Synapse provides is useless and a distraction. This blog saves some time and is a nice simple solution. 

You can read the full blog here

 

Exploring the Benefits of Degree Apprenticeships

Annabel picked her blog about degree apprenticeships as wants to share alternative education routes in the UK

You can read the full blog here

 

Fabric Data Warehouse – ALTER TABLE workaround

You may be aware that the ALTER TABLE T-SQL command is currently not supported when working with data warehouses in Fabric. Which is why Jeet picked this blog as his go-to!

You can read the full blog here

 

My Jupyter Notebook Crashed and Now Won’t Open

Lewis wrote this blog a while back, and it makes a great reference if you get an ‘out of memory’ error message.

You can read the full blog here

 

Introduction to T-SQL Merge Basics.

Alex revisits his blog from 12 years ago on “Introduction to T-SQL Merge Basics.” Which also remains in our top 10 blogs of all time!

You can read the full blog here

 

Bonus!

We got 2 bonus submissions from James and Jon – How to manage relationships in Power BI Service! and How to delay a Python loop, which is each of their own most popular blogs!

 

Finally… Nick E’s favourite piece of code!

Not so much a blog, but Nick’s favorite piece of code when developing Power BI reports is a C# script executed in Tabular Editor to format all measures in your model at once. See below!

Nick E Favourite Piece of Code

 

Ready for a redo next year?