Sunday, November 22, 2015

SQL keyboard shorcuts for Frequently used queries

If you work extensively with MS SQL SSMS, you would be looking for a way to reuse the queries instead of typing it all over again. Something like a shortcut for the frequently used queries.

I Use the following ways and methods to access the SQL queries that I frequently use

Setting keyboard shortcuts in SSMS.

Tools > Option > Environment > KeyBoard
There are 11 available shortcuts u can set.

To execute, in the query window
for example the table Orders in the DB NorthWind
you need to just write "Orders" in your query window and select the word and hit Ctrl+0 
As you can see in the screenshot above, it will exec the statement
"Select * from Orders" and get you all the records in your DB.

Unfortunately We are not able to add more shortcuts to SSMS. after lil googling , I found this cool tool called Clavier+

where you can store all your frequently used queries

The other Feature of this is that, you can launch any program with a shortcut, also you can use it to launch any file that you frequently open.


Note: Suppose you set a shortcut for keys such as Ctrl+C , V then the action that you specify here will take place instead of the OS's Copy Paste function.

Tuesday, September 15, 2015

SSIS Log Simplifier

Here's a simple tool made on winforms that will help you simplify the log files generated by the execution of SSIS packages .

Analysis of the log file may take up large quantities of time,
ie. to find an error that occurred during the execution of the packages we use search function in notepad to traverse through the log file generated by the package execution. 

This tool will help ease up the process by providing a parsed HTML file which is readable version of the log file, highlighting and grouping the errors and warnings thus making it easy to find the error quicker. 

Read on to find out more

1. Launch SSIS PILL .exe

2. Click on Get Files after 

  •     Selecting your folder that contains the SSIS log files
  •     Click on Get Files - on the left side all files in the selected directory will be displayed
  •     This will show the status of the file like success or failure and time taken
  •     This is a pictorial indication that the file is a success
  •     These are where warnings are displayed

3. On selection of file with error records

  •     Now the picture is different for log files with ERRORS.
  •     The first grid shows the ERRORS and the second the WARNINGS
  •     This thing works full screen too

4. Click on Open In HTML for Parsed Log File, the parsed file will open in browser.
As you can see this is in  a better readable format.

  • Has status of execution at the top
  • First grid is of ERRORS
  • Second Grid is of WARNINGS

5. Other buttons

Export to HTML will Create a directory in the same as your parent directory of your log folder and place the Parsed HTML files there.

Open in HTML will open the selected log file's parsed format like in step 4 in the browser

Open in Text - will open normally in a text editor

6. Mail
Export - Mail will add the attachment of the parsed log file and open up outlook ready to send.

(you can configure default path for the log folder and the email id to which mail needs to be sent in the config file )

If the above setup file doesnt work then use the one below, extract from the zip folder and run the SSISLogSimplifier.exe file

Monday, September 1, 2014

Rooting and flashing Sony Xperia J ST26i

Writing this post after successfully flashing Sony Xperia J ST26i with DARK MOON AVD ROM

I followed the instructions given in


Take a backup of your contacts, sd card etc. I used My phone Explorer

Update the phone's firmware
Go to Settings > About phone > Software updates > System updates
or use SONY PC Companion


Unlock BootLoader
Followed the steps given here

