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

Build your Apps in MS Teams with MS Dataverse for Teams

27 Jun 2022

MS Teams has become one of the most widely used tools for team collaboration and communication in organizations using Microsoft echo-system for […]
[read article]

Dataverse: A one-stop-shop for your App data storage and management

24 May 2022

Data is at the centre of any business application development and is often the deciding factor for which tech. stack to be used for the development. […]
[read article]

AxioWorks Newsletter April 2022: Still working on the next release of SQList…

30 Apr 2022

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’s coming in Power Platform Release wave one of 2022

21 Apr 2022

Due to the ever-rising popularity of the Power platform, Microsoft continues to focus on improving the usability and versatility of the Power […]
[read article]

AxioWorks Newsletter March 2022: Working on the next release of SQList

30 Mar 2022

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]

How to Efficiently Develop and Deploy Solutions in Power Platform

20 Mar 2022

With the Emergence of Low Code to No-Code development platforms, developers have been ever so busy developing solutions utilizing those platforms […]
[read article]

AxioWorks Newsletter February 2022: A good month

28 Feb 2022

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]

Five most awesome features in MS Lists

20 Feb 2022

Microsoft Lists previously known as SharePoint Lists have been widely used for maintaining and storing data in SharePoint and its usage has grown […]
[read article]

AxioWorks Newsletter January 2022: Hello 2022, good bye Covid (we hope)

31 Jan 2022

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 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]

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

*