Laura-Jayne Adamson, Author at Purple Frog Systems

SQL Server vs Fabric Warehouse: T-SQL gotchas nobody warns you about
July 23^rd, 2026 in Blog, Data Warehouse, Fabric, Microsoft Fabric, SQL, SQL Server
Fabric Warehouse looks just like SQL Server. It uses T-SQL, has schemas, stored procs and more. Yet, you migrate your first proper workload and see “that’s not supported” errors you never had to think about before. Fabric Warehouse isn’t SQL Server. Under the bonnet it’s storing everything as Delta Parquet in OneLake, and that storage format shapes what T-SQL can and can’t do. Here’s what actually trips…
» Read more
Baking Up Better Data: Microsoft Fabric and the Fabric Toolbox
May 8^th, 2026 in Blog, Community, Data Factory, Data Warehouse, Fabric, Microsoft Fabric
Recently, I presented a talk at the Birmingham Data User Group, titled “Stop Hand-Whisking Your Data: Faster Fabric Development with the fabric-toolbox”. On the back of that, I wanted to summarise the talk into a blog and share how you can use fabric-toolbox to enhance your Fabric development. Data engineering can feel abstract. Layers upon layers of transformation, movement, and logic that are hard to visualise at a glance. So, when talking…
» Read more
Fabric Toolbox: A Helpful Resource for Exploring Fabric
March 5^th, 2026 in Blog, Community, Fabric, Microsoft Fabric
As Microsoft Fabric adoption grows, many businesses are starting to move beyond experimentation and into building production analytics platforms. However, implementing and managing a modern data platform still involves more than simply enabling the technology. To help teams get started and explore best practices, Microsoft and the wider community have introduced Fabric Toolbox, a collection of open source resources designed to support Microsoft…
» Read more
FabFest 2025: Running the Microsoft Fabric Clinic!
October 16^th, 2025 in Blog, Community, Data Lakehouse, Fabric, Microsoft Fabric, Power BI, Sponsoring Event
FabFest is a great community conference held in Birmingham, UK, that Purple Frog Systems has sponsored for the past 2 years. This year, we had the opportunity to host 2 clinics for attendees, where they could learn more about Microsoft Fabric or AI solutions, or troubleshoot issues currently faced in these areas. Why did we choose to run these clinics? At last year’s conference, we had several attendees approach us with questions about…
» Read more
Transform Your Data Strategy: Why You Should Migrate to Microsoft Fabric
March 24^th, 2025 in Blog, Fabric, Microsoft Fabric
Microsoft Fabric Migration offers several compelling benefits for organisations looking to enhance their data management and analytics capabilities 📊 Here are some key reasons why you should consider the transition: 1. Unified data ecosystem Microsoft Fabric consolidates diverse data toolsets into a single integrated service. This means you no longer need to juggle multiple tools and platforms. Fabric provides a comprehensive solution…
» Read more
Overcoming Direct Lake Connection Hurdles
January 7^th, 2025 in Blog, Data Lakehouse, Data Warehouse, Fabric, Microsoft Fabric, PowerBI
I love organising. When it comes to Microsoft Fabric, I am no different. The addition of files was a heaven-sent for me as I could finally clear up the clutter and make a Fabric solution user friendly to navigate. This allows my end users to access the correct information when they need it, quickly and accurately. Majority of the time, the end user does not need to access the Data Warehouse or Lakehouse that is storing their data, but rather the…
» Read more
Choosing Between DP-600 and DP-700 – Which Microsoft Fabric Certification is Right for You?
October 23^rd, 2024 in Blog, Fabric, Microsoft Fabric, Reference Guide
With the release of DP-700 into Beta this week, you may be looking to enhance your skill set further with one of the Microsoft certifications, DP-600 or DP-700. Both certifications are valuable when working with Fabric but cater to different career goals and expertise. In this post, we will break down the key differences in the exam, to help you decide which exam is best aligned DP-600: Fabric Analytics Engineer Associate The DP-600 is a great…
» Read more
Fabric Trials: The Countdown Is On
May 21^st, 2024 in Azure, Blog, Fabric, Power BI
We are drawing near to the end of Microsoft Fabric trials! ⌛ With the countdown ending mid-June for many trial capacities, it is important that you take measures to protect any Microsoft Fabric resources you have. Microsoft have informed users that once the trial ends, the capacity will be converted to a Power BI Premium capacity where Fabric items can no longer be used or stored. From here, you will have a 7 day retention period before all…
» Read more
Microsoft Fabric Mirroring: Quick Start Guide
April 17^th, 2024 in Blog, Data Factory, Data Warehouse, Fabric
Mirroring provides a modern approach to accessing and ingesting data continuously and seamlessly from any database or data warehouse into the Data Warehousing experience within Microsoft Fabric. Here are the key points about Mirroring: Near Real-Time Data Access: Mirroring allows users to access changes in the source data almost instantly. It ensures that the data in Fabric’s OneLake remains up-to-date without complex setup or manual…
» Read more
New Microsoft Fabric Features – A SQLBits and FabCon Round Up!
April 12^th, 2024 in Blog, Data Factory, Data Lakehouse, Data Warehouse, Fabric, Machine Learning, Real-time Data
March was a big month for Microsoft Fabric and its users as there were two major conferences discussing all aspects of Microsoft Fabric, from functionality to security and governance. SQLBits, a community conference, came first with a wealth of knowledge from experts using Microsoft Fabric from a beginner to experienced level. FabCon immediately followed, which was a conference from Microsoft to announce new features and to hear from those…
» Read more

Alex Whittles (MVP)
Annabel Hemingbrough
Callum Bryant
Hollie Whittles
James Snow
Jeet Kainth
Joe Billingham
Jon Fletcher
Laura Adamson
Lewis Prince (MVP)
Matt Mair-Durrant
Nick Edwards
Tom Owen