How to Unlock Bootloader of Sony Xperia Devices (official and universal tutorial)
  1. Go here and check whether your smartphone is on the “unlock bootloader” list or not. If your phone is not listed there it means that you cannot use this guide for unlocking the system.
  2. Also, on your handset type and dial: *#*#7378423#*#*; then go to “Service info -> Configuration -> Rooting Status” and check if the “Bootloader unlock allowed” says yes. If the “no” answer will be displayed then you will not be able to unlock the bootloader of your device.
  3. Now, extract the file named “” (which has been downloaded before) on your computer.
  4. Then, copy the obtained file (“android_winusb.inf”) to path c:\android-sdk\extras\google\usb_driver.
  5. Click yes if asked to overwrite something.
  6. Type *#06# on your phone and get the IMEI number; write it down as you will need it a little bit later.
  7. Now, go here.
  8. On the first page click on “Yes, I’m sure”.
  9. Agree to Sony’s legal terms and then hit “I accept”.
  10. On the next page enter your name, email and your device’s IMEI number and click on “Submit”.
  11. An unlock code will now be offered; note it down.
  12. Turn off your device and connect the same with the computer by pressing on the Menu button (for the Xperia arc, Xperia arc S, Xperia neo, Xperia neo V, Xperia pro handsets), or on the Search button (for the Xperia Play device) or on the Volume Up button (for the Xperia mini, Xperia mini pro, Xperia ray, Xperia active, Live with Walkman, Xperia S smartphones).
  13. Install the drivers on the path mentioned above (c:\android-sdk\extras\google\usb_driver).
  14. Now, on your computer open command prompt: “start -> run -> type cmd”.
  15. On the cmd window enter the following commands (one at a time): cd C:\android-sdk\platform-tools; fastboot.exe -i 0x0fce getvar version; fastboot.exe -i 0x0fce oem unlock 0xKEY (replace key with the code obtained before).
  16. That’s all, now the bootloader will be unlocked.
  17. In the end, remove the USB cable and reboot your smartphone.

Problem Faced: STEP 13  The driver to be installed was not accepted by the system.
Hold down the Windows key on your keyboard and press the letter C to open the Charm menu, then click the gear icon (Settings).

Click More PC Settings.

Click General.

Under Advanced Startup, click Restart Now.

NOTE: In Windows 8.1, the ‘Restart Now’ button has moved to ‘PC Setting -> Update & Recovery -> Recovery.’

After restarting, click Troubleshoot.

Click Advanced Options.

Click Windows Startup Settings.

Click Restart.

After restarting your computer a second time, choose Disable driver signature enforcement from the list by typing the number 7 on your keyboard.

Your computer will restart automatically.

After restarting, you will be able to install the  drivers normally; however, Windows will display a warning message. When the warning appears, click Install this driver software anyway

Soln from:

So after unlocking your bootLoader.


Download from here
AVD Rom Latest Release

Addon Archive

Kernel ftf

place Rom & Addon zip on externel sdcard

Place the downloaded file ClockworkMod- into the folder  C:\android-sdk\platform-tools

  • Download ClockworkMod from the link above
  • Switch off phone
  • Hold Vol-UP button
  • Insert USB cable, wait for blue light
On the cmd window enter the following commands (one at a time): cd C:\android-sdk\platform-tools
run fastboot flash boot ClockworkMod-

and then type
run fastboot reboot

  • when the purple LED shines, press and hold the Vol-UP button
You are now in ClockworkMod Recovery!

Wipe data/factory reset, wipe cache partiton, go to advanced wipe dalvik cache. then go to mounts & storage format system.

Go to install zip from sdcard choose zip from externel sdcard. flash rom

when installation is finished go back to advanced choose fix permissions


Now we need to download and install flashtool 
After installing it. 

The Kernel ftf  that you downloaded
"st26i_11.2.A.0.31 Kernel By Gavster26@XDA_Central Europe.ftf" needs to be extracted. 
You need to have 7Zip or any other file extracting programs.
Once you are done extracting you will find a file called kernel.sin 

follow the instructions in the video
Note: u need to browse for the kernel.sin file that you extracted.

Note:Be careful while browsing and selecting the right file, I happened to choose the wrong one and my phone would not startUp but I retried with the right file and it worked.
Now Flashing of new kernel is done.


Next for Addon Package: It is the same as the instructions in part 3. 
Except that here we select the addon package zip from sd card 
After that follow PART 4 (Flash the kernel again)

The file you downloaded extract it and place the files on sd card.

Download Root Browser place it on ur phone SD card.

Start your phone and install the RootBrowser APK that you downloaded.

Now open it up and copy systemui.apk from the extracted files of to /system/app give permissions rw-r-r
Note: there will already be a copy of systemui.apk rename it to sytemui_copy.apk and then push/copy the file. Tap and hold on the file for long and select permissions from the menu and give it as rw-r-r

