Support SQL Azure as a PI AF SQL backend
As an administrator, I want to use SQL Azure as the database backend for my PI AF databases, so that I can offload the SQL adminstrative tasks to Azure.
Due to a reduction in I.T. staff, we are looking for ways to get the best value for the business from the remaining staff. Moving to an Azure SQL Managed Instance is one way to achieve this. This follows on from the points made by PartickV and BartM about how it frees staff to analyze data rather than maintain data.
Has there been any progress on this? Migration to cloud is very relevant these days and PaaS / SaaS services is preferred over IaaS. Support for PaaS SQL solutions in Azure is highly sought after.
I agree with Amit and BartM here. For our case it is very important that we are not bogged down with maintaining database in Azure as IaaS solution. The press to move into cloud really shows the need for an official support from OSIsoft on Azure SQL Managed Instance.
Ivan Berry commented
Agree with BartM, supporting Azure SQL can reduce our total cost of ownership.
BORIS GLAZMAN commented
A global Flexible Foams, Bedding, Insulation and Automotive manufacturer based in Belgium is looking for support of Managed Instance of MS SQL server for their Azure deployment of AF. All of their SQL servers are being moved to MI on Azure.
Amit Srivastava commented
I would like to understand what is OSIsoft direction on making PI AF compatible with SQL hosted on Azure as PaaS or SQL Managed Instance.
I belive this is the direction many companies are also heading towards where they want to invest time/money on getting value out of the data than spending part of it in managing/storing the data.
Patrick Versyck commented
Having SQL server in a SaaS model offers many advantages over a hosted database on Premise or in Azure VM (IAAS model) : Upgrades, patching, back-up, Disaster / recovery (using High Availability for PI). It is clear for me MicroSoft is taking the direction of Managed Instance. On premise databases will of course not disappear any time soon. Business wants to invest in skills to exploit the data , not to store them
Bart Michel commented
would more than welcome this feature! We would like to focus on our core task (data analysis and turning data into value) keeping servers into the air, taking backups etc is not our core business, so would be a big plus if we could use (as for all our other sql databases, SQL Azure - Azure SQL managed Instance if needed. Making PI AF compatible with SQL Azure manged instance should not be a big deal for OSISoft. Thanks for giving this the right prioirty.
Can you tell me what you hope to achieve with SQL Azure? Is it a management consideration or IT requirement or ???
Is this improvement still discussed?
Hiroyasu Ishigaki commented
We are using PI System on Azure VMs.
We had experienced many works and troubles on SQL Server instances and really want to use Azure SQL Database(Managed service) instead of SQL Server on VM.
Wilson Laizo Filho commented
Microsoft have a new option now with Managed SQL Servers that would probably be easier implemented (as it's just a SQL Server that MS manages the SO).