AWS zone code

Code Name us-east-1 US East (N. Virginia) us-east-2 US East (Ohio) us-west-1 US West (N. California) us-west-2 US West (Oregon) ca-central-1 Canada (Central) eu-central-1 EU (Frankfurt) eu-west-1 EU (Ireland) eu-west-2 EU (London) eu-west-3 EU (Paris) ap-northeast-1 Asia Pacific (Tokyo) ap-northeast-2 Asia Pacific (Seoul) ap-northeast-3 Asia Pacific (Osaka-Local) ap-southeast-1 Asia Pacific (Singapore) ap-southeast-2 Asia Pacific (Sydney) […]

De-mystifying AWS S3 Usage AWS S3 is a fantastic resource for cloud object storage! The only complaint that I often hear is in the lack of transparency to understand current usage. Although there are monthly costs, its sometimes pretty hard to see exactly where you’re using space most heavily. Problem Because S3 is an object storage engine, your files are not […]

Automatic backup MSSQL Server to Amazon S3 In this article we will explain of how to set up automatic backup of Microsoft SQL Server to Amazon S3. The method described in this article works well for all editions of MSSQL Server, including Microsoft SQL Server Express Edition. We use Microsoft SQL Server Management Studio to generate backup script. If you do not have this […]

Using some best practices for SQL Server in Azure VM (IaaS) to get MAX performance I was setting up an environment on Azure Premium Storage (G-Series) server for my Project, and was not getting the performance I was expecting. The comparison was against an existing Database Server setup on an On-Premise VM. Microsoft Azure Premium Storage delivers high-performance, low-latency disk support for VMs running I/O-intensive workloads. Uses SSD (Solid State Drives) to store your data and Caching capability to provides highest throughput […]

RDS/SQL SERVER BACKUP AND RESTORE TO/FROM S3 Backup database to S3 Under RDS Dashboard create a new option group with “SQLSERVER_BACKUP_RESTORE” option. Update your RDS instance to use the newly created option. Open SQL Management Studio, connect to RDS database and execute the following to kick off the backup: USE [msdb] GO DECLARE   @return_value int EXEC  @return_value = [dbo].[rds_backup_database]       @source_db_name […]

Best Practices for SQL Server in Azure Most of the typical items that DBAs will hit in tuning out a server for SQL Server hold true in Azure. The three major spots you will usually focus on are OS configurations, storage configurations, and SQL Server instance configurations.  These are generalizations and, as your workload demands, there may be variations that are […]

Automating Backups using AWS Lambda When thinking about Cloud Services, backup is something normally not taken into consideration because we hear lots of “ephemeral”, “self-healing”, “repositories” words. Sometimes, applications need to be backed up in order to achieve a RTO that suits customer’s business objectives. Automation is key under these concepts, so with this document we want to indicate […]