Purging SQL Table without impacting the users

This happens very rarely but sometime I have been asked to conditional purge the SQL table without impacting the Users (So we can not use the truncate which is quick and harsh  :) ), These kind of request is pain when client says this table is business critical and used by different application 24/7 so can not take offline and delete the data. So I came up with SQL script or Stored Procedure which will purge the data without impacting the users, though this Proc can run slow or fast based on the Batch Size you have selected, Smaller (not Smallest) the batch size lower the deadlock risk. You can select the Batch and Total deleted row count based on your need. 

Hope, This proc will be useful for you and let me know if required any improvement. I have written this for SQL Server, you can rewrite for any other DB as well after small tweaking

-

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More

Get HTTPS and SSL details of App Deployed - IIB/WMB SCRIPTS

One more to get the HTTPS and SSL details from an Application Deployed in IIB -

- -

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More

Get Rest Flow from WMB/IIB Application - IIB/WMB SCRIPTS

Continuing the same journey with the WMN/IIB Scripts... Sharing another script which will return the REST Flow name from the application deployed on Execution Group ...

=

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More

Get App deployed on Execution Group - IIB/WMB Scripts

Now a days, I am dwelling between Development and DevOps team (which is actually a prod support team....shhhh.....don't tell anyone ;-) ) and got to learn a lot about the team, people (employee vs manager), kind of work they are doing. I believe, In this IT era, if you want your application to survive, Teach your Prod Support Team, Let them Learn and have some techy kind of people in it. Okk...now... llots of blabbering about it.... Let's jump on the real stuff ......

So, Being a Dev/DevOps member, I have created some of IIB/WMB Scripts which I want to share with you one by one.... Sharing a script which will give you the Application Details Deployed on particular EG.....

==
= ==

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More

Create Alias Command with Parameter in Linux

"Alias" - A shortcut for a command or set of commands

Linux OS provides the facility to have alias command to keep the long and frequent command to very few keystrokes, May be I am being a more cryptic with the lots of jargon words, let's try to understand this way -

When you execute a command "ll" (double Ele) in Linux prompt, it will return the result which is the same as "ls -l" because most of the modern linux os have this alias command (ll) for "ls -l" which is quick and easy.  You can add your customize command in ".bashrc" (dot bashrc) in case of  BASH shell or ".kshrc" in case of KORN shell.



How To:
alias pcs = 'ps -ef'  # this will create an alias named pcs which is equivalent to "ps -ef"

As we can see, we can create lots of alias of frequent commands needed in our day to day work, but avoid the alias which modifies/delete system files.

Now, Coming back to the Original Topic,  Can we create an alias which accepts the arguments, Answer is YES, lets check it our How To --

How To create ALIAS which accept command line parameter:

• Create a script which will accept the argument and do the task, such as - 

= =

• Create an alias for this script as - 

==

• How to use this alias - 

==

and voilà !! we are done, Now you can add so many scripts as alias which accept the parameters, Please share here if you have created something useful for you.

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More

yet another In Memory DataBase - MemSQL

Writing this post after so many days, yet another IN-MEMORY database is in market which tag line promised with"The DataBase for Real-Time Applications". 

As per MemSQL site - MemSQL is a scalable SQL database that ingests data continuously to perform operational analytics for the front lines of your business. Ingest millions of events per day with ACID transactions while simultaneously analyzing billions of rows of data in relational SQL, JSON, or Geospatial formats.

In my current assignment, I've been asked to look into the capabilities of this db, so starting with very first step "Installation" - 

Installation in linux is quite simple, if you are OK with linux commands, You can follow the installation from HERE

1. Download the software (with sudo or root user) - 

sudo su - root
wget http://download.memsql.com/memsql-ops-6.0.11/memsql-ops-6.0.11.tar.gz

2. Extract the tar ball

tar zxvf memsql-ops-6.0.11.tar.gz

This command will extract lots n lots of files :-)

3. Run the installer script

cd memsql-ops-6.0.11

sudo ./install.sh --simple-cluster

By default, MemSQL supports the machine with 4 cpu core and 8 GB of RAM (which is little unfair;-)) so remove this constraints by below argument -

cd memsql-ops-6.0.11

sudo ./install.sh --simple-cluster --ignore-min-requirements

After being successful installation of MemSQL, it will start setting up MemSQL WebUI.

You can access the MemSQL WebUI on the sever's 9000 port by default. 

https://<SERVER_IP>:9000

4. To connect to MemSQL command line, execute - 

memsql

In next post, I will explain how this db is different than other in-memory db. Till then, Keep Learning , Keep Loving.

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More

Folder Sharing in Ubuntu Linux with Samba

A Samba file server enables file sharing across different operating systems over a network. It lets you access your desktop files from a laptop and share files with Windows.



Installation -
sudo apt update
sudo apt install samba


Check Installation -
whereis samba

The following should be its output:

samba: /usr/sbin/samba /usr/lib/samba /etc/samba /usr/share/samba /usr/share/man/man7/samba.7.gz /usr/share/man/man8/samba.8.gz


Create samba conf file backup
sudo cp /etc/samba/smb.conf /etc/samba/smb.conf.orig


Add Folder entry in /etc/samba/smb.conf which you want to share as below -

[Friends]                        # share folder name
    path = /home/atul/Desktop/Friends   # folder path
    read only = no                    
    browsable = yes


Start Samba Service
sudo systemctl restart smbd
sudo service smbd restart


Check if all working as configured
testparm


Now, Set password Samba User -
sudo smbpasswd -a <user_name>   # user_name should be existing system user


Share the Folder link to respective users -
Windows User - \\ip-address\Friends
Ubuntu User  - smb://ip-address/Friends

Like the below page to get update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Read More