I am currently working on a project that migrates data from SQL Server to Aurora Postgres. I have more than 5 tasks including several validation tasks as well. A total of 70+ tables were migrating with data in millions. Everything was working fine until we were planning to few more tables and create a new … Read more
AWS (Amazon Web Services) is a comprehensive cloud computing platform that provides a range of services for businesses, developers, and individuals. If you’re looking to learn AWS, you’ve come to the right place. Here are 5 tips to help you get started: 1. Start with the basics Before diving into the more complex services offered … Read more
In order to make your Alexa skill more interactive it is necessary to save user information to make the skill smarter. An ideal example would be to store the score the user got after his / her game. You can use this information to let the user know his personal best. In this blog, I … Read more
Recently we ran into an issue where SQL Server CDC logs query was not returning any results and was running forever. A few days prior to that we enabled CDC on the database level as well as table level (for all tables). Also, we set the polling interval in sys.sp_cdc_change_job as 1 day. Consequently, CDC … Read more
AWS DMS is one of the popular services used for data migration, especially for huge data migration. For the past few month, I have been working on AWS DMS service and I had many hurdles then and there. In this blog, I will be explaining various steps involved in migrating the SQL server database to … Read more
I have been working on AWS dynamoDB for a while now and every time I used to upload the JSON data to dynamoDB using a python script making use of the batch update. In many situations, I will have to convert the CSV file to JSON and then upload it to dynamoDB. So in this … Read more
In this blog, we are going to see how to download the entire files from the Amazon S3 bucket. If you are new to Amazon S3, then I recommend you to read this blog to get a high level understanding. If you are using Amazon S3 then very often you will be downloading files from … Read more
Most people use Amazon S3 to store images so that they can fetch them whenever required to display on their website. In this blog, I am going to show you the ways this can be done. In case you are someone new to AWS then take a look at this article to know what AWS is and what … Read more
AWS Lambda is one of the exciting services provided by Amazon. It provides us with a UI where we can type our code and deploy it instantly without any need for a server. In this article, let us see the things to keep in mind if you develop the code using lambda console. If you … Read more
AWS Lambda and SQS are some of the most popular services that Amazon provides. Yes, we do love them but lambda’s concurrency handling with SQS is silly. In this blog, I am going to share my experience working with them. If you are someone new to Lambda or SQS please feel free to check my … Read more