A promotional image featuring a person wearing a Purple Frog-branded polo shirt standing in front of a purple background with geometric hexagon patterns and an image of hands typing on a laptop. To the right, bold white text reads, “Wait, does ChatGPT actually think it’s 2024?”

Why does AI sometimes sound like it is stuck in 2024? 🤖

In her #FrogBlog, Annabel explains knowledge cutoffs, why models cannot update daily, and how tools use web search to answer current questions.

↘️ www.purplefrogsystems.com/2026/03/wait... #ArtificialIntelligence #GenAI #ChatGPT

A Purple Frog promotional graphic with a purple background featuring digital and AI-themed icons. A circular photo appears at the top left. The main white text reads, “The difference between using AI and integrating it.” Below, orange text says, “Frog Blog | Lewis Prince.” Additional text explains that using AI tools is not the same as integrating AI into business operations, highlighting the need for strong data foundations, governance, modelling capability, and measurable business outcomes. A small “Dismiss” button with an orange X appears in the top right corner of the content box.

Is AI literacy being confused with AI transformation? 🤖

In this week’s #FrogBlog, Lewis explains why real AI adoption requires data foundations, governance, and measurable value, not just better prompts.

🔗 www.purplefrogsystems.com/2026/02/the-... #ArtificialIntelligence #AIAdoption #DataStrategy

Fabric Warehouse Case Insensitive: Workspace Setting Guide Learn how to make a Microsoft Fabric Warehouse case insensitive using Workspace settings. Align Fabric with Azure SQL and avoid query errors

If CustomerID ≠ customerid, your #MicrosoftFabric Warehouse is case sensitive⚙️

In this week’s #FrogBlog, James explains how to configure case insensitive collation at the Workspace level and why it prevents query errors and #PowerBI issues.

🐸 Read it here:

A promotional graphic with a purple background titled “Wait, does ChatGPT actually think it’s 2024?” in large white text. Below, orange text reads “Frog Blog | Annabel Hemingbrough.” A paragraph explains why generative AI tools can appear outdated due to training data limitations and the need for retrieval‑augmented generation. The lower portion shows a laptop screen displaying the ChatGPT interface. At the bottom is an orange “Frog Blog” button and a tagline: “Using Data Analytics and Business Intelligence to transform your business.”

Ever asked #ChatGPT something recent and it answers like it is still 2024? 🤖

That is because of knowledge cutoffs.

In her #FrogBlog, Annabel explains why #AI models rely on older training data and how tools like RAG fetch current information.

👇️ Read more:
www.purplefrogsystems.com/2026/03/wait...

The Difference Between Using AI and Integrating It - Purple Frog Systems Enter, The Conflation Problem There is a growing issue in the AI space. Many talks marketed as “AI strategy” are, in reality, basic training sessions on prompt writing, ChatGPT usage, or Copilot for…

Using #AI tools is not the same as integrating AI🚫🤖

Prompt training and #Copilot workshops build digital literacy. They do not replace data engineering, modelling, governance, or measurable ROI.

Lewis explains the difference in his #FrogBlog.

A purple graphic promoting a Microsoft Fabric Warehouse guide. The title reads “Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide.” Below it, an orange subtitle says “Power BI Developer | James Snow.” On the left is a circular photo of a person. To the right, white text explains the purpose of setting a Microsoft Fabric Warehouse to case‑insensitive at the workspace level to avoid query errors caused by capitalization differences such as “CustomerID” versus “customerid,” and notes that configuring this early ensures more consistent development and avoids issues with joins, queries, and reporting in Power BI.

A small #MicrosoftFabric setting can save hours of troubleshooting⚙️

In this #FrogBlog, James shows why configuring a case insensitive Warehouse improves query reliability and development consistency. Set it right BEFORE building your data platform.

🔗 www.purplefrogsystems.com/2026/02/micr...

Blank rows breaking your #PowerBI visuals?

Callum shares a DAX trick to fill gaps with the last known value in his latest #FrogBlog. This is ideal for tracking daily metrics like membership counts.

Problem solved.

🔗 www.purplefrogsystems.com/2025/09/fill...

Blog Archives - Purple Frog Systems Most databases need a server. DuckDB doesn’t. It’s a zero‑config, in‑process OLAP database you can run directly using Python. It’s fast, SQL‑friendly, and speaks Parquet like a native language — no…

Looking for some great reads? We love the Purple Frog Systems #FrogBlog, packed with great insights on all things data and tech! 🐸

A fantastic resource for the community. #DataCommunity

➡️ Check it out:

You’ve used ROW_NUMBER()—but have you ever restarted it mid-window?
Jeet shows how to do exactly that with a clean CTE-based approach.

📚 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...

#SQL #SQLServer #Coding #FrogBlog

Think ROW_NUMBER() can’t be dynamic? Think again.

Jeet resets it across renewal chains using CTEs and partitioning magic.

✨ Read the #FrogBlog by Jeet!🐸

www.purplefrogsystems.com/2025/07/rese...

#SQL #DataEngineering

Want to track customer renewals in SQL and reset row numbers by group?🤔

Jeet’s blog breaks it down beautifully using CTEs and partition logic📚

🧩 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...

#SQL #Analytics #FrogBlog

ROW_NUMBER() is powerful — but resetting it based on logic?
That’s next-level📈

Jeet explains how to group and renumber subscriptions step by step📝

🧪 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...
#SQL #FrogBlog #Analytics

