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

SQL monitor Now that you’ve got the hang of adding counters, here’s the full list we need to add, including the ones mentioned above: These are listed OBJECT first, then COUNTER Memory – Available MBytes Physical Disk – Avg. Disk sec/Read Physical Disk – Avg. Disk sec/Write Physical Disk – Disk Reads/sec Physical Disk – Disk […]

Troubleshooting MSQL Slowness

sp_who2 is one of the most useful and widely used stored procedures, along with its predecessor sp_who. However it is also one of the most frustrating as it only takes a single parameter and the results cannot be ordered. For a large server with a lot of connections this can be a real nuisance. I […]

SQL Server 2012:Reset Password emergency SQL Server 2012: Password emergency If the unthinkable happens and you forget your SQL Server password, there are ways to get back into the system. Saleem Hakani You’re a proud and a trusted DBA at your organization. You’re responsible for maintaining and updating several important services running on SQL Servers in your production environment. […]

SQL Server is started but didn’t listen on any port Question: I newly installed SQL Server 2012. No database created yet. And I can open the Management Studio with sa/password. The Binn\sqlservr.exe is started as a service and I can see it started in the service list. However, it didn’t listening the 1433 port, or even, not listening any port by default, as I […]

Some Mysql commands 1. To select a database mysql> USE database; Mysql cpanel – mysql -uroot -p`grep pass /root/.my.cnf | cut -d ‘”‘ -f 2` 2. To list databases mysql> SHOW DATABASES; 3. To list tables in a db mysql> SHOW TABLES; 4. To describe the format of a table mysql> DESCRIBE table; 5. To create a […]