Blog Spot!


7 Handy SQL Scripts for SQL Developers

7 Handy SQL Scripts for SQL Developers

  1. Search for Text Inside All the SQL Procedures
  2. Compare Row Counts in Tables From Two Different Databases With the Same Schema
  3. Back Up Multiple Databases at Once
  4. Shrink Multiple Database Logs at Once
  5. Restrict Connection to the Database by Setting Single-User Mode
  6. String Function in SQL to Generate Dynamic Texts
  7. Printing Table Column Definitions

code.tutsplus

Added on 13.May.2016
Tags: sql scripts developers

Check distribution version you are running on your Linux system

lsb_release -da

Tested on Debian bases systems only

Added on 13.May.2016
Tags: debian ubuntu mint version distribution check

Make 'rm' move to trash doirecory

Start by defining a move_to_trash function:

move_to_trash () {
    mv "$@" ~/.trash
}

Then alias rm to that:

alias rm='move_to_trash'

You can always call old rm by escaping it with a backslash, like this: \rm.

Added on 10.May.2016
Tags: linux commands trash functions alias

Simple Cron and Crontab example

Minutes [0-59]  
|   Hours [0-23]  
|   |   Days [1-31]  
|   |   |   Months [1-12]  
|   |   |   |   Days of the Week [Numeric, 0-6]  
|   |   |   |   |  
*   *   *   *   * home/path/to/command/the_command.sh  

59 23 * * * home/path/to/command/the_command.sh 

Added on 27.Apr.2016
Tags: cron crontab example

Install Grub Customizer in Ubuntu 14.04 to Manage Your Grub Bootloader

Grub Customizer is a graphical tool for managing the Grub boot entries in Ubuntu Linux.

sudo add-apt-repository ppa:danielrichter2007/grub-customizer
sudo apt-get update
sudo apt-get install grub-customizer

ubuntuhandbook

Added on 22.Apr.2016
Tags: grub ubuntu linux customizer

Search


PHP Libraries


Carbon lib / docs
Idiorm lib / docs
Image Workshop lib / docs
lorenzos/Minixed lib / docs
Parsedown lib / docs
PHP Paginator lib / docs
PHP Redis lib / docs
QrCode lib / docs
Requests lib / docs
Slim lib / docs
Spyc lib / docs
TWIG lib / docs
Upload lib / docs
Validation lib / docs
Zebra Image lib / docs

JS Libraries


AJV lib / docs
BackboneJS lib / docs
Bootstrap Notify lib / docs
C3.js lib / docs
ChartJS lib / docs
FastMD5 lib / docs
HighlightJS lib / docs
jQuery-Storage lib / docs
JS-Cookie lib / docs
Leaflet JS lib / docs
LowDB lib / docs
Marked lib / docs
NeedlyJS lib / docs
ParcelJS lib / docs
RequireJS lib / docs
Swig lib / docs
Toastr lib / docs
Underscore lib / docs
ValidateJS lib / docs
top