Similarly copy  framework.jar to system/framework give permissions rw-r-r
Note: there will already be a copy of framework.jar rename it to framework.jar_copy.apk and then push/copy the file. Tap and hold on the file for long and select permissions from the menu and give it as rw-r-r

You are done.
Be careful while flashing/rooting/unlocking as the methods vary from each model.
Refer XDA forums when in doubt.

Sunday, August 31, 2014

Top 5 reasons to root your Android device

1. Increase Internal memory
2. Fix any broken button
3. Better ROMS
4. Better Looks
5. Performance

If you have an Android phone and in need of any of the above for your phone. Then you need to root your android phone.

Rooting is a means of unlocking the device's capability allowing the user to have complete control.
Rooting method is different for different phone. Lookit up well before you proceed.
For more info:

Tuesday, May 27, 2014

Remove HulaToo adware manually

HulaToo is an Adware that puts ads on ur browsers and slows down ur system. It comes with unwanted downloads.

HulaToo Ads
Anyways if you begin to see HulaToo ads on ur browsers its safe to remove them.

1. Go to Control Panel and select Install/Uninstall Software and select HulaToo and Unistall it.

2. Reset ur Browsers.

3. Go to Win+R type regedit and hit ctrl + F and search for HulaToo and delete all the entries that contains this. Repeat this search and delete till there are no such entries

If the above steps does'nt work then do the following
1. Go to Win+R (run window) type services.msc

2. All the services running in your system opens up. Search for updateHulaToo.exe and utilHulaToo.exe and just to make sure look out for any name containing HulaToo in the window.

3. Now double Click on one process like updateHulaToo.exe select startUp type in the window as Disabled repeat the same for the other process i.e. utilHulaToo.exe and other services with the HulaToo in it.

4. Restart System

5. Go to MyComputer-> C Drive > ProgramFiles (x86) or ProgramFIles and delete HulaToo Folder. Later Reset ur Browsers.
6. Go to Win+R type regedit and hit ctrl + F and search for HulaToo and delete all the entries that contains this. Repeat this search and delete till there are no such entries

If u have any doubts or need assistance do as in the comment section

Sunday, April 20, 2014

Getting over the Heartbleed

Not the love life, the life Online

The simple explanation:
Heartbleed allows a hacker/attacker to have access to a random chunk of memory on the server that contains ur encryption keys or un-encrypted passwords, site data etc while the hacker remains anonymous. You would not know if it hit you.

What can the end user do???
Check if your provider/website of which you are a member of has patched the heartbleed bug. 
Here's the list of websites which have been affected by the heartbleed bug.
 Just change the Password.

 Android users update ur phones.

In detail:
Transport Layer Security (TLS) and its predecessor, Secure Sockets Layer (SSL), are cryptographic protocols which are designed to provide communication security over the Internet. 
One library that implements TLS is OpenSSL.

66% of the websites use OpenSSL, so knowingly or unknowingly u have been bugged.

A few versions earlier to the current OpenSSL, the negotiation between the client and server before sending expensive data was expensive. Most of the time the packets used to get lost or corrupt due to too many requests and need to drop its end of the TLS connection.
So the guys at the OpenSSL formulated a solution. i.e A way of telling that the server is available or its currently overwhelmed by different requests.  This way of telling if the server was available was done with the help of "KEEP ALIVE" messages known as "HEARTBEATS".

How does the HEARTBEAT work?
ex: suppose you send an request as a payload "you there man" the size is 13 so the webserver to whom you requested stores the payload as well as the size 13 into its memory. So when you send the "keep-alive" request the message is sent back to the client this is done by reading the message out from the memory of the server where it was stored following 13 places(size of ur payload).So, ur connection is kept alive.

