Surprisingly, as per an article published by Gartner, “Cloud Computing is still perplexing to many CIOs even after a decade of cloud’. While cloud computing is a foundation for digital business, Gartner estimates that less than one-third of enterprises have a documented cloud strategy. This indeed comes as a surprise given the fact that cloud […]
Veeramani G
Microservices – Aligning business and technology for closer collaboration, agility & flexibility
A microservices-based architecture introduces agility, flexibility and supports a sustainable DEVOPS culture ensuring closer collaboration within businesses and the news is that it’s actually happening for those who embraced it. True, monolith apps architectures have enabled businesses to benefit from IT all along as it is single coded, simple to develop, test and run. As […]
Restrict s3 bucket Access to VPC
Allow access to s3 bucket only from vpc Currently I am evaluating options to lockdown permissions to my S3 Buckets as part of Security Enhancements. These are the steps I followed to lock down S3 Bucket access only to my VPC Create VPC End Points VPC End Points Screen Shot Attach the S3 Bucket Policy […]
Real-time video analysis using Microsoft Cognitive Services, Azure Service Bus Queues and Azure Functions
Cloud based Video Analysis is an upcoming field that strives to solve and automate video analysis in real time or near real time. The engine that drives the solution is set of cloud based APIs supported by Cloud providers such as AWS, Azure, Google Cloud etc. These APIs are built on top of Computer Vision, […]
MYSQL / AURORA Database Troubleshooting
Here is a look at some of the common queries that will be useful when troubleshooting AURORA database. Number of Connections by Host SELECT SUBSTRING(HOST, 1, 10) , DB,USER , COUNT(*) AS Count FROM information_schema.processlist group by SUBSTRING(HOST, 0, 10) , DB,USER ORDER BY Count desc ; — ‘10.10.50.22’, ‘Portal’, ‘webguest-dev’, ’46’ Aurora Max Connections […]
Memory-Optimized Tables
Monitor Memory Optimized Table Space Usage Memory-optimized tables are fully durable by default, and, like transactions on (traditional) disk-based tables, transactions on memory-optimized tables are fully atomic, consistent, isolated, and durable (ACID). Memory-optimized tables and natively compiled stored procedures support only a subset of Transact-SQL features. The following blog post shows how to monitor the […]
Windows Docker Containers using GMSA to connect to SQL Server – Part 1
Windows Containers do not ship with Active Directory support and due to their nature can’t (yet) act as a full-fledged domain joined objects, but a certain level of Active Directory functionality can be supported through the use of Globally Managed Service Accounts (GMSA). Windows Containers cannot be domain-joined, they can also take advantage of Active […]
Bulk Load Data Files into Aurora RDS from S3 Bucket using AWS Data Pipeline
Bulk Load Data Files in S3 Bucket into Aurora RDS We typically get data feeds from our clients ( usually about ~ 5 – 20 GB) worth of data. We download these data files to our lab environment and use shell scripts to load the data into AURORA RDS . We wanted to avoid unnecessary […]
Getting Started with AWS Data Pipeline and Loading S3 File Into MySQL
Getting started with AWS Data Pipeline AWS Data Pipeline is a web service that you can use to automate the movement and transformation of data. With AWS Data Pipeline, you can define data-driven workflows, so that tasks can be dependent on the successful completion of previous tasks. AWS Data Pipe Line Sample Workflow Default IAM […]
AWS Regions and Availability Zones
C:\Users\Raju>AWS ec2 describe-regions C:\Users\Raju> aws ec2 describe-availability-zones AWS Regions for EC2 Availability Zones