sql

Bookmarks for 8 Mar 2016 through 14 Mar 2016

These are my links for 8 Mar 2016 through 14 Mar 2016:

  • Zsoldier’s Tech Blog: Add Portgroups/VLANs to vmware standard switches via PowerCLI – Wrote a simple little script to insert a portgroup into a targeted vSwitch of all VM hosts in a targeted cluster. This is not an issue if you use distributed vSwitches.
  • siph0n – exploits : leaks : dumps : papers : hashes – Hello and welcome to "siph0n", we are a group of security enthusiasts that want to make people
    more aware of security risks and the risks behind compromised(stolen) data.
    By using this Site, you signify your assent to these Terms of Service if you do not agree to any of these conditions,
    do not use this website.
  • Hardening Framework – […] Server hardening is a well-known topic with many guides out in the wild. Why this project? At Deutsche Telekom we need to manage thousands of servers for customers and ourselves. All servers need to be configured properly and maintained, which is difficult and time-consuming to get right. To answer these needs for security, compliance, and maintainability, we decided to launch this project as a common ground for requirements and their fulfillment.[…]
  • Node-RED – Node-RED is a tool for wiring together hardware devices, APIs and online services in new and interesting ways.
  • zachlatta/sshtron: Play Tron over SSH – SSHTron is a multiplayer lightcycle game that runs through SSH

Bookmarks for 26 nov 2014 from 20:02 to 21:26

These are my links for 26 nov 2014 from 20:02 to 21:26:

  • xat/castnow · GitHub – castnow is commandline utility which can be used to playback media files on your chromecast device. It supports playback of local video files, youtube clips, videos on the web and torrents. You can also re-attach a running playback session
  • FnordMetric | Framework for building beautiful real-time dashboards – FnordMetric ChartSQL FnordMetric ChartSQL allows you to write SQL queries that return charts instead of tables. The charts are rendered as SVG vector graphics and can easily be embedded into any website and customized with css in order to build beautiful dashboards FnordMetric Server Fnordmetric Server is a standalone HTTP server application. It exposes a web UI and a HTTP API to run ChartSQL queries and collect timeseries data. You can use fnordmetric-server as a one-stop solution for metric collection and charting. Since fnordmetric-server aims to be a StatsD+graphite competitor, it implements a wire compatible StatsD API. FnordMetric Server can store the collected timeseries data on local disk or in external storage (HBase).
  • imapfilter – lefcha – IMAPFilter is a mail filtering utility. It connects to remote mail servers using the Internet Message Access Protocol (IMAP), sends searching queries to the server and processes mailboxes based on the results. It can be used to delete, copy, move, flag, etc. messages residing in mailboxes at the same or different mail servers. The 4rev1 and 4 versions of the IMAP protocol are supported. IMAPFilter uses the Lua programming language as a configuration and extension language.

Bookmarks for 5 nov 2014 from 10:48 to 13:51

These are my links for 5 nov 2014 from 10:48 to 13:51:

  • Configuring OpenLDAP pass-through authentication to Active Directory – Alex Tcherniakhovski – Security – Site Home – MSDN Blogs – This particular functionality of OpenLDAP should be of special interest for environments where long term co-existence between OpenLDAP and Active Directory is required. By establishing pass-through authentication the following advantages could be achieved: Great end-user experience. No need to remember multiple passwords Increased security, due to the reduction of the attack surface (one less password store in the environment) Single password policy The rest of the post will expand on the instructions provided by the OpenLDAP 2.4 Administration guide on establishing pass-through authentication from OpenLDAP to Active Directory. Specifically, will will leverage the capability of SASL to use LDAP as an authentication back-end. In our case, Active Directory will play a role of such authentication back-end.
  • Books – UNIX Systems Programming (BSD) – BitsInTheWind.com – ISBN 10: 0-937175-23-4 / ISBN 13: 9780937175231  O'Reilly & Associates January 1989 The following are made available for your personal, non-commercial use only. You may cite this document as a bibliographic reference in any works that you are writing. Any commercial use of this document, including printing and distribution to groups of people (such as a classroom) is prohibited without my prior written permission.
  • osquery – With osquery, you can use SQL to query low-level operating system information. Under the hood, instead of querying static tables, these queries dynamically execute high-performance native code. The results of the SQL query are transparently returned to you quickly and easily.
  • Boxupp – GUI tool to manage Puppet & Vagrant based project environments | Paxcel – Boxupp makes it easy for integrated management of development stacks over Vagrant and Puppet. Initially built over these two softwares, we plan to add support for more providers and provisioners * Integrated management environment for Vagrant and Puppet * Intelligence at its core * Simple Web GUI * Easy provisioning * Inbuilt console and editors * Start right from level zero ! * Share your configurations with team members.

Bookmarks for 24 ott 2014 through 27 ott 2014

