PowerApps - Beyond 500 item limit and Delegation Warning. The "XXXXX" part of this formula might not work on large datasets.

This is the most common warning which is overlooked by the Power app developers as its just "Warning".

We see the function work and fetch the results, and thus ignore the warning. I have seen  many of the powerapps that were productionized have these warnings.

Please make a note:

"That is not just a technical warning, its a future functional error". 

AWS Certification Pre-Exam Knowledge Refresh- Part 4

Here is the link for part 3

EC2 Auto-Scaling happens Horizontally(Adding more instances) and DB scaling happens vertically(Adding more space on existing instance).

AWS Certification Pre-Exam Knowledge Refresh- Part 3

Here is the link for Part 2

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. 

Just like S3, Amazon redshift cluster is HA with in a region. For HA across regions, you need to enable cross-region replication.

AWS Certification Pre-Exam Knowledge Refresh- Part 2

Here is the link for Part 1

AWS Elastic File System EFS: Fully managed by AWS, designed only for Linux workloads. Supports petabytes(massive amount of storage), across multiple Azs.

Amazon Elastic File System (Amazon EFS) provides simple, scalable file storage for use with more than one Amazon EC2 instances in the AWS Cloud.

AWS Storage Gateway is a hybrid storage service that enables your on-premises applications to seamlessly use AWS cloud storage.

AWS Elastic Load Balancer  - Routes to various services/applications based on the request url/data. Can add multiple instances supporting application. Routing to those instances can be taken care by LB.

3 types of ELB 1. Application LB 2. Network LB 3. Classic LB

AWS Lambda - Runs set function/application/code based on triggers. SO you don't need to worry about Infrastructure or patching. Purely pay the compute time used by your code.

Max timeout for lambda execution is 15 mins or 900  seconds.

AWS Certification Pre-Exam Knowledge Refresh- Part 1

First let me begin by saying, i would not recommend doing certifications just by using some practice tests or by reading some material.

Get the free-tier subscription. Practice, experiment, do some proof of concepts.

I know you cannot implement al the concepts specially where you need large datasets to test certain concepts.

Most of the information is shared out of my notse and observations during the trainings, self-study, experimenting in my free tier subscription and some from practice tests.

The intent of sharing this information is to have a last check before you leave for an exam. 

Here is the first of a few articles i am going to share for people going to take certificaton exam. I did cleared both CP and CSAA with only 90% , so if i am misinterpreting anything, please do correct me.

AWS VPC Basics - How To Configure Security Using Subnets

In this article i will explain whats a "VPC", its uses and demonstrate how we can handle the networking & security using various components like VPCs, Subnets, Route tables.

Please know that i will spend little time on theory as it was better explained in AWS Documentation. We will go deep in implementing in a step-by-step manner.

We will :
1. Define AWS Components like VPC, Subnet, Route table, EC2 instance, S3.
2. Configure VPC
3. Configure Subnets
4. Setting Rout Tables
5. Creating EC2 instances in various subnets
6. Testing security we setup.
7. Talk little bit about VPC endpoints.

Let me start with a design of what we will be creating.

AWS FreeTier Subscription - First 4 Things You Need To Do

As a AWS Free-Tier user you are entitled for lot of free compute power.

This is AWS way of saying "Please experiment and learn".

But expirements go wrong sometimes. In this case they can go really bad if you are not carefull.

Here are the 4 things you need to do first after signingup for AWS Free-Tier subscription.

#1. Set billing alert.

#2. Enable MFA

#3. Delete root account access keys

#4. Bring IAM dashboard's "Security Status" to all Green 5/5

Ok, i will take you through each change and explain you why.

AWS Lambda Function - How to Create - Test - Run

We are not going to talk about how AWS Lambda are server less and how usefull they are or where does Lambda functions fit in your solutions.

AWS Documentation is there to explain way better than i do. Here is the Link.

We are here to 

1. Create IAM User, assign permissions

2. Create your first Lambda function. 

3. Understand the code.

4. Test the code.

5. Access and Execute Lambda function from AWS CLI

6. Understand how to pass parameters when calling Lambda function.

7. Error Handling and Logging.

Lets keep the code simple to maximize understanding of concept behind.

Microservices Introduction - Monolith Vs Microservices

This post is a beginning of a long series which will cover Microservices, Devops, Containers, Dockers and many other futuristic concepts.

All these concepts are vast and range from simple to complex implementations. So let’s take it slow.

We should learn about Monolith application before learning about Microservices.

Monolith Application

This is the regular way of application development we followed earlier. Typical 3 tier application with Presentation Layer, Business Layer, Data Access Layer. Below image explains what we call a Monolith application.

Microsoft Flow Basic Sharepoint Interactions

Objective: In this post we will look at basics of Microsoft Flow performing Sharepoint list operations.

We always drive our discussion based on a use-case. Below are the two scenarios we will consider for this post. 

1. Action based on a item creation or update

2. Action on list of items filtered from a list based on a condition. 

As i mentioned earlier, this is for Flow newbies with basic  Sharepoint interactions.