Installing MongoDB on the Ubuntu EC2 instance in AWS is an excellent option if you plan on shifting to a NoSQL database. On top of the AWS benefits, you can expect efficient data management, on-demand scaling, and better security. Let’s see how the installation process works with a step-by-step approach. How to Install MongoDB on…
Deleting an EC2 instance is pretty easy, whether through AWS Management Console or the Command Line Interface. But once you terminate an EC2 instance, you cannot undo it. So, you may want to stop or hibernate as an alternative to deleting. That said, you can always launch more instances with the same AMI. Can You…
Amazon EBS Multi-Attach allows EBS volumes to be attached to multiple EC2 instances within the same Availability Zone (AZ). You can connect several Multi-Attach enabled EBS volumes to a single EC2 instance or a group. However, you should be aware of certain limitations associated with using Multi-Attach. These include potential compromises in performance and security,…
Stopped EC2 instances do not cost money. However, sometimes, a stopped EC2 instance may still have some Elastic IP addresses, EBS volumes, or other resources attached to it. In that case, you might get charged despite stopping your EC2 instance. But the cost should be a fraction of the running cost of the instance. Or…
You can add an IAM role to an EC2 instance through the EC2 console, AWS CLI, or other options like Terraform and Amazon CloudFormation. Whether you like working with an easy GUI or prefer streamlined command lines, these approaches should work fine. Let’s have a closer look at how to add an IAM role to…
AWS does not provide a direct option to move an existing instance to a new Availability Zone. However, there’s a workaround if you want to change the Availability Zone of an EC2 instance. The process includes creating a new AMI from your EC2 instance and manually migrating it. After that, you need to launch a…
Copying a database from an SQL server is the process of copying and distributing data and database objects from one database to another. A part and parcel of this task is to synchronize all data between the databases to ensure data integrity and consistency. To copy the SQL server database, the ‘copy database’ option from…
You can rapidly determine the SQL Server database size in SQL Server Management Studio (SSMS) if you only need to examine one database: Click Reports -> Standard Reports -> Disk Usage after doing a right-click on the database. To obtain database size instead, use a stored procedure like exec sp_spaceused. Both of these approaches, meanwhile,…
Once a development or operations team gets over the hurdle of open-source and starts to feel comfortable with the way the software works outside of the enterprise world, they will likely start to settle in and feel comfortable. Best not to get too cushy though for there are more surprises hiding around the corner. Here…
Creating a GUI for your SQL database can be intricate if you go the coding route. Building a GUI app from the ground up isn’t easy unless you’re familiar with C#. That said, there are many tools like Azure Data Studio, DbVisualizer, Retool, DBeaver, and Airplane to create a GUI without writing code. What GUI…