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.

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

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 beneficial for you. So, if you would like us to cover any specific SQList feature or if you want to learn more about any SharePoint feature then please do let us know.

What has AxioWorks been up to?

Wow, January’s already gone, that was quick. But it has been a good month for us here at AxioWorks.

This long Covid crisis took away the momentum we had built up, but we’re now noticing a definite increase in activity on several fronts. At last, we seem to see the end of Covid on the horizon, approaching fast. Shall we dare be optimistic?

Working flat out on many fronts…

We are building partnerships with SharePoint consultants and solution providers. We are still at the “initial chat” stage, but we have made some very promising contacts. Watch this space.

We are proud to be a sponsor and exhibitor at CollabDays Bletchley Park 2022 on 23rd February. Everything about the latest Microsoft technologies at the most incredible venue one could ever want! If you are attending, come to our boot and say hello, we’d love that! Read all details about the conference here.

At long last, after two years of postponements, we’ve started working on SQList Online! This version will not require you to install anything in your environment, you will be able to configure your replications directly on our portal in a completely secure environment. Nothing to see yet but plenty to come.

We have started collecting reviews for SQList on Capterra, a leading software reviews and selection platform. If you would like to read what some of our customers have to say, or indeed leave a review, visit our review page here.

As always, the maintenance and improvement of SQList goes on, we’re planning to release a new SQList update in about a month.

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

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 product road maps but it is also jam-packed with some great features for every product and this year was no different.

Read all about it in this month’s article: What went down at MS Ignite 2021: Power Automate and Power Virtual Agent Edition.

SQList feature of the month: Export SharePoint lists to SQL Server with special characters in the list or column names

SQList uses the SharePoint list and column “Internal name” by default to generate SQL table and column names during export to SQL Server. However, if the column name in list has Special/Non-Latin characters then SharePoint replaces them with hex codes like “_x00123_” and SQList removes them from the generated SQL column or table name.

If you want to keep the SQL column names identical to the SharePoint column names, there is a setting available in “Advanced Export Options” called “Use Display Name” which once enabled makes SQList use the “Display name” instead of “Internal name” to generate SQL table and column names.

If you want to know more about this feature, check out this video: Export SharePoint lists to SQL Server with special characters in the list or column names

Featured articles

Here is a small selection of interesting articles from the net.

How to share list items

Sharing content from SharePoint with others inside or outside of the organization is the core capability and is probably its most appealing feature. When we talk about sharing, we typically talk about documents or folders, or sites. However, we can now also share individual items from the lists, which I want to explain in this article.
Read more…

Data lakes take on big data

The world is generating more data than ever. In 2020 alone, 64.2 zettabytes of data were created or replicated, according to the International Data Corporation (IDC). The IDC also projects that the amount of digital data created over the next five years will be greater than twice the amount of data created since the beginning of digital storage.
Read more…

Edit vs. Contribute Permission Levels in SharePoint Online

I am not being original in publishing a post about this topic. If you google Edit vs. Contribute Permission Levels in SharePoint Online, you will get many posts covering this very important and one of the most infamous subjects in SharePoint. Since I receive lots of questions from my clients and loyal followers still on the matter, I decided to drop a few words of wisdom on this issue as well.
Read more…

6 ways to benefit from Managed Properties in SharePoint Online

In one of my previous blog posts, I explained the concept of a Managed Property and how to create one. What I did not discuss back then was why the hell we need a Managed Property and what would be the benefit of going through the whole pain of creating one. So in this article, I would like to provide a few examples of where we can take advantage of a Managed Property in SharePoint Online.
Read more…


That’s all folks, till next time.

Latest articles

My Impressions of Microsoft Flow: A Developer’s Perspective

13 May 2024

Recently, I had the opportunity to explore Microsoft Flow, a tool that promises to facilitate the rapid development of software applications through […]
[read article]

Power Pages Unleashed: Creating Dynamic Websites with Microsoft Copilot

28 Apr 2024

In our latest tutorial, we delve into the capabilities of Microsoft Copilot, with a focused exploration of Power Pages. Our aim? To showcase how […]
[read article]

Harnessing the Power of Microsoft CoPilot in Power Automate Flows: A Comprehensive Tutorial

25 Mar 2024

In the ever-evolving landscape of technology and business automation, Microsoft has introduced a game-changer that is set to revolutionize how we […]
[read article]

Embracing AI: Transforming Jobs and Unlocking New Opportunities (Claude 3 Opus version)

18 Mar 2024

The rapid advancements in Artificial Intelligence (AI) have sparked both excitement and fear among workers worldwide. Many people are concerned that […]
[read article]

The Evolution of Work in the Age of AI: A New Era of Collaboration (ChatGPT 4 version)

18 Mar 2024

In the annals of human progress, pivotal inventions such as the steam engine, the tractor, and the internet have revolutionarily altered our way of […]
[read article]

AxioWorks Newsletter February 2024: Partnerships, Upcoming SQList Update, and Summit Invitation

27 Feb 2024

Hello Reader, This February has been pivotal for AxioWorks as we’ve focused on laying strong foundations for the year. Here are the key […]
[read article]

How AxioWorks SQList Aligns With the Priorities of Software Buying Decision Makers

26 Feb 2024

As outlined in the “2024 Global Software Buying Trends” report by Gartner Digital Markets, the criteria that predominantly influence […]
[read article]

Maximising Power BI Reporting from SharePoint: The Strategic Advantage of AxioWorks SQList over Native Connectors

15 Feb 2024

In today’s data-driven environment, making informed decisions rapidly can offer a significant competitive edge. This is where Power BI comes […]
[read article]

AxioWorks Newsletter January 2024: A Promising Start to the New Year!

29 Jan 2024

Hello Reader, We hope this newsletter finds you well and thriving. At AxioWorks, we are embracing the new year with great enthusiasm and are […]
[read article]

Exciting New Partnership and Innovative SharePoint Tools from AxioWorks and Lightning Tools

17 Jan 2024

AxioWorks is excited to announce a strategic partnership with Lightning Tools, a leader in creating innovative SharePoint components. This […]
[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