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

AxioWorks SQList is now available online

27 Sep 2022

We have launched SQList Online! The cloud-based software as a service (SaaS) version of SQList, our on-prem application that makes it extremely easy […]
[read article]

MS Purview : One-Stop-Shop for data governance across your data estate

30 Aug 2022

Every organization utilizes various sources of data often scattered across cloud and on-premises systems. Over time, these data sources continue to […]
[read article]

DevOps in the world of Power Platform using GitHub Actions

31 Jul 2022

DevOps plays a vital role in the success of any software development project but when it comes to building low-code/no-code solutions it is often […]
[read article]

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]

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

*