Automatic backup MSSQL Server to Amazon S3

https://tntdrive.com/mssql-server-backup-to-amazon-s3.aspx 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

https://sqlwithmanoj.com/2016/06/30/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

http://cloudbasic.net/documentation/rds-sql-server-backup-restore-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

http://www.oakwoodsys.com/best-practices-sql-server-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

https://medium.com/cognitoiq/automating-backups-using-aws-lambda-baa013fdffc7 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 […]