Personal Technology – Inserting Image in PDF File with Adobe Acrobat X Pro

Here is the one of the issues, I keep on facing every single time. Just like every DBA and Developers I keep on working with PDF. I use Adobe Acrobat X Pro to edit my PDFs. I am usually able to pretty much all the work related to text just fine, but when I have issue to insert image in the PDF file, every single time I have to search on Google to learn how I did it. It seems acrobat team did not do a good job in placing the instruction on the web as well as it is not intuitive to do that in the software.

I decided to list down the few steps about how to do the same over here so next time when I face this issue, instead of going online, I will just search in my blog.

First open the PDF which you want to insert the image.

Next, go to View >> Tools and click on Content

It will open up the sidebar. In this side bar click on Edit Object.

Once you select Edit Object now go to the location where you want to insert new image and Right Click over there. It will bring up new menu where the second option is Place Image

Click on the Place Image and now you can navigate to your image and click OK.

That’s it! You are done. Now you have successfully inserted the image in your PDF.

I have been doing this for quite a while and I believe there should be an easy way to do the same task. If you have any idea about how to do this easily, you can leave a comment here and I will publish on the blog with due credit.

Reference: Pinal Dave (

Personal Technology – How to do Exercise and Stay Relaxed while in Office – Tips for Developers

While the modern day worker is usually no longer subjected to 10, 12, or 20 hour shifts, and can look forward to much more pleasant working conditions, modern office life has its own fair share of health and safety concerns.  For example, sitting at a desk and staring at a computer screen all day, as most developers do, is not as back-breaking as hauling heavy loads or working in a factory, but the human body was not built to sit and stare at awkward angles all day.  Our wrists are poorly designed for the angles forced on them by keyboards, and carpal tunnel develops.  Computer screens cause eyestrain and dryness.  Computer chairs cause back and neck pain.  Is it any surprise that many developers go home and feel as if they were working in a factory?

Because modern employers recognize that happy, healthy employees are productive employees, there are a wide range of exercises you can do to keep you loose, limber, and energized.  Many of them you can easily accomplish without leaving your chair or requiring a lot to space to jump and lunge, and best of all you won’t be disturbing any nearby co-workers.


Stretching is an easy way to take a quick break from work and pause to recognize any sore or tense spots.  When you get really absorbed in a task, it can be easy to ignore the fact your neck hurts, you’re staring at your screen at an awkward angle, and that you’re slouching.  Stretching helps you readjust and better yet, gives you the kind of 30 second pause you might need to break through writer’s block or a logical problem.

Stretch 1: intertwine your fingers and reach your arms towards the ceiling, palms up.  Roll your neck.  When you release, check your posture.  I bet you’re sitting up straight now!

Stretch 2: Lift your legs out straight in front of you, flexing your feet and ankles.

Stretch 3: Lean left and right, hinging at the waist (as if you were trying to bring your head to your hip).  Stretch your left hand above you as you lean right, and your right hand above you as you lean left  – as long as you don’t feel like you’ll fall out of your chair.

Stretch 4: Keeping your lower body as still as possible, twist your upper body as far to the left as possible, then as far to the right as possible.  Do not over-twist or force your upper body further than is comfortable using the table or arm of the chair.  These stretches should energize, not hurt!

Avoiding Carpal Tunnel

As mentioned before, keyboards and computer mice hold our wrists at an awkward, upward angle, pinching important nerves and tendons between the bones of the hand.  Symptoms start with numbness and tingling, and quickly move on to pain and the loss of mobility.  Ergonomic keyboards and mice can only do so much – we have to stop and stretch periodically as well.

Stretch 1: Stop typing and give yourself a little hand massage.  Whatever feels good – the moving your wrists out of the typing position is what is key.

Stretch 2: Roll your wrists clockwise and counterclockwise for a few revolutions.

Stretch 3: Go for a walk. This isn’t going to directly impact your wrists, but the break from typing is most important.

Other solutions: wrist braces to hold your wrist in a neutral position are helpful when breaks are impossible or you already have some nerve damage.  A better chair or back brace to help posture will also help your wrists, believe it or not.  If at all possible, trade tasks with another employee every week or two, to help the both of you avoid repetitive motion injuries.


Staring at a computer screen causes eye strain.  This is a simple fact.  No matter what kind of anti-glare coating, eye shade, or LED screen you have, eye strain will happen.  The most common culprit – not blinking!  Blinking is an involuntary reaction, on par with breathing or digestion.  But something happens to human physiology when we are confronted with a shining monitor, and studies show our blinking rates can drop by half when staring at a screen!  It is no wonder our eyes get tired and dry.

Exercise 1: This one is easy.  Stick a bright post-it note on your screen, somewhere where you will be forced to see it all the time, and write “BLINK” on it in large, bold letters.  Believe it or not, this will help.

Exercise 2: Clean your screen.  A smudge-free screen will help your eyes, and the movement will help your sore muscles.

Exercise 3: Keep your monitor at eye level (even if this means propping it up on books or lowering your chair), at most a few inches below eye level.  This will help your posture, too.

Exercise 4: Take a walk.  That’s right!  It’s good for your wrists and good for your eyes.  Even if you just go get a sip of water once an hour, your eyes (and wrists, and back, and legs…) will thank you.

Get Up and Move!

Perhaps you have a hard time sitting still, or you would just like to get a little more exercise.  Either way, there are certainly exercises you can do, even in a cubicle, to get you up and moving during the day.

Exercise 1: Get out of your chair and stretch.  Interlacing your fingers and stretching your hands above your head (palms up), stretch up on your tip-toes, and then bend down to touch your toes.  It gets the blood flowing.

Exercise 2: If you have the room, do some lunges.  Place your hands on your hips and lunge forward with your right leg, bending your left leg 90°.  Do not extend your knee past your ankle, as this can cause damage to your joints.  In one swift motion, return to standing and repeat on the left side.

Exercise 3: This one requires less room.  Stand up out of your chair and be sure to move it out of your way.  Then slowly bend your knees and lower down, as if you were sitting in an invisible chair (remember, move your real chair, no cheating!).  Again, be sure to keep your knee in line with your ankle to avoid injury.  To make it harder, raise your arms over your head and try these squats.

Exercise 4:  If you are blessed with a lot of office space, get down on the floor for some push ups and crunches.  To avoid getting too sweaty work in sets of 10 or 20 a couple times a day.

Exercise 5: If you don’t want to wrinkle your work clothes, try working your abs with a “plank.”  Support the weight of your body in a push-up position (knees up or down, with arms fully extended or on your elbows).  Aim for holding a plank for 30 seconds (work up to it in 10 second intervals if needed), and work up to a minute or two.  A yoga mat can store neatly in your office, in a drawer or closet, if you are really dedicated to office fitness!

The Easiest Exercise

If you don’t have the space for some of these moves, of if your office is very open and you feel embarrassed about sitting in an invisible chair in front of all your co-workers, there is one sure-fire way to help eye-strain, wrist fatigue, boredom, and writer’s block.  Take a walk!  Walk around the perimeter of the cubicles, walk around the building outside.  Walk to get your lunch a block further away than usual.  Walk down the stairs to use a further away printer.  You don’t need any more equipment than just your two legs and comfortable shoes.  Even if you can only leave your desk for quick 30-second bursts, it will add up over the course of the day.

Reference: Pinal Dave (

Personal Technology – Who is Accessing your Google Account?

Do you know who is accessing your Google Account?

Well, I did not know till yesterday. However, when I learn what apps are accessing my Google Accounts and particularly Gmail, I was really really scared. I receive lots of emails and just like all of us, some are private and some contains essential information about server setups. I have been using Google for many years and I have used their authentication at quite a many places. When I login to any site with the help of Google Account, I really do not see what is written there as in most cases I just trust the sites. This is indeed not good as there are some sites which can pretty much access all of your data from your google account and we are not even aware of the same.

When I logged in, I found that over 200 different applications have access to my various google services. Some are very much valid but some services should have been very well protected. For example Flipboard application accessing my YouTube account is valid and I have personally approved it but there were some services reading my emails where I am no more using those services was not a good idea. I spend over 6 hours to clean my various access to my Google Accounts and now I am feeling pretty safe.

Here is what I have done.

Sign in on the Google Accounts homepage. Now click Security on the left-hand side of the page.

Scroll down to the Connected applications and sites section and click the Manage access button.

Click Revoke Access next to the service you want to disconnect from your account.

I strongly suggest that you review all the permissions and make sure there is no unauthorized access to your account.

Well – that is Reference: Pinal Dave (

Personal Technology – Chrome Missing Close Button – Chrome in Desktop Mode in Windows 8

I have been using Windows 7 very comfortably for a long time. I love the product and I love the presence of my start menu. I use my laptop/computer for a causal use as well as for professional work. One of my primary job as an evangelist is to present technology sessions at various places. I use my mobile ultrabook for the all the presentations. This ultrabook is pretty new (11 months old) and it has Win 8 Operating System. Though I use my laptop as a tablet most of the time, I still use Desktop mode ALL the time for everything I do. I personally have not found a reason to switch to Windows 8 modern UI modes as I just love desktop mode.

Here is something which I have faced recently and it has become very annoying to me when I am using Chrome as a my browser. Usually I see my browser with various window buttons like Minimize, Maximize and Close on the windows as displayed in following window.

However, one fine day, I did not see any of those buttons. I had no clue how I will turn of my browser or reposition them. I was even not able to open another instance of the browser as well I was not able to close that entirely with the keyboard command CTRL+W. I was pretty much stuck with no close button and extremely confused.

I searched the internet and few people were thinking it is a virus but I could not believe the same as I have seen plenty of the virus and it was no virus – it was something, which I had no clue about but for sure it was not a virus. If it was a virus, I am pretty confident that virus scanner would have caught it. Finally after playing around with Chrome for a while, I suddenly realized that I had accidentally switched the mode of the Chrome to Windows 8 Modern UI and it was no more in the desktop mode. I followed steps displayed in the following image and I relaunched Chrome on the Desktop. After that I was able to comfortably use my Chrome as I was used to earlier.

I am very sure, just like me many other people outside who have installed Windows 8 or have a relatively new computer with Windows 8. Let me know if you have ever faced this issue and if this blog post is helpful.

Reference: Pinal Dave (

Personal Technology – Excel Tip: Comparing Excel Files

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versionsfrom SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect.

Let us read the blog post in Vinod’s own voice.

I have been writing about Excel Tips over my blog and thought it would be great to share one interesting tips here as a guest blog here. Assume a situation where you want to compare multiple excel files. Here is a typical scenario I have encountered as a common activity. Assume you are sending an Excel file with tons of data, formulae and multiple sheets. Now you are requesting your colleague to validate the file and if required change content for correctness. After receiving the file from your colleague, now you want to know what changes were made by this person to your document. Now here is a cool new addition to Excel 2013 that can help you achieve this task.

To get to this option, click the INQUIRE Tab. Incase you don’t have the INQUIRE Tab, check Options using INQUIRE blog. In that post, we discuss all the other options of INQUIRE tab.

Once you are on the INQUIRE Tab, select “Compare Files” button as shown in the figure above. This brings a dialog as below.

If you are on Windows 8 or Windows 7 OS, search for an application called “Spreadsheet Compare 2013”. Ultimately both the options lead us to the same application. If you are using the stand alone app, once the App initializes, click the “Compare files” options from the toolbar. Make sure to give two different Excel files as shown in the figure above.

After selecting the Excel Sheets, you can see the Compare tool has a number of other options to play from. We will talk about some of them later in this post.

Just below our toolbar is a colorful side-by-side comparison of both our excel sheets. We can also see the various Tab’s from each file. There is a meaning for each of our color coding which will be discussed next.

As you saw above, the color coding has a meaning. For example the bottom pane lists each of the color coding and most importantly each of the changes as compared side-by-side. The detailed information shown below can be exported using the “Export Results” options from the toolbar as a separate Excel Workbook or can be copied to clipboard to be used later.

The final piece of the puzzle is to show a graphical view of these differences results based on each category. We cannot drill down per se, but this is a great way to know that the maximum changes seem to be based on “Cell Formats” and then few “Calculated Values” have changed.

The INQUIRE option and Spreadsheet Compare 2013 tool is part of Excel 2013. So as you explore using the new version of Excel, there are many such hidden features that are worth exploring. Do let us know if you enjoyed learning a new feature today and I hope you will play around with this feature in your day-today challenges when working with Excel files.

Reference: Pinal Dave (

SQLAuthority News – Reset Messaging (SMS/Text) Icon Count in Android Jelly Bean

Though, this blog post has nothing to do with SQL, this particular issue has been annoying me for a long time. I use Galaxy SIII updated with Android Jelly Bean. I am a big fan of this phone and I have written an efficiency tip about Android as well here Android Efficiency Tips and Tricks – Personal Technology Tip. Recently it started to give me one very annoying error.

I had recently received a single SMS/Text on my phone. After I read the message the icon did not reset.

Here are few of the things I tried but the icon did not reset. This keeps on confusing me as every time I check my phone, I see one unread Text but when I click on it there was no new message. This pretty much killed my efficiency as I spent more time  checking my message box when there was no new message. It became extremely annoying at times. Here are few of the things which I have done but I got no success.

  • Restart the phone (multiple times)
  • Tried to empty out all the messages from my message box (I did take backup before)
  • Asked my friends to send new messages (more messages than unread count)

All of the above got me no results. There was one option which I knew will for sure fix the issue but I did not want to try that was Reset the Phone to Factor Settings.

After a few trial and error I finally figured out the way to fix the problem.

Go to Settings >> Applications Manager

Now under Applications Manager Click on BadgeProvider. 

Under BadgeProvider click on Clear Data.

As soon as you click on Clear Data and go back to your main screen, you will notice that your Messenging Icon will now reset and will display your current unread message. If your current unread message is zero, it will not show any unread message. In my case I did not restart my phone but couple of users reported that they had to RESTART the phone after above process.

Let me know if you are a victim of this issue and if this instruction are helpful.

Reference: Pinal Dave (

SQLAuthority News – Chrome Browser – Personal Technology

Almost every computer you can buy these days will come with Microsoft Windows installed on it automatically.  Also installed automatically – Internet Explorer, Microsoft’s web browser.  Many of us use this browser without a second thought, but in this latest Personal Technology Tip and Trick I thought I’d expand your horizons and talk about my favorite browser – Google Chrome.

1. Pin Tab

Most browsers now have the tab option, which allows you to have multiple browser windows open with easy access.  However, if you’re like me and have so many tabs open that you no longer can keep track of them, you need this streamlined service to be even more linear.  Welcome to pin tabbing.  When you pin a tab, it will form a much smaller, more minimized tab on the bar – usually just the web page icon.  It takes up much less space and allows you to focus on one set of multi-tasking jobs at a time.

Before pinning:

After pinning 1st two tabs:

2. Omnibox

The address bar in Google Chrome is so much more than a way to navigate to sites whose addresses you know.  In Chrome it’s called the “Omnibox” and it really can do everything.  Type in your search terms to do a quick Google search, and it can even do your math for you.  Type in equations, unit conversions, or distances, and have them quickly translated to exactly what you’re looking for.

3. Incognito – Secret Mode

In Incognito browsing, Chrome allows you to open a new window and perform all your regular internet surfing, without recording your browsing history (it even deletes the cookies after you close the window).  If this sounds like something only shady people up to no good would use – reconsider.  You could be logged into two accounts under two different user names using Incognito, without irreparably confusing your e-mail server.

4. Reopen Recently Closed tab

We’ve all done it – we have fifteen tabs open at the same time, and we are trying to sort through them and oops – there goes the tab that we really wanted.  But in Google Chrome you can easily retrieve the tab you accidentally closed.  There are two opens – Ctrl+Shift+T or right click on the tab bar and select “Reopen closed tab.”

5. Task Manager

If you are a multi-tasker, you know that sometimes you can outwork your computer and it slows down to the point where you can’t work anymore.  Google Chrome helps you fix this by showing all the CPU usage by every tab you have open.  It allows you to pinpoint windows that are using too much memory and close them down for later use, and then you’re back up and running at full speed.  Access this Task Manager by right clicking on the tab bar and selecting “Task Manager.” You can also enable Task Manager by pressing Shift+Esc.

6. Drag and drop downloads from Chrome

Being able to download documents or applications from the internet is, in itself, amazing.  But let’s admit it, operating through the download menu can be a little bit frustrating.  Google Chrome now allows you to drag and drop your download directly from Chrome into a new folder, the desktop, or wherever it belongs.

What is your favorite Chrome Trick?

Reference: Pinal Dave (