jtheo

dba

  • Bookmarks for 10 giu 2012 through 15 giu 2012

    These are my links for 10 giu 2012 through 15 giu 2012: Backup automatizzato dei database su SQL Express – SQL Server Express viene distribuito senza SQL Agent, quindi non è possibile schedulare internamente a SQL Server processi automatizzati, come ad esempio il backup. E’ però possibile aggirare questo ostacolo creando uno script ad-hoc, che…

  • Bookmarks for 18 mag 2012 through 20 mag 2012

    These are my links for 18 mag 2012 through 20 mag 2012: Linux system administrator and Oracle DBA guide: How to use rman backup to duplicate database and change db_name – Environment: OL 5.7 32bit, Oracle database 11.2, sid=orcl Objective: duplicate database on the same server then change db_name from orcl to devdb concept: duplicate…

  • Bookmarks for 12 mag 2012 through 16 mag 2012

    These are my links for 12 mag 2012 through 16 mag 2012: Time Zones – Every Time Zone Never warp your brain with time zone math again. [via http://www.delicious.com/farmando ] The Debian Administrator’s Handbook – Written by two Debian developers — Raphaël Hertzog and Roland Mas — the Debian Administrator's Handbook started as a translation…

  • Bookmarks for 5 gen 2012 through 25 gen 2012

    These are my links for 5 gen 2012 through 25 gen 2012: MySQL permissions for backup | OpenConcept Mobile Site – It's a really good idea to use a least-privilege approach to most system administration tasks, and especially automated ones. This post describes using a "read only" MySQL user to handle backing up MySQL databases.…

  • Bookmarks for 20 ago 2011 from 06:00 to 17:41

    These are my links for 20 ago 2011 from 06:00 to 17:41: Percona XtraBackup for InnoDB and XtraDB Data – Percona Software – Percona XtraBackup is the world's only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:<br /> <br…