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
18 Jun 2021
We are looking for someone with experience in the SharePoint and BI arenas to take on the role of Sales and Marketing Manager. You will be able to […]
11 Jun 2021
One of the biggest conundrum of any organization planning to move to SharePoint is how to move all their documents stored in various different […]
04 Jun 2021
A new version of AxioWorks SQList is out today!
We have been really busy for the past few months, but here we are with a brand new release of […]
01 Jun 2021
Welcome to another exciting issue of our monthly Newsletter!
Each month, we try our best to bring to you content that is relevant and […]
16 May 2021
SharePoint Lists provides an easy and robust way of storing and manipulating data in SharePoint. When you set up a new custom list, you also get OOTB […]
01 May 2021
Welcome to another issue of our monthly Newsletter!
Thank you for the great feedback on the past newsletters, our team has been working […]
26 Apr 2021
There has been an exponential growth in SharePoint usage over the past few decades due to its vast set of capabilities to fulfill the […]
01 Apr 2021
Welcome to our second Newsletter!
Did you enjoy the first one? Or maybe you didn’t? Either way, do give us some feedback using the links at the […]
29 Mar 2021
During this Pandemic era, working remotely has significantly increased throughout the world and so is the usage of tools to facilitate collaboration […]
01 Mar 2021
We have just sent out our first newsletter and, being it our first one, we thought we dedicate a post to it. All future ones will go out just by […]
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.