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 si occupi dei vari job che vogliamo eseguire.
  • PacketFence: Open Source NAC (Network Access Control) – PacketFence is a fully supported, trusted, Free and Open Source network access control (NAC) solution. Boasting an impressive feature set including a captive-portal for registration and remediation, centralized wired and wireless management, powerful guest management options, 802.1X support, layer-2 isolation of problematic devices; PacketFence can be used to effectively secure networks small to very large heterogeneous networks.
  • teambox/teambox · GitHub – Open-source project collaboration software, available online for free. Inspired by Basecamp, Yammer, Twitter.

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 line in /etc/oratab, make orcl and devdb instance, then make everything in password file, spfile/pfile, controlfile, redo log, data file from orcl to devdb, only leave db_name in pfile/spfile as orcl for rman restore from orcl database backup, then use nid to change db_name
  • Linux system administrator and Oracle DBA guide: How to add LUN disk online under CentOS 6.2 – Environment: CentOS 6.2 64bit with multipath connected to HP EVA storage, the LUN disk was LVM disk
    Objective: add a new LUN disk for server online and add into the existing LVM to make the partition size bigger
    scenario: LVM add new lun disk, increase the existing lvm lun disk, increase the existing partition disk such as /dev/sda1
  • Git Client – SmartGit – SmartGit is a graphical client for the Open Source version control systems Git, Mercurial and SVN. It runs on Windows, Mac OS X and Linux.
    SmartGit helps Git and Mercurial beginners to get started quickly and lets advanced users become more productive with its efficient user interface.

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 of their French best-seller known as Cahier de l'admin Debian (published by Eyrolles). It's a fantastic resource for all users of a Debian-based distribution. Accessible to all, this book teaches the essentials to anyone who wants to become an effective and independant Debian GNU/Linux administrator.
  • Oracle Italia by Massimo Ruocchio – Ho finalmente finito di scrivere il manuale Oracle “Welcome to Oracle” disponibile gratuitamente su questo sito sotto licenza Commons Creative (tutti i dettagli nella “nota sul diritto d’autore” all’interno del libro).

    Il manuale si rivolge sia ai principianti che agli utilizzatori di Oracle già esperti.

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.

    We use mysqldump to backup our databases on a regular basis, using scripts like this one

  • MuckNet » Blog Archive » MySQL Permissions for backup using mysqldump and/or ec2-consistent-snapshot – Using root for your MySQL backups is a bad idea boys and girls. You should dedicate a user to doing your backups. Below are a few options for setting up minimum permissions for your dedicated mysql backup user

    [memento mori]

  • Tiki Wiki CMS Groupware | Tiki Wiki CMS Groupware – Software made the wiki way. – What is Tiki Wiki CMS Groupware? Tiki is a powerful, web-based application, created by a large team of contributors. Tiki is the ideal tool for you to build and maintain your Website/Wiki/Groupware/CMS/Forum/Blog/Bug Tracker or any other project you can imagine running in your browser window.

    Tiki is free, both Free Software (as in "Free Speech") and Free of Charge (as in "Free Beer"), and for everyone! It has all the features you need "out-of-the-box":
    Wikis (like Wikipedia)
    Forums (like phpBB)
    Blogs (like WordPress)
    Articles (like Yahoo News)
    Image Gallery (like Flickr)
    Map Server (like Google Maps)
    Link Directory (like DMOZ)
    Multilingual (like Babel Fish)
    Bug Tracker (like Bugzilla)
    RSS Feeds (like Digg)
    Free Open Source software (LGPL)

    [ via http://www.gpaterno.com/2011/12/23/create-a-secure-intranetextranet-with-tikiwiki-and-securepass/ ]

  • Create a secure intranet/extranet with TikiWiki and SecurePass – Giuseppe Paternò – […]
    In this market segment, there’s still a need for a secure corporate intranet with the need to exchange private information and files. Collaborative places, such as wikis, are perfect solutions to quickly achieve this goal without spending a fortune. I found TikiWiki (http://www.tiki.org/) to suit best in these environments: while extremely easy to use for an end-user through WYSYWIG editor, the complex permission system allow you to set each page access or even show/hide part of the page to a given group of users, which is unique if compared to other solutions
    […]

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 />
    Backups that complete quickly and reliably<br />
    Uninterrupted transaction processing during backups<br />
    Savings on disk space and network bandwidth<br />
    Automatic backup verification<br />
    Higher uptime due to faster restore time<br />
    XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups.
  • The Ethical Hacker Network – Free Armitage and Metasploit Video Training Course – Armitage is a front-end for Metasploit that allows team collaboration and exposes the advanced features of the framework. Raphael Mudge has made a six-part training series on Armitage and Metasploit for the ethicalhacker.net community. These demonstration-heavy lectures introduce the penetration testing process and walk you through each step. You'll learn how to break into hosts, carry out post-exploitation activities, develop more access from your initial foothold, and you'll do this in a team environment.
  • 500 Internal Server Error – 500 Internal Server Error

Bookmarks for 14 giu 2011 from 23:47 to 23:49

These are my links for 14 giu 2011 from 23:47 to 23:49:

  • Esportare e importare database MySQL di grosse dimensioni – […] Nel tempo ho selezionato alcuni script e programmi che mi facilitano di molto quando ho la necessità di importare/esportare database MySQL di grosse dimensioni[…]
  • Chart.io – Chart.io is Google Analytics for your database. We help you make sense of all the data you collect everyday. Chart.io quickly hooks up to your database and lets you create real time charts of the metrics you care about.<br />
    <br />
    [ via http://www.bufferoverflow.it ]
  • Asciiflow – ASCII Flow Diagram Tool – Simple web based ascii flow diagram drawing tool, draw boxes, lines, arrows and type, then export straight to text/html<br />
    <br />
    [via http://www.afhome.org ]

Bookmarks for 4 apr 2011 through 9 apr 2011

These are my links for 4 apr 2011 through 9 apr 2011:

  • 500 Internal Server Error – 500 Internal Server Error
  • www.vanheusden.com – optimizing for MySQL – On this page I collect tips & tricks on how to optimize your system for running MySQL. Some tips are in general usefull for optimizing your system.
  • BSDCertification.org – The BSD Certification Group Inc. is a non-profit organization committed to creating and maintaining a global certification standard for system administration on BSD based operating systems[…]

Bookmarks for 24 set 2010 through 28 set 2010

These are my links for 24 set 2010 through 28 set 2010:

  • xCAT – Extreme Cloud Administration Toolkit – xCAT offers complete and ideal management for HPC clusters, RenderFarms, Grids, WebFarms, Online Gaming Infrastructure, Clouds, Datacenters, and whatever tomorrow's buzzwords may be. It is agile, extendable, and based on years of system administration best practices and experience.
  • CoolSQL-Database-JDBC, Ibatis-Ibator(Abator) – CoolSQL is a cool tool used to view and manage database. It provides a nice user interface which makes a wonderful experience to user. CoolSQL inclineds to view and analyze data in the database, provides abundant functions including querying, modifying, exporting, supporting sqlscript and analyzing data. Convenience and maneuverability are the most advantages of CoolSQL. CoolSQL is written in java, thus it should run on any operating system that provides a Java Runtime (1.5 or above).
  • ottimizzazioni (quasi) estreme – In fondo, perché far ricomprimere ad Apache lo stesso file centomila volte al giorno, se questo non cambia praticamente mai? Non sarebbe possibile comprimerlo “a priori” e poi istruire il server a fornire la giusta versione a seconda che il browser dell’utente supporti o meno il formato gzip? A quanto pare la risposta è si
  • Trouble-Maker – Being a system administrator is full of interesting challenges. We like this. However, some of these challenges can be problematic, if they cause service interrupts on production systems. Most system administrators have run into the situation where something is wrong, the server is down, and we don't know what is going on. This project attempts to help.<br />
    <br />
    There are a lot of tools out there to make the system administrator's life easier. However, no tool is a replacement for properly understanding the system and experience in troubleshooting unknown situations. This is where Trouble-Maker comes in. Unlike other projects, we do not attempt to solve problems — we cause them.
  • iScanner – Remove website malwares, web pages viruses and malicious codes – iScanner is a free open source tool lets you detect and remove malicious codes and web page malwares from your website easily and automatically. iScanner will not only show you the infected files in your server but it's also able to clean these files by removing the malware code ONLY from the infected files.<br />
    <br />
    [ via http://www.bufferoverflow.it/ ]

Bookmarks for 8 apr 2010 through 14 apr 2010

These are my links for 8 apr 2010 through 14 apr 2010:

Bookmarks for 11 dic 2009 through 15 dic 2009

These are my links for 11 dic 2009 through 15 dic 2009:

  • ASCII Paint – Enjoy drawing and viewing some crazy ascii art. Output can be in C/C++/Java style comments Assembly comments, or the million other languages that support the # – sign comments.

    Use the buttons to change what your cursor does. Hit whatever key on the keyboard you want to be drawing with.

    If you make something cool, share it! It will be added to our database of ascii art, which will become much more accessible as time goes on. Right now you can only see random Ascii Art, but there will be a voting system shortly.

    via LevySoft

  • Scapy – Scapy is a powerful interactive packet manipulation program. It is able to forge or decode packets of a wide number of protocols, send them on the wire, capture them, match requests and replies, and much more. It can easily handle most classical tasks like scanning, tracerouting, probing, unit tests, attacks or network discovery (it can replace hping, 85% of nmap, arpspoof, arp-sk, arping, tcpdump, tethereal, p0f, etc.). It also performs very well at a lot of other specific tasks that most other tools can't handle, like sending invalid frames, injecting your own 802.11 frames, combining technics (VLAN hopping+ARP cache poisoning, VOIP decoding on WEP encrypted channel, …), etc.

    via downloadblog.it

  • Mac usati e iPod usati / MacExchange – annunci di Mac o iPod usati

    via http://www.bufferoverflow.it/

  • Top 20+ MySQL Best Practices – Nettuts+ – Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.
  • Stacklet | Create Virtual Images On The Fly – This site will be the home of all development of the stacklet engine, a new way of creating bootable images for virtualization software such as Xen. In addition to hosting the software for creating images, the site will have pre-built images spanning various operating systems, distributions and application niches. This is a large undertaking and hopefully by opening the software we can elicit multiple contributors and contributions.