sql

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 30 dic 2011 through 2 gen 2012

These are my links for 30 dic 2011 through 2 gen 2012:

  • fahd.blog: Find Blocking Processes Using sp_who [Sybase] – If a user has executed an insert/update on a table, but not committed the transaction, other users will find that their queries on the same table hang. This is because the table has been locked and the first user's process is blocking everyone else's.
  • Pocket Survival Guide – NetApp –
  • 30 Best Sources For Linux / *BSD / Unix Documentation On the Web – Here are thirty best documentation sites on the web for learning Linux and Unix like operating systems.
  • OpenShift by Red Hat – What is OpenShift?
    OpenShift, is a portfolio of free, portable cloud services for deploying and managing applications in the cloud. Currently there are two application deployment services offered as part of OpenShift; Express & Flex.

    What is OpenShift Express and when should I use it?
    Express is a free, cloud-based application platform for Java, Perl, PHP, Python, and Ruby applications delivered in a shared-hosting model. With just a few commands you’ll be able to deploy your application to the cloud.

    What is OpenShift Flex and why should I use it?
    Flex is a cloud-based application platform for Java EE and PHP. Applications can be deployed on middleware components such as JBoss and Tomcat. Flex is an ideal platform for those who require a greater degree of control and choice over their middleware components with valuable features including versioning, monitoring and auto-scaling.

  • saidar – saidar is a curses-based tool for viewing the system statistics available through libstatgrab. Statistics include CPU, processes, load, memory, swap, network I/O, disk I/O, and file system information.

    "like a small nmon"
    [ via http://www.spippolazione.net/index.php/2011/12/30/saidar ]

Bookmarks for 23 dic 2011 through 28 dic 2011

These are my links for 23 dic 2011 through 28 dic 2011:

  • E-MailRelay — SMTP proxy and store-and-forward MTA – E-MailRelay is a simple SMTP proxy and store-and-forward message transfer agent (MTA). When running as a proxy all e-mail messages can be passed through a user-defined program, such as a spam filter, which can drop, re-address or edit messages as they pass through. When running as a store-and-forward MTA incoming messages are stored in a local spool directory, and then forwarded to the next SMTP server on request.

    Because of its functional simplicity E-MailRelay is easy to configure, often only requiring the address of the target SMTP server to be put on the command line.

    E-MailRelay can also run as a POP3 server. Messages received over SMTP can be automatically dropped into several independent POP3 mailboxes.

    C++ source code is available for Linux, FreeBSD, MacOS X etc, and Windows. Distribution is under the GNU General Public License V3.

  • IBM developerWorks : Training : Knowledge path : Overview – Knowledge paths are focused learning guides that bring together diverse training resources for IT professionals:
       How-to articles
       Free trial software
       Discussion forums
       Educational videos and podcasts
       Hands-on exercises
    These resources are specifically chosen by subject matter experts, and arranged in sequence to guide you from conceptual awareness to task mastery.
  • Master Sheet Learn VI – The VI editor is a screen-based editor used by many Unix users. The VI editor has powerful features to aid programmers. If you master the use of Vim text editor, it can be a very powerful tool in your hands, and allow you to do amazing text editing feats with just a few taps on your keyboard.

    Many beginning users avoid using VI because the different features overwhelm them. To overcome it and practice it more you can use VI in bash. I have also collected some of the short cut keys which will be useful for you to learn VI

  • XWiki – Open Source Wiki and Content-Oriented Application Platform (Main.WebHome) – XWiki.org – The XWiki project offers both a generic platform for developing collaborative applications using the wiki paradigm and products developed on top of it. All XWiki software is developed in Java and under the LGPL open source license.
    It's also a second generation wiki offering the ability to install and develop small applications inside wiki pages.
    Export wiki pages to PDF, ODT, RTF, XML or HTML. Easily turn Office documents (MS Office, Open Office, PDF, etc) into wiki pages.
    Use XWiki's RESTful and XML/RPC remote APIs to easily integrate XWiki with your application.
    Documents are stored in a relational database. Use your favorite database.
    Create applications by grouping several pages together. Import and export Applications to/from your wiki.
    various authentication mechanisms suported by XWiki (Form, Basic, LDAP, Custom, etc).
    Install/update/remove extensions in/from the wiki
    Allows creating XWiki macros through wiki pages

Bookmarks for 26 apr 2011 through 27 apr 2011

These are my links for 26 apr 2011 through 27 apr 2011:

  • Miniguida: Scrivere il profilo su LinkedIn –
  • OpenPanel – OpenPanel is a free open source control panel. It has lots of functionality, an attractive interface and is very user friendly. OpenPanel is a platform for developers. Because it is extremely open and modular it can be utilised to control any process on a Linux server.
  • Sql Performance Explained – SQL Performance Explained is a free SQL tuning e-book for developers.<br />
    It avoids unnecessary details about database internalsbut highlights the one topic that is most often neglected: proper indexing.

Bookmarks for 11 apr 2011 through 13 apr 2011

These are my links for 11 apr 2011 through 13 apr 2011:

  • 500 Internal Server Error – 500 Internal Server Error
  • 500 Internal Server Error – 500 Internal Server Error
  • DBEdit 2 – DBEdit 2 is a database editor, suitable as front-end for all your relational databases. Connects to Oracle, DB2, MySQL and many other databases.<br />
    Used to easily query, update and administer your database, create reports and synchronize data.<br />
    Written in Java and uses the features of JDBC to their fullest.

Bookmarks for 8 nov 2010 through 10 nov 2010

These are my links for 8 nov 2010 through 10 nov 2010:

  • TOra – TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.<br />
    In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.<br />
    <br />
    [ via www.ossblog.it ]
  • SQL for Tivoli Storage Manager – This page has a collection of useful SQL statements for IBM Tivoli Storage Manager (TSM). Here you can find out a lot of selects that will help you to get information from TSM and to construct your own SQL statements.
  • Cheat Sheet : All Cheat Sheets in one page – The Manual.su's project. All cheat sheets, round-ups, quick reference cards, quick reference guides and quick reference sheets in one page. The only one you need.<br />
    <br />
    [ via http://www.delicious.com/pecus ]

Bookmarks for 2 ago 2010 from 17:06 to 17:14

These are my links for 2 ago 2010 from 17:06 to 17:14:

  • LasCon Storage – TSM Scripting Hints and Tips – Send offsite and recall Copy tapes <br />
    Free up tapes which are almost empty <br />
    Multiple macro commands <br />
    Exporting scripts <br />
    Updating Netware Client Passwords
  • LasCon Storage – TSM Administration – Tivoli is part of IBM, and they provide a suite of management products for distributed systems. TSM used to be called ADSM and works on the 'incremental backup forever' principle, which takes a bit of getting used to, compared to the more traditional 'weekly full backup and daily incremental' system. With TSM, you backup all your clients to one central data backup server. This makes administration a lot easier, but means you have to limit the amount of data you send over the network. That's why TSM needs to be incremental. A central database records all backup information, and can be used to recreate a whole server if necessary. TSM always keeps at least one backup of every on-line file.
  • Shan’s "Fix IT in 1 Minute!" UNIX Admin Blog – Welcome to "Fix IT in 1 Minute!" – Shan Jing's UNIX Administration blog. It covers Solaris, Linux, AIX, Web; Unix/TCP/IP Internal Programming (C/Python/Perl); TCP/IP Protocols and Services (DNS, NIS, Kerberos, LDAP, SSH, Openssl, etc.); Shell scripting,Perl /Web XML/DBMS SQL; Security & Intrusion Detection (nmap,snort); Enterprise Web Middleware and Backend: WebLogic/Tomcat/Java/JSP/Web Applications; Grid Computing, Python/Django Web Framework, etc.

Bookmarks for 2 lug 2010 from 16:04 to 16:14

These are my links for 2 lug 2010 from 16:04 to 16:14:

  • migrazione RedHat Enterprise Linux a CentOS eseguita! – Lo scorso anno acquistammo un serverino – dischi in fiber channel, 4 cpu quadcore, 32GB di RAM … la solita roba, insomma – con su Red Hat Enterprise Linux. Ovviamente quest’anno allo scadere della licenza non ci sono i fondi per proseguire con gli abbonamenti annuali…Che si fa? Si migra a CentOS, ovviamente!<br />
    Per fortuna la procedura di migrazione è stata semplice, immediata e rispettosa del tutorial proposto nell’apposita pagina del wiki ufficiale.
  • Backup su HSDPA con router Linux – La settimana scorsa Stefano ha avuto un down tremendo della HDSL, più di 72 ore, quasi insopportabili per una azienda al giorno d’oggi. Per questo motivo mi ha chiesto di aggiungere al firewall/router che già gestisce le policy di rete, un backup su HSDPA automatico che attivi la connessione su 3G non appena il link ADSL cade.<br />
    <br />
    Ho cercato in rete se esisteva già qualche setup, ma ho trovato solo una guida per zeroshell e alcune discussioni su forum che però non erano pienamente esaustive.
  • MySQL Forge :: Dashboard – MySQL Forge is a repository of tools, projects, roadmap tasks, and wiki content that is created and maintained by the MySQL user and developer community. It is intended to be a resource for learning, contributing, and sharing information and code with each other.<br />
    <br />
    The Forge also has a section devoted to the people that compose the greater MySQL user and developer community.
  • rhomobile – the open mobile framework – Rhodes is an open source framework to rapidly build NATIVE apps for all major smartphone operating systems (iPhone, Windows Mobile, RIM, Symbian and Android). These are true native device applications (NOT mobile web apps) which work with synchronized local data and take advantage of device capabilities such as GPS, PIM contacts and camera.<br />
    <br />
    [via http://blog.fabriziogiordano.it/2010/07/02/rhodes-2-0-sviluppare-applicazioni-per-smartphone/]

Bookmarks for 24 mag 2010 through 26 mag 2010

These are my links for 24 mag 2010 through 26 mag 2010: