Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

New version of AxioWorks SQList released (

A new version of AxioWorks SQList is out today!

It’s been a while since we released a new version, it was back in April 2020 and a lot has happened since! (and not much of it was good…)

Anyways, here we are, version is out, let’s take a look at what comes with it.

AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BI, Crystal Reports, or SSRS.

Thousands of lists? No problem!

Firstly, we have fixed an issue that had been bugging us (and, even more, some of our customers) for some time. SQList Manager (the UI you use to configure SQList replications) was not handling well setting up replications of sites with thousands of SharePoint lists to SQL Server. More precisely, in the tree view, when you expanded a site with a few thousand lists the UI would freeze for quite some time until all nodes of the tree were loaded.

We have fixed this now, setting up a replication of thousands of lists is no longer a problem!

Computer says throttling…

Another thing we changed is the way SQList handles SharePoint Online throttling. Do you know what that is? Throttling is when SharePoint Online limits the number of user actions or concurrent calls, to prevent overuse of resources.

To avoid being throttled, SQList used to have a fixed delay between connections. This approach works in cases when throttling is rare, but when you replicate a few thousand lists you get to the point where “computer says no” quite often and waiting a fixed amount simply doesn’t cut it.

The way we deal with it now is very simple, we ask SharePoint: “how long do you want me to wait until I can try again?” Then wait for as long as the boss says.

Find that event log entry!

Then, a very very cool and well overdue addition! We added a filter to the event log so that you can filter or search exactly what you want to see. How many times we needed to look for events related to a specific list or filter only certain types of events and the only way was…there was no way! Well, now there is.

Finally, a few things hardly worth mentioning, like:

  • a small fix to the way tooltips are displayed;
  • clean up some code so that memory is not wasted
  • and a couple of tweaks to the UI.

As always, a big thank you to those who gave us feedback and suggestions. Feedback from the real world is invaluable and we really appreciate it.

If you would like to read all the details about this release and download it, head over to the support article here: What is new in SQList ver.

Please ensure that you read the SQList Upgrade notes of all versions of SQList between your current one and the latest, as there may be breaking changes. Also, ensure that you read the Known limitations of SQList to avoid surprises. If you have any questions about this release, do not hesitate to contact our support team at support@axioworks.com.

That’s all folks, till next time.

The AxioWorks Team


Latest articles

AxioWorks Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

19 Sep 2023

In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
[read article]

AxioWorks Newsletter August 2023: A month of milestones and innovation.

28 Aug 2023

Hello Reader, September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
[read article]

Use Graph API in Power Automate to read large Excel files from SharePoint

28 Aug 2023

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
[read article]

From Punch Cards to Python: Still Hitting the Keys in my 50s

16 Aug 2023

I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. […]
[read article]

AxioWorks Newsletter July 2023: Unveiling AxioWorks’s latest successes and exciting innovations

27 Jul 2023

Hello Reader, We hope this monthly update finds you in good spirits. As always, we are eager to share the latest developments and exciting ventures […]
[read article]

AI and Data: The Symbiosis of Interaction and Accuracy

13 Jul 2023

Artificial Intelligence (AI) has rapidly emerged as a revolutionary technology that fundamentally alters the nature of human-machine interactions. […]
[read article]

AxioWorks Newsletter June 2023: SQList v8 Release, Webinars, and New Product Development

30 Jun 2023

Hello Reader, Greetings to all our valued customers and subscribers! We are thrilled to share some exciting updates and developments with you in this […]
[read article]

Safeguarding Secrets with Secure Strings and Environment Variables in the Power Platform

26 Jun 2023

In today’s interconnected digital landscape, safeguarding sensitive information and maintaining robust security measures is of paramount […]
[read article]

Case study: Streamlining Medical Trial Data Analysis in the Pharmaceutical industry

15 Jun 2023

In the ever-evolving landscape of the pharmaceutical industry, conducting medical trials and analysing the resulting data are critical for the […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter