(When) does SharePoint Online in Office 365 use the Microsoft Upload Center?

When opening Office Documents from Office 365 it seems that the Microsoft Upload Center is not being used: I can open Word-documents from a document library and save them back without a problem, even when I clicked ‘Pause Uploads’. Also: files do not show up under ‘Recently upload files’.

I’m using Office 2016.

Microsoft Office URI Scheme Create Word Document Does not Save to SharePoint Location using |s|

I got inspiration from this question. I was trying to find a way to create a link for users to create a new Document using a template, and save it to a SharePoint Online document library using Modern UI.

I came across the Office URI scheme which has some function to do this. I managed to create a part of the link which allows me to create a new document using a document template I am storing in a SPO Document library.

I managed to create this so far

ms-word:nft|u|https://mytenant.sharepoint.com/sites/department/team/Shared%20Documents/template.docx|s|https://mytenant.sharepoint.com/sites/department/team/checklists/ 

If I read the instructions here correctly, the save location is the bit after “|s|”. However, when I go to save the file, it prompts me with a dialog box and defaults to my OneDrive.

The expected result is when I hit save, the document should save in the document library I specified, which in this case is “checklists”. Or at the very least, the dialog box should have the default save location as what is specified.

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746

I’m running an Ubuntu 18.10 machine and I’ve been following this tutorial: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-2017 I’ve been successful until I got to Connect locally section.

Every time I try this command sqlcmd -S localhost -U SA -P password I get error from the title along with: Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection. (it doesn’t matter if I enter right or wrong password it’s always the same error).

I’ve discovered that the problem is with -S localhost part (I also tried entering “(local)”, 127.0.0.1 and . and got same error every time), but I just can’t get it to work. I’ve been searching for solution since yesterday and everything I found didn’t work for me, so I’m putting all my hopes into this question. Thanks in advance!

EDIT: I tried entering the command above without -S localhost and it still throws same error…

EDIT 2: Tried the most upvoted solution from here AND IT WORKED!!! https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te

Microsoft Flow vs BCS to keep an Azure SQL table in sync with an SPO Modern List?

We worked with BCS (Business Connectivity Services) a long time ago and did not like it. Seemed like a lot of overhead maintaining the map. If the goal is to keep a single Azure SQL Table in sync with an SPO Modern List, can we just do it with Microsoft Flow and not use BCS?

A once daily scheduled Flow at 1am that synchronizes the two sources is fine.

Technically seems very do-able, but wondering what challenges we will face?

Will my list need Version Control turned on?

Thanks.

Microsoft Flow vs BCS to keep an Azure SQL table in sync with an SPO Modern List?

We worked with BCS (Business Connectivity Services) a long time ago and did not like it. Seemed like a lot of overhead maintaining the map. If the goal is to keep a single Azure SQL Table in sync with an SPO Modern List, can we just do it with Microsoft Flow and not use BCS?

A once daily scheduled Flow at 1am that synchronizes the two sources is fine.

Technically seems very do-able, but wondering what challenges we will face?

Will my list need Version Control turned on?

Thanks.

Microsoft Flow vs BCS to keep an Azure SQL table in sync with an SPO Modern List?

We worked with BCS (Business Connectivity Services) a long time ago and did not like it. Seemed like a lot of overhead maintaining the map. If the goal is to keep a single Azure SQL Table in sync with an SPO Modern List, can we just do it with Microsoft Flow and not use BCS?

A once daily scheduled Flow at 1am that synchronizes the two sources is fine.

Technically seems very do-able, but wondering what challenges we will face?

Will my list need Version Control turned on?

Thanks.

Microsoft Azure Networking Rabbit Hole

I have been learning MS Azure for some weeks now but, despite extensive use of the internet, I am still confused about the Azure networking set up, and hence struggle to grasp how to configure my solution and -security properly.

Problem: I am unable to make out a comprehensive picture about how everything is linked, and WHY! E.g. I am not finding consistent definitions of ‘vnet’ or ‘subnet’; to my understanding a network is a nexus of nodes but then why is the Azure topology chart showing a subnet as a separate ‘node’? MS web pages state strange statements like “A virtual network rule for your SQL Database server is a subnet…” or “A Virtual Network service endpoint is a subnet…” just before (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview?toc=%2fazure%2fvirtual-network%2ftoc.json).

I also was reading MS pages on “Azure Service Endpoints” but still cannot explain what they really are! I read fuzzy wording like “Virtual Network (VNet) service endpoints extend your virtual network private address space and the identity of your VNet to the Azure services…. Endpoints allow you to secure your critical Azure service resources to only your virtual networks…”, which seems containing confusing grammar errors (https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-service-endpoints-overview) – I just does not make sense out of this!

Could someone please give a high-level but precisely-worded overview on the ‘Why’ of the Azure networking topology setup, or a good internet link explaining this matter? I am lost deep in the rabbit hole with this, and need some light- without this I don’t like to enter the next rabbit hole called “Securing an Azure solution”…

Topology chart: Where are the “Azure Service Endpoints” SQL Server, Storage Account, Key Vault?

enter image description here

How to use Microsoft Flow on SharePoint list to create event in SharePoint calendar

I am new to SharePoint and Flow, this is my first project using the two, so I really have no idea what to do.

I created a SharePoint site of 198 calendars, using SharePoint online, and am trying to create a central list where events can be entered and a flow will create the events in the proper calendar.

I have a list called Event List where users will enter the title, location, start and end time of an event. I would then like the flow to link the location to the title of the calendar (location:00 calendar:Store 00), and create the event using the title, start and end time.

Event List with Test Event Test Store 500 Calendar

Below is a non-working example of what I am trying to do. I don’t want to set the list name but want the flow to find the calendar based on the location in the event list.

Non-working flow