query

Bookmarks for 18 Apr 2016 through 22 Apr 2016

These are my links for 18 Apr 2016 through 22 Apr 2016:

  • Alfresco: some useful database queries – Blog dbi services – In my previous post, I talked about the Lifecycle of Alfresco Nodes. You may have noticed that I tried to insert in my explanations some elements that are specific to databases (tables, fields, aso…). These elements are quite essential to prepare a post like this one: more database oriented. I already explained what exactly are the consequences on the database side when a node is removed and I will try in this post to share some useful queries regarding these points but not only! For this post, I used my local Alfresco Community 4.2.c installation with a PostgreSQL database. For your information, it just take 30 minutes to get this test environment ready with the Alfresco’s installer (Windows, Mac or Unix). Of course, use the Database only for your daily administration work is certainly not the best idea but in some cases, it can really be faster and easier to just run some SQL commands at the DB level…
  • tweekmonster/tmux2html: :cat2: Render full tmux windows or individual panes as HTML – Render full tmux windows or individual panes as HTML
  • Shrinkpdf – A simple wrapper around Ghostscript to shrink PDFs (as in reduce filesize) under Linux. Inspired by some code I found in an OpenOffice Python script (I think). The script feeds a PDF through Ghostscript, which performs lossy recompression by such methods as downsampling the images to 72dpi. The result should be (but not always is) a much smaller file
  • Cisco ASA privilege separation for a local user or read only user on ASA | yurisk.info
    privilege show level 3 mode exec command running-config username jonghe password Ohsaib1soh privilege 3
  • How to create a read only user in Cisco devices | Cisco & Juniper Networking Note Book
    Here is the thing, can you believe there is no straight forward way to configure a read only user in Cisco devices. If you know any way to do it please correct me here.

Bookmarks for 15 mag 2015 through 17 mag 2015

These are my links for 15 mag 2015 through 17 mag 2015:

Bookmarks for 4 set 2014 through 5 set 2014

These are my links for 4 set 2014 through 5 set 2014:

  • tmux-plugins/tmux-resurrect – Restore tmux environment after a system restart. Tmux is great, except when you have to restart the computer. You lose all the running programs, working directories, pane layouts etc. There are helpful management tools out there, but they require initial configuration and continuous updates as your workflow evolves or you start new projects. tmux-resurrect saves all the little details from your tmux environment so it can be completely restored after a system restart (or when you feel like it). No configuration is required. You should feel like you never quit tmux. http://undeadly.org/cgi?action=article&sid=20140904174329
  • box/Anemometer – This is the Box Anemometer, the MySQL Slow Query Monitor. This tool is used to analyze slow query logs collected from MySQL instances to identify problematic queries.
  • SpamExperts/pyzor – Pyzor is a Python implementation of a spam-blocking networked system that use spam signatures to identify them.

Bookmarks for 2 lug 2014 through 3 lug 2014

These are my links for 2 lug 2014 through 3 lug 2014:

  • Jsfmt – For formatting, searching, and rewriting javascript – For formatting, searching, and rewriting javascript. [ via http://onethingwell.org/post/90463351047 ]
  • dalen/puppet-puppetdbquery – This module implements command line tools and Puppet functions that can be used to query puppetdb. There's also a hiera backend that can be used to return query results from puppetdb.
  • nedap/puppetboard – Puppetboard is a web interface to PuppetDB aiming to replace the reporting functionality of Puppet Dashboard.
  • spotify/puppetexplorer – Puppet Explorer is a web application for PuppetDB that lets you explore your Puppet data. It is made using AngularJS and CoffeeScript and runs entirely on the client side, so the only backend that is needed is PuppetDB itself and a web server to share the static resources.
  • tmux for MobaXterm | techslaves.org – An old friend meets a new friend: tmux for MobaXterm! In a previous sysadmin life, I used tmux to good effect. Today, I’m using a Windows 8.1 system as my primary work desktop and recently got into MobaXterm for my Linux/terminal/X11 needs. While my most common usage scenario for tmux is invoking it on a remote server/VM instead of directly on my local machine, I thought it would be a good exercise to install tmux for local usage on MobaXterm and sharing that work by creating a plugin.

Bookmarks for 2 nov 2012 from 15:23 to 18:09

These are my links for 2 nov 2012 from 15:23 to 18:09:

  • USEFUL ONE-LINE SCRIPTS FOR SED – (Unix stream editor) Dec. 29, 2005
    Compiled by Eric Pement – pemente[at]northpark[dot]edu version 5.5
  • IBM devscan tool – United States – The devscan tool is a supplemental tool used by AIX support personnel to gather debugging data for Storage Area Networks. The package download includes a manual page that is also available on this site at the Usage tab.
  • mysqlreport :: Make easy-to-read MySQL status reports – mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.
  • Percona Online Tools – Welcome to Percona's suite of productivity tools for MySQL database administrators and developers. One free account lets you access all of the tools below, and keeps you updated when new tools or enhancements are available. Registration is required.

    Optimize your MySQL Server:
    Leverage our expertise to create a good starting configuration for a MySQL server.
    This tool will walk you through all of the steps necessary to create a ready to use MySQL configuration file in about 5 minutes.

    Analyze an SQL Query:
    Find out when your SQL is potentially buggy, hard for MySQL to optimize, or confusing.
    This tool will analyze your SQL code and warn you when it detects problems that we've encountered while optimizing thousands of queries in real applications.

Bookmarks for 9 feb 2010 through 10 feb 2010

These are my links for 9 feb 2010 through 10 feb 2010:

  • Andrea Tech Blog: HIVE: Extreme Datawarehousing – HIVE è un progetto di Apache Software Foundation, inizialmente sviluppato da Facebook per permettere ai propri analisti di fare elaborazioni su enormi volumi di dati in totale autonomia[…]
    Un post in italiano sulle possibilità di HIVE
  • Hive – Hadoop Wiki – Hive is a data warehouse infrastructure built on top of Hadoop. It provides tools to enable easy data ETL, a mechanism to put structures on the data, and the capability to querying and analysis of large data sets stored in Hadoop files. Hive defines a simple SQL-like query language, called QL, that enables users familiar with SQL to query the data. At the same time, this language also allows programmers who are familiar with the MapReduce fromwork to be able to plug in their custom mappers and reducers to perform more sophisticated analysis that may not be supported by the built-in capabilities of the language.
  • 500 Internal Server Error – 500 Internal Server Error