AWS PostgresSQL with Machine Learning

Amazon Aurora with PostgreSQL compatibility is now available with machine learning capabilities, an option to export data into Amazon S3, and compatibility with updated PostgreSQL versions.

You can use Aurora to add machine learning (ML) based predictions to your applications, using a simple, optimized, and secure integration with Amazon SageMaker and Amazon Comprehend. Aurora machine learning is based on the familiar SQL programming language, so you don’t need to build custom integrations, move data around, learn separate tools, or have prior machine learning experience. This functionality is also available for Aurora with MySQL 5.7 compatibility.
Aurora machine learning supports any ML model available in SageMaker, or you can run sentiment analysis using Comprehend. It’s available for PostgreSQL 10 and 11, with no additional charge beyond the price of the AWS services that you are using. For more information, read the launch blog, the Aurora ML feature page, and the Aurora documentation.

Azure Database Consulting Solutions

We know that migrating to cloud, if you’re not there already is a daunting project.  Especially if you’re not familiar with the proper steps and preparations. We are specialized in Azure Database migrations apart from AWS database and Business Intelligence Solutions.  We’re a Microsoft partner and work closely with Microsoft resources when needed, to get your project to azure cloud.

Our Azure consulting has engineers with over a decade of Cloud experience.   As an experienced Azure Database Consulting company, Whether you wanted to migrate into Azure with significant control by constructing your own VM and installing and configuring your Enterprise or other Editions of SQL Server, or just go cloud using Azure SQL or Azure SQL DataWarehouse with minimal management, we make it all happen seamlessly with little or no impact to your current production environment.

We can also partially migrate select components of your Database or Business Intelligence, and proceed in steps, rather than migrating at once and having trouble getting familiar or facing difficulties in managing them all at once.

For our cloud skeptical customers, our Azure Database Consulting solutions also involve migrations through POCs.  We hear you asking “How does that work?”  Our POCs are planned by isolating and sampling logical portions of your applications and proofing them on the cloud.  This allows to bench test and attain various performance and other numbers, to ensure you’re getting the best of what the cloud has to offer and offer your stakeholders concrete numbers to make decisions quick.   We also balance the technologies on the cloud with your budget and make sure we have the budget friendly technologies aligned with your company goals and allow proper scaling.

We have provided extensive cloud solutions that affect 10’s of millions of dollars of revenue and saved customers millions in business intelligence delivery and logistics and costs associated to maintaining onsite hardware.

As a cloud consulting services provider, we have enabled a global cable services company with millions of end users and 100s of customers who went from zero cloud to everything cloud within 6 months to a year.  Check our Case studies With multi-terabyte datawarehouse, this specific solution has a combination of SQL and NoSQL technologies including specialty caching and Document mgmt. databases and end-to-end monitoring for the entire cloud.  Our cloud solutions also ensure global and geographically sustainable high availability and performance so end users have response times similar to locally hosted data centers.

Our SWAT (System Wide Assessment Team) is ready to provide full or partial assessments of your environment and options of which cloud technologies will be appropriate for you.

Call and ask us more on Azure Cloud Consulting, or write to us

Microsoft’s new database for globally-distributed applications

Azure Cosmos DB is a superset of the existing DocumentDB service, and Microsoft is transitioning all existing DocumentDB customers to Azure Cosmos DB, free of charge.

The system is designed to scale horizontally, whilst maintaining impressive performance and reliability. This is backed by a confident and generous service-level agreement.

Microsoft says that it can deliver single-digit millisecond latency at the 99th percentile, which is huge. It also says that 99.99 percent of all requests will “complete successfully,” and is also promising a 99.99 percent uptime availability.

This new effort from Redmond is extremely versatile, and can handle pretty much every type of data you’re likely to throw at it, including key-value, document, columnar, and graph types, in a variety of environments, including AI and IoT.

Azure Cosmos DB also plays nice with several NoSQL APIs including MongoDB, Table Storage, DocumentDB SQL, Gremlin, and Azure Tables. The Gremlin and Table Storage are currently in preview mode.

Another strength of Azure Cosmos DB is the ease and speed upon which data can be replicated in different Azure regions, allowing developers to quickly respond to regional surges of traffic. This elasticity doesn’t come at the expense of application downtime.