Why Migrate from Btrieve to PostgreSQL and other Relational Databases?
Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...
On July 18, 2013, Mertech continued the Campfire initiative with a session on the Windows Azure platform, led by Mertech representative Oliver Nelson (Senior Technologist). If you missed it, you can watch the video above. We have also listed some helpful resources at the bottom of this page.
Azure is essentially “a cloud platform for building, deploying and managing applications across a network of Microsoft-managed datacenters”. More specifically, Azure is essentially a combination of Infrastructure as a Service (IaaS), comparable to the storage (S3) and virtual machine (EC2) options offered by Amazon with their Amazon Web Services (AWS), and Platform as a Service (PaaS), which enables developers to offload their operating system management to Microsoft and enables them to publish their applications.
The presentation went over key differences between Amazon’s and Microsoft’s offerings, which include:
The main feature that was discussed was that of the SQL server, which has some important limitations in the Azure environment, such as size (only up to 150 GB), lack of ability to customize specifications as it is commodity hardware, and absence of sufficient backup and restore options. Essentially, the SQL performance here is sufficient if you have a small number of users, but for larger applications that require best-in-class performance this is not ideal.
Oliver then showed a sample order entry table built in VDF to demonstrate Mertech’s new support of the Azure platform, and then opened up the floor to questions. Questions included subjects such as outages (there have been a few), location of datacenters, security, and notably, the potential for using Azure with DataFlex. The consensus on this issue is that the PaaS offered by Microsoft is not powerful enough for VDF applications, yet, but using a virtual machine to take advantage of the differences in the IaaS offering is effective for VDF developers. For example, Web App server will function out of the box in a virtual machine, but not in the PaaS environment. Furthermore, due to the limitations of the SQL product offering, it is best to set up SQL in a virtual machine instead of using Microsoft’s commodity hardware solution.
Overall, it was an informative session, and we look forward to the next topic.
Here are some helpful links about the subject.
General Overview/History/DataCenter Locations
http://en.wikipedia.org/wiki/Windows_Azure
SaaS, PaaS, and IaaS Defined
http://www.rackspace.com/knowledge_center/whitepaper/understanding-the-c…
Information about Azure Virtual Machines
http://msdn.microsoft.com/en-us/library/windowsazure/jj156003.aspx
Azure Pricing Calculator
http://www.windowsazure.com/en-us/pricing/calculator/
List of all Components/Services of Azure and Details
http://www.windowsazure.com/en-us/manage/windows/fundamentals/intro-to-w…
Information about Azure Web Sites
http://www.windowsazure.com/en-us/services/web-sites/
Information about Azure SQL Database Reporting
http://msdn.microsoft.com/en-us/library/windowsazure/gg430130.aspx
Information about Azure SQL Database
http://msdn.microsoft.com/en-us/library/windowsazure/ee336279.aspx
Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...
COBOL applications are the foundation of numerous essential business functions, especially within the banking, insurance, and government sectors....
Imagine breaking free from the constraints of old, monolithic systems and embracing the agility and innovation of cloud-based solutions.