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 (6.2.1.0)

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 6.2.1.0 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. 6.2.1.0.

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

What went down at MS Ignite 2021: Power Automate and Power Virtual Agent Edition

14 Jan 2022

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

What went down in MS Ignite 2021 : Power Apps Edition

30 Dec 2021

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

AxioWorks Newsletter December 2021: How has 2021 been for you?

28 Dec 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

AxioWorks Newsletter November 2021: What has AxioWorks been up to?

03 Dec 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

What went down in MS Ignite 2021 : Power BI Edition

30 Nov 2021

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only we get a view of all their product […]
[read article]

AxioWorks Newsletter October 2021: Focus on customer service and a webinar on its way

01 Nov 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Gain valueable Insights into your PowerApps using Application Insights

25 Oct 2021

Power Platform provides a great way for citizen developers to develop Apps using low-code /no-code tools like PowerApps, PowerAutomate, and PowerBI. […]
[read article]

AxioWorks Newsletter September 2021: Focus on our sales effort

18 Oct 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Why use SQList to generate Power BI reports from SharePoint lists, rather than using the Power BI native connector to SharePoint?

18 Oct 2021

The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it […]
[read article]

SharePoint Online List vs SQL Server as Data Source in Power-BI

15 Sep 2021

Lists are primarily used as a source of data storage in the world of SharePoint and in most scenarios these lists can grow really fast especially if […]
[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

*