Why did the Python developer get stuck in a loop? 🔁
They forgot how to slice a list properly.

Jon's new post will fix that, and more.

🐸 www.purplefrogsystems.com/2025/07/pyth... #Python #Coding #FrogBlog

🐍 Learning Python? Lists are one of the first (and most important) data structures to master.

Our consultant Jon just dropped a blog post covering everything you need to know 👉

🔗 www.purplefrogsystems.com/2025/07/pyth... #Python #Code #FrogBlog

Variable Libraries In Microsoft Fabric, In Preview! - Purple Frog Systems How variable libraries in Microsoft Fabric can enhance your CI/CD processes by ensuring consistency & efficiency in your teams process

Maximise efficiency in Microsoft Fabric!📈

James' new #FrogBlog post explains #VariableLibraries and how they can seriously improve your workflow. Don't miss it!📚️

📰Read the full blog:

Tired of writing the same code snippets over and over in #MicrosoftFabric?🥱

James' latest #FrogBlog has the answer: Variable Libraries!⬇️
Discover how to centralise and reuse variables for cleaner, more efficient solutions.

🐸 Dive in: www.purplefrogsystems.com/2025/06/maxi...

In his latest #FrogBlog, Lewis shares his first-hand experience navigating the #AI buzz at @SQLBits, the standout sessions, and what it all means for the future of data.

📖 Read: "SQLBits 2025: The Year You Couldn’t Escape AI"

👉 www.purplefrogsystems.com/2025/07/sqlb...

Croaking about our latest #FrogBlog! 🐸

Lewis' Frog Blog just dropped "10 Ways #SmallBusinesses Can Use #AI Today." If you're a #SmallBusiness looking to integrate #AI, this is a must-read!

Practical tips to get you started now👇
www.purplefrogsystems.com/2025/06/10-w...

Data Factory pipeline failure with a "null" error message - Purple Frog Systems Have you ever had this error when running a pipeline in ADF or Synapse? I have now seen this more than once and it can be frustrating to debug the issue. After trying a few different setups in…

Debugging ADF/Synapse pipelines?
If you see a "null" error, check for:

✅ An Until inside an If Condition
✅ A nested ForEach
✅ A parameter name with “-”

#MIcrosoftFabric provides clearer errors
🐸Learn more on the #FrogBlog:

New #FrogBlog alert! 🚨 James dives into the power of Variable Libraries in Microsoft Fabric. If you want to cut down on redundant code and boost productivity, this is a must-read.

Go check it out! 👇 #MicrosoftFabric
🔗 Link: www.purplefrogsystems.com/2025/06/maxi...

Struggling with repetitive code in #MicrosoftFabric?🐸

James' #FrogBlog post reveals how Variable Libraries can revolutionise efficiency! Learn to maximise reusability and streamline development.

Read it here⬇️
www.purplefrogsystems.com/2025/06/maxi... #DataEngineering

Save time in #PowerBI!⏱️
⏭️Skip the Publish button.

💾Save to OneDrive or SharePoint, and updates sync automatically.

Joe shares how in his latest #FrogBlog on the topic!
www.purplefrogsystems.com/2025/03/stop...

Stop Pressing Publish in Power BI - OneDrive or Sharepoint can do that for you - Purple Frog Systems If you’re still using the Publish button in Power BI Desktop, there’s a better and more efficient way to manage your reports while saving time.

Still clicking "Publish" in #PowerBI?🖱️
There's a better way, and Joe's showing you how⬇️

#OneDrive and #SharePoint can handle updates for you. No manual publishing is needed.

🐸Learn more from the #FrogBlog:

Have you thought about migrating to #MicrosoftFabric?🔄

In this #FrogBlog, Laura-Jayne is running through why you should migrate to #Microsoft #Fabric!

Take a read 👉️ www.purplefrogsystems.com/2025/03/tran...

Work smarter in Power BI...📈

Automate report updates with #OneDrive & #SharePoint.
💯No more publishing, no more hassle.

🐸Learn how in Joe's latest #FrogBlog:
t.co/mVzZMZzKHm

Pipeline fails with "null" error" in ADF/Synapse?😰

Jeet uncovers why & how #MicrosoftFabric helps fix it!
Don’t waste hours debugging.

🐸Read more here on the #FrogBlog: www.purplefrogsystems.com/2025/03/data...

Still clicking "Publish" in Power BI?🖱️

There's a better way💯

#OneDrive and #SharePoint can handle updates for you. No manual publishing is needed.

🐸Learn more from Joe's #FrogBlog:

💜 www.purplefrogsystems.com/2025/03/stop...

Debugging ADF/Synapse pipelines?
If you see a "null" error, check for:

✅ An Until inside an If Condition
✅ A nested ForEach
✅ A parameter name with “-”

#MIcrosoftFabric provides clearer errors
🐸Learn more on the #FrogBlog: www.purplefrogsystems.com/2025/03/data...

🤯 The wait is over!

Dynamic execution of Fabric pipelines is finally here! 🎉

Nick dives into the new Invoke Pipeline (Preview) activity and how it changes the game in his latest #FrogBlog.

Read more:
🔗 https://buff.ly/4goPj4h
#Azure #Fabric #MicrosoftFabric #DataEngineering

Great talk by @holliewhittles.bsky.social today on marketing with the British Business Bank and Marches Growth Hub!👏

You can even read all about over on our #FrogBlog!
🐸 www.purplefrogsystems.com/2025/01/new-...

#Marketing #Audience #TargetAudience