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

How can I recover my MSQL sa Password? Q: I recently ran across a case where a company I worked with had lost their sa password. How can I reset the sa password? Do I need to reinstall SQL Server? A: No. In most cases you won’t have to reinstall SQL Server. If you have access to the Windows Server administrative password […]

How do I perform native backups of an RDS SQL Server DB instance? Issue I want to perform a native backup of my Amazon RDS SQL Server DB instance so that I can store the backup file in Amazon S3, or use the backup file to restore an RDS instance later. Short Description Amazon RDS supports native backup and restore for Microsoft SQL Server databases. You can […]

How To Restore a SQL Server BAK file to Amazon RDS Amazon RDS for SQL Server does not allow you to restore a .bak file (as of Apr. 2013). If you attempt to use the Restore Database… function and select a File (Device) to be restored, you will get an error saying Failed to retrieve data for this request. Amazon has disabled this function. The official Amazon documentation […]

You are here: Home >> Posts >> Database Administration >> The Accidental DBA (Day 21 of 30): Essential PerfMon counters The Accidental DBA (Day 21 of 30): Essential PerfMon counters his month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our� Immersion Event for The Accidental/Junior DBA, which we present� several times each year. You can find all the […]