The FLAW: Heartbleed
OpenSSL library never checked that the Heartbeat payload size corresponds with the actual length of the payload being sent.  A user is allowed to input any number up to 65535 (64 kilobytes) regardless of the true size of the payload. 
So now the attacker will send an heartbeat request for 64kb even though his payload size is 13 bytes. The server will start responding to the heartbeat request by sending the first 13 bytes and  continuing upto 64kb from the server memory to the client. The data received by the client will contain encryption keys, usernames, unencrypted passwords, user information, site information etc etc . In short whatever is put onto the server memory which is relatively everything.
All this can be performed anonymously and in a repeated manner so accessing different parts of the server memory. 

Affected users should upgrade to OpenSSL 1.0.1g. Users unable to immediately
upgrade can alternatively recompile OpenSSL with -DOPENSSL_NO_HEARTBEATS.

1.0.2 will be fixed in 1.0.2-beta2.
--Official Statement
Check if your site is affected by using this tool by LastPASS

You need to revoke your current secret TLS keys and regenerate new ones. Coz there is no telling if you have been hit and run coz all these attacks are anonymous. 

Android users of V.4.1.1 Jellybean, need to update their phones. (Better to update all android devices irrespective of the version) Download Lookout’s Heartbleed Detector or Bluebox’s Heartbleed Scanner apps, both of which will tell you if your Android device is affected by the bug.

Change ur passwords of websites that are affected(atleast by a letter) 

Even VPN's are suffering from Heartbleed. You will have to regenerate the client certificates.

Don't stop there, coz even if you have patched it from the patch received from the vendor there still might be a lot of ways to steal the information. Everyone's checking and trying to find out more vulnerabilities (so should you) and a few have found too like the Reverse HeartBleed

Reverse Heartbleed
The Heartbleed bug (CVE-2014-0160)can be used to attack clients as well as servers. Many organizations have hosts which initiate outbound SSL connections (pulling updates, fetching images, or pinging webhook URLs). These hosts are often on a separate infrastructure (with different SSL dependencies) within the organization firewall. These hosts may be vulnerable to the reverse Heartbleed attack. 
This is the tool to check for it.

Reverse Heartbleed is more tricky for the attacker however once you have patched the heartbleed the reverse heartbleed becomes more trickier.

This bug has been around for 2 years
There are claims that no hackers knew about this and it was the researchers who found about it probably the NSA and Google(since a month) knew it. 
The race is on to find the next bug. It's got a reward too.

Microsoft determined that Microsoft Account, Microsoft Azure, Office 365, Yammer and Skype, along with most Microsoft Services, are not impacted by the OpenSSL “Heartbleed” vulnerability. Windows’ implementation of SSL/TLS is also not impacted. A few Services continue to be reviewed and updated with further protections. 


Thursday, February 27, 2014

EMPLOYER E-SEWA PF India Annexure ii upload tool

This is an unofficial tool to help ease the process of uploading Annexure ii to the e-sewa portal.
The official instructions i.e the format for upload is specified here

Its a lot complicated for non tech people. So to simplify things I have created an excel sheet where you need to enter the employee details and then just click on a button which will generate the file to be uploaded in the specified format by EPF India.

You should be able to do it in 5 simple steps,  let me take you step by step

Step 1: Download the excel sheet Click Here

Step 2:
These are the columns you ll need to enter into the excel sheet

Open the excel sheet you will find the same columns 

So start filling your employees details, I shall fill the employee Anil Singh on my sheet

Step 3: 
Click on the generate file button.
Step 4:
Enter the path for the file to be stored along with the filename with the extension .txt
ex: d:\FileToBeUploaded.txt and click on Ok

Step 5:
Go to the destination folder/ drive whatever you gave in the above step and open it

Check if all the records are there and then just upload it in the portal.

Important: Every time you plan on using this sheet, use a fresh one, don't use previously entered sheets.
                Before uploading the text file you need to make sure there are no extra lines in the file.

If any doubts or clarifications mention them in the comments, I shall respond. If any errors in upload, epf provides the error codes etc,  post them too in the comments.

Later I shall cover the code of the Macro.


Blog Widget by LinkWithin