#FrogBlog
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:
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…
www.purplefrogsystems.com
August 22, 2025 at 6:05 PM
Frog blog🐸 is hibernating for the season..
#frogblog🐸 #harvardMA #wetlands #ecology #tinybeauty
November 8, 2025 at 5:07 AM
I miss Frogblog too. In fact, I miss the 2000s in general. As a retired blogger, I'd suggest Substack.
January 25, 2025 at 5:21 AM
Frogblog was on Wordpress.
January 25, 2025 at 5:17 AM
You guys think you have it bad, the platforms I've been successful on historically: Facebook, Large Facebook Groups as Admin, FrogBlog on Tumblr (which I lost in a breakup), and the #beard tag on tumblr where I I would do numbers because at that point other white men had yet to discover beard taper
March 24, 2026 at 1:09 AM
SQL isn't the only way to query your data👀

In his #FrogBlog, Matt shows how querying your #PowerBI semantic model with #DAX helps you reuse trusted business logic, reduce duplicated work, and keep everyone working from the same numbers.

Read more🐸✅
www.purplefrogsystems.com/2026/06/ther...
July 7, 2026 at 11:11 AM
AI token costs can spiral faster than most teams expect 🤖💸

In his #FrogBlog, Lewis shares practical ways to control #AzureFoundry costs before they become a problem, including #TPM limits, #Azure Monitor alerts, #token logging, and optimisation.

Read here👇
How to control Azure Foundry token costs before they control you - Purple Frog Systems
Token costs in production can surprise you fast. That’s especially true with agentic workloads, where a single user action can fan out into five, ten, or more LLM calls under the hood. Without…
www.purplefrogsystems.com
May 27, 2026 at 11:11 AM
Enterprise AI without context is just guesswork🤖

In this week’s #FrogBlog, Alex explains #MicrosoftIQ and how it enables context-aware AI across data, knowledge, and workflows.

📰 Read the #FrogBlog here:
www.purplefrogsystems.com/2026/03/what...

#AI #MicrosoftFabric #DataStrategy #Analytics
April 2, 2026 at 3:19 PM
#MicrosoftFabric is evolving into an enterprise intelligence layer📈

At #FabCon 2026, #Microsoft revealed major updates across AI, data engineering, and financial planning.

🐸Read the #FrogBlog:
Microsoft Fabric FabCon 2026 announcements that will transform your data stack - Purple Frog Systems
What Microsoft just revealed about the future of enterprise analytics… Microsoft’s FabCon 2026 conference unveiled a transformative vision for enterprise data and AI integration. Rather than…
www.purplefrogsystems.com
April 1, 2026 at 11:11 AM
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
March 18, 2026 at 4:19 PM
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
March 17, 2026 at 12:11 PM
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:
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
www.purplefrogsystems.com
March 16, 2026 at 12:11 PM
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...
March 13, 2026 at 12:11 PM
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.
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…
www.purplefrogsystems.com
March 12, 2026 at 12:11 PM
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...
March 11, 2026 at 4:19 PM
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...
September 15, 2025 at 3:25 PM
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
August 22, 2025 at 11:11 AM
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
August 20, 2025 at 11:11 AM
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
August 15, 2025 at 3:19 PM
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
August 11, 2025 at 11:11 AM
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
July 27, 2025 at 3:19 PM
🐍 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
July 26, 2025 at 11:11 AM
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:
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
www.purplefrogsystems.com
July 13, 2025 at 3:19 PM
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...
July 7, 2025 at 3:19 PM
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...
July 3, 2025 at 5:04 PM