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

Our Favourite Picks from Power BI Global Summit 2023

17 Mar 2023

Power BI Summit is the biggest Power BI conference of the year which ran virtually from 6th March to 10th March. It brought speakers from the […]
[read article]

AxioWorks Newsletter February 2023: Development of SQList new release is in full swing

28 Feb 2023

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

MS List Templates bundled with Power Automate Flow

20 Feb 2023

Microsoft Lists previously known as SharePoint Lists is the go-to option for maintaining and storing data in the world of O365 and its usage has […]
[read article]

AxioWorks Newsletter January 2023: Kicking off 2023 with some great content

30 Jan 2023

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]

A pragmatic approach to obtaining value from your SharePoint data

20 Jan 2023

Organisations have been storing data in SharePoint for more than 20 years.  This data can be as simple as a List used by a small team or a complex […]
[read article]

Power BI Report Server : An On-Premises Report hosting Suite

16 Jan 2023

Power BI has become the most widely used tool for reporting due its user-friendly interface which allows business users to generate sleek and […]
[read article]

AxioWorks Newsletter December 2022: Good bye 2022, welcome 2023!

29 Dec 2022

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

PowerApps Debugging and Troubleshooting made easy with Monitor

28 Dec 2022

Troubleshooting and debugging are an integral part of building and supporting a resilient app especially when it is built using a low-code […]
[read article]

AxioWorks Newsletter November 2022: Is it almost Xmas already?

29 Nov 2022

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

Future of SharePoint in the world of Power Platform

29 Nov 2022

Microsoft SharePoint has been the driving force for enabling virtual team collaboration and the modern workspace revolution over the last three […]
[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

*