These are my links for 24 ott 2014 through 27 ott 2014:

  • VimSwitch: Use Your Vim Settings Everwhere – So you've customized vim just the way you want it. But as soon as you jump on a remote machine or a friend's PC, you lose all your settings. Well fear no longer! VimSwitch is here to save the day. VimSwitch makes it easy to switch to your vim profile on any machine. As long as you have your vim settings up on GitHub (For example: priomsrb/vimrc), switching to it is as easy as: # ./vimswitch priomsrb/vimrc When you're done, you can restore your previous vim settings with: # ./vimswitch default [ via http://onethingwell.org/post/100747819722/vimswitch ]
  • The Deploy vs Deployers directory, JBoss v5.x – JBoss ships with a few configurations that are meant to provide examples of how JBoss can be configured for your environment. It’s recommend you take the “default” configuration (or “all” if you require clustering), and then slim it down by removing the various mbean components found in the “jboss/server//deployers” and “jboss/server//deploy” folders until only your minimum requirements are met.
  • Kylin OLAP Engine for Big Data | Home – Kylin is an open source Distributed Analytics Engine from eBay Inc. that provides SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets

Bookmarks for 2 set 2014 through 3 set 2014

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

  • Overview – The Apache James Project delivers a rich set of open source modules and libraries, written in Java, related to Internet mail communication which build into an advanced enterprise mail server.
  • Archiveopteryx – Archiveopteryx stores email in a database and provides access to it through IMAP and more.
  • Fluentd | Open Source Data Collector – Fluentd is an open source data collector for unified logging layer. Fluentd allows you to unify data collection and consumption for a better use and understanding of data.

Bookmarks for 6 ago 2013 through 8 ago 2013

These are my links for 6 ago 2013 through 8 ago 2013:

  • harelba/q · GitHub – Have you ever stared at a text file on the screen, hoping it would have been a database so you could ask anything you want about it? I had that feeling many times, and I've finally understood that it's not the database that I want. It's the language – SQL. SQL is a declarative language for data, and as such it allows me to define what I want without caring about how exactly it's done. This is the reason SQL is so powerful, because it treats data as data and not as bits and bytes (and chars). The goal of this tool is to provide a bridge between the world of text files and of SQL. q allows performing SQL-like statements on tabular text data.
  • rome2rio: discover how to get anywhere – Discover how to get anywhere by searching plane, train, bus, car and ferry routes [ via http://braindead.tumblr.com/post/57525353007 ]
  • WildFly – JBoss Application Server has a new name… WildFly. – JBoss Application Server has a new name… and it's even @#$%ing faster.

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 ott 2012 from 10:37 to 20:19

These are my links for 9 ott 2012 from 10:37 to 20:19:

  • notepadqq/notepadqq · GitHub – Linux clone of notepad++
  • Top 10 things you must read about vSphere 5.1 – Welcome to vSphere-land! – There has been so many documents, white papers, videos and blog posts posted about the vSphere 5.1 release that it’s hard to keep up with them all. I have at least 250 links gathered in my vSphere 5.1 Link-o-rama and it is still growing. With so many links it’s easy to miss some of the really good ones so I thought I would put together a top 10 list that highlights the ones that you don’t want to miss.
  • Three things you should never put in your database | Revolution Systems – As I've said in a few talks, the best way to improve your systems is by first not doing "dumb things". I don't mean you or your development staff is "dumb", it's easy to overlook the implications of these types of decisions and not realize how bad they are for maintainability let alone scaling. As a consultant I see this stuff all of the time and I have yet to ever see it work out well for anyone.

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 17 mag 2012 through 18 mag 2012

These are my links for 17 mag 2012 through 18 mag 2012:

  • vikjon’s Linux and Media Center Howto: NSClient++ external vbs script to check MSSQL jobs – This script for NSClient++ checks if there is any failed jobs in MS SQL server. The database connection data is stored in a UDL file.
  • Mobile-OTP: Strong Two-Factor Authentication with Mobile Phones – Mobile One Time Passwords (Mobile-OTP)
    strong, two-factor authentication with mobile phones

    Using static passwords for authentication, as it is commonly done, has quite a few security drawbacks: passwords can be guessed, forgotten, written down and stolen, eavesdropped or deliberately being told to other people.
    A better, more secure way of authentication is the so called "two-factor" or "strong authentication" based on one time passwords. Instead of authenticating with a simple password, each user carries a device ("token") to generate passwords that are valid only one time.

    client for: Standard phone and BlackBerry (J2ME) iPhone Google Android Windows Phone 7 PalmOS webOS Maemo Openmoko Universal Web App Windows Linux MacOS

    Server-Side:
    Mobile-OTP Authentication Server (MOTP-AS)
    Full blown RADIUS server specifically for Mobile-OTP. include:
    – authenticating users by RADIUS (and optionally PAM or Apache)
    – SQL database for user/device configuration
    – Administration Web Interface

  • Open Monitoring Distribution – Wiki – OMD – Welcome to OMD – the Open Monitoring Distribution. OMD implements a completely new concept of how to install, maintain and update a monitoring system built on Nagios.

    OMD avoids the tedious work of manually compiling and integrating Nagios addons while at the same time avoiding the problems of pre-packaged installations coming with your Linux distribution, which are most times outdated and provide no regular updates.

    OMD bundles Nagios together with many important addons and can easily be installed on every major Linux distribution. We provide prebuilt packages for all enterprise Linux distributions and also for some other, such as Ubuntu 11.04.