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 Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

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 […]
[read article]

AxioWorks Newsletter August 2023: A month of milestones and innovation.

28 Aug 2023

Hello Reader, September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
[read article]

Use Graph API in Power Automate to read large Excel files from SharePoint

28 Aug 2023

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
[read article]

From Punch Cards to Python: Still Hitting the Keys in my 50s

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. […]
[read article]

AxioWorks Newsletter July 2023: Unveiling AxioWorks’s latest successes and exciting innovations

27 Jul 2023

Hello Reader, We hope this monthly update finds you in good spirits. As always, we are eager to share the latest developments and exciting ventures […]
[read article]

AI and Data: The Symbiosis of Interaction and Accuracy

13 Jul 2023

Artificial Intelligence (AI) has rapidly emerged as a revolutionary technology that fundamentally alters the nature of human-machine interactions. […]
[read article]

AxioWorks Newsletter June 2023: SQList v8 Release, Webinars, and New Product Development

30 Jun 2023

Hello Reader, Greetings to all our valued customers and subscribers! We are thrilled to share some exciting updates and developments with you in this […]
[read article]

Safeguarding Secrets with Secure Strings and Environment Variables in the Power Platform

26 Jun 2023

In today’s interconnected digital landscape, safeguarding sensitive information and maintaining robust security measures is of paramount […]
[read article]

Case study: Streamlining Medical Trial Data Analysis in the Pharmaceutical industry

15 Jun 2023

In the ever-evolving landscape of the pharmaceutical industry, conducting medical trials and analysing the resulting data are critical for the […]
[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

*