Character sets, encoding, and collation in MySQL
Character: set of symbols and encodings Encoding: set of values assigned to characters Collation: set of rule for comparing a character set Suppose you have the following characters, that are…
Listing all tables and their table counts in a MySQL database
The Following SQL query will list all tables in a MySQL database and also list the row counts for each. where mydatabase is the name or your database. The output…
Database normalization and normal forms
The goal of database normalization is to reduce data redundancy and to improve data integrity. This is done by organizing columns and tables by apply the normal forms. In theoretical…
What are the key differences between on-premise and cloud computing
An on-premise infrastructure is physically accessible by your staff. Cloud infrastructure is not hosted remotely and not accessible by your staff. With on-premise computing, you own the servers and other…
What is SaaS, PaaS, and IaaS
Cloud computing is offered in three distinctly different service model, each designed to satisfy a different set of business requirements. The service models are SaaS, PaaS, and IaaS. SaaS, short…
Six Advantages and Benefits of Cloud Computing
If you are thinking about moving to the cloud but are not sure, then the this short post can help you decide. Why should you choose cloud infrastructure over on-premise…
Amazon S3: Simple Storage Service
Amazon S3 is simply a collection of objects stored in a bucket. Buckets are created in a region. Buckets are replicated in multiple Availability Zones (AZ) within the same region.…
ELB: Amazon Elastic Load Balancer
The Elastic Load Balancer (ELB) distributes traffic across different instances. It spans the region and uses ever Availability Zone (AZ). ELB is inherently secure, resilient, scalable but the client is…
EBS: Amazon Elastic Block Storage
To understand Elastic Block Storage, we need to first understand what block storage is and how if differs from object storage. Block storage breaks data into block and then stores…