We are proud to announce a new release of SQList which provides even greater flexibility when exposing your SharePoint lists and libraries as a set of normalised SQL Server Tables.
Version 5.4 of SQList is a minor update from ver. 5.x.x, you can, therefore, upgrade for free if you have a licensed version 5.x. There are no breaking changes in this update.
There are some great new features in our SQList 5.4 release, namely:
SQL Server 2017 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011 and is now supported in SQL Server 2017.
Read more about temporal tables
Read how to use temporal tables with SQList tables
SQList mirrors the structure of a SQL table with the structure of its corresponding SharePoint lists. This means that when a new column is added to the list it gets added to the table. Likewise, when a column is removed from the list, it gets removed from the table.
Although we recommend not to alter the structure of the tables generated by SQList in any way, there are exceptional cases when you may need to add some columns to the table.
SQList 5.4 adds a setting to manage throttling in SharePoint Online. We introduced an additional configuration setting as part of the site definition, to manage throttling in SharePoint Online.In the site definition details, there is a new setting named “Throttling control delays”; you can use this setting to define the length (in milliseconds) that SQList waits between requests to that particular site…
As part of the standard columns, SQList now exports the the following columns that contain the list item’s version numbers:
Improvements and fixes
In addition to the new functionality, we have added the following fixes and improvements to this version:
You can read about all the new features released in all SQList V5 releases here
16 Nov 2023
In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
30 Oct 2023
In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
28 Oct 2023
As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
16 Oct 2023
In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
30 Sep 2023
September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
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 […]
28 Aug 2023
September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
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. […]
27 Jul 2023
We hope this monthly update finds you in good spirits. As always, we are eager to share the latest developments and exciting ventures […]
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.