How Do I Convert My SSL Certificate File To PEM Format? Most Certificate Authorities (CAs) issue certificates in PEM format. PEM certificates typically have extensions like .pem, .crt, .cer, and .key. The PEM format uses the header and footer lines —–BEGIN CERTIFICATE—– and —–END CERTIFICATE—–. Other certificate formats include the DER/Binary, P7B/PKCS#7, and PFX/PKCS#12 formats. The AeroFS Appliance requires a certificate in PEM format in step 9 of theappliance setup. This certificate […]

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 […]

Installing SFTP/SSH Server on Windows using OpenSSH

Natively from Microsoft  Working with Cywin (so we could use password less and rsync backup from window to linux box) : Recently, Microsoft has released an early version of OpenSSH for Windows. You can use the package to set up an SFTP/SSH server on Windows. Installing SFTP/SSH Server Setting up SSH public key authentication Connecting to the server […]

Tools to check website – dns – email hosting status

DNS health check: Website check: Check IP whitelist: Azure speed test: AWS speedtest: Linode speed test: Free & Public DNS Servers (Valid January 2018) Provider Primary DNS Server Secondary DNS Server Level31 […]