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

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

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

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

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

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

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.

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


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?

gmailaccount Personal Technology   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.

gmailaccess Personal Technology   Who is Accessing your Google Account?

Here is what I have done.

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

gmailaccess1 Personal Technology   Who is Accessing your Google Account?

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

gmailaccess2 Personal Technology   Who is Accessing your Google Account?

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

gmailaccess3 Personal Technology   Who is Accessing your Google 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.

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

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.

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

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.

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

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

vinodblog Personal Technology   Excel Tip: Comparing Excel FilesThis 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.

ConmpareFiles 01 Personal Technology   Excel Tip: Comparing Excel Files

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

ConmpareFiles 02 Personal Technology   Excel Tip: Comparing Excel Files

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.

ConmpareFiles 03 Personal Technology   Excel Tip: Comparing Excel Files

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.

ConmpareFiles 04 Personal Technology   Excel Tip: Comparing Excel Files

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.

ConmpareFiles 05 Personal Technology   Excel Tip: Comparing Excel Files

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.

ConmpareFiles 06 Personal Technology   Excel Tip: Comparing Excel Files

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.

ConmpareFiles 07 Personal Technology   Excel Tip: Comparing Excel Files

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.

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

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

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

Now under Applications Manager Click on BadgeProvider. 

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

Under BadgeProvider click on Clear Data.

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

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:

gpin SQLAuthority News   Chrome Browser   Personal Technology

After pinning 1st two tabs:

gpin1 SQLAuthority News   Chrome Browser   Personal Technology

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.”\bimg\gpin2 SQLAuthority News   Chrome Browser   Personal Technology

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.

gpin3 SQLAuthority News   Chrome Browser   Personal Technology

gpin4 SQLAuthority News   Chrome Browser   Personal Technology

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.

gpin5 SQLAuthority News   Chrome Browser   Personal Technology

What is your favorite Chrome Trick?

Reference: Pinal Dave (

SQLAuthority News – Android Efficiency Tips and Tricks – Personal Technology Tip

I use my phone for lots of things.  I use it mainly to replace my tablet – I can e-mail, take and edit photos, and do almost everything I can do on a laptop with this phone.  And I am sure that there are many of you out there just like me.  I personally have a Galaxy S3, which uses the Android operating system, and I have decided to feature it as the third installment of my Technology Tips and Tricks series.

bigandroid SQLAuthority News   Android Efficiency Tips and Tricks   Personal Technology Tip

1) Shortcut to your favorite contacts on home screen

Access your most-called contacts easily from your home screen by holding your finger on any empty spot on the home screen.  A menu will pop up that allows you to choose Shortcuts, and Contact.  You can scroll through your contact list and then just tap on the name of the person you want to be able to dial with a single click.

2) Keep track of your data usage

mobiledata SQLAuthority News   Android Efficiency Tips and Tricks   Personal Technology TipYes, we all should keep a close eye on our data usage, because it is very easy to go over our limits and then end up with a giant bill at the end of the month.  Never get surprised when you open that mobile phone envelope again.  Go to Settings, then Data Usage, and you can find a quick rundown of your usage, how much data each app uses, and you can even set alarms to let you know when you are nearing the limits.   Better yet, you can set the phone to stop using data when it reaches a certain limit.

3) Bring back Good Grammar

We often hear proclamations about the downfall of written language, and how texting abbreviations, misspellings, and lack of punctuation are the root of all evil.  Well, we can show all those doomsdayers that all is not lost by bringing punctuation back to texting.  Usually we leave it off when we text because it takes too long to get to the screen with all the punctuation options.  But now you can hold down the period (or “full stop”) button and a list of all the commonly-used punctuation marks will pop right up.

4) Apps, Apps, Apps and Apps

And finally, I cannot end an article about smart phones without including a list of my favorite apps.  Here are a list of my Top 10 Applications on my Android (not counting social media apps).

  • Advanced Task Killer – Keeps my phone snappy by closing un-necessary apps
  • WhatsApp – my favorite alternate to Text SMS
  • Flipboard – my ‘timepass’ moments
  • Skype – keeps me close to friends and family
  • GoogleMaps – I am never lost because of this one thing
  • Amazon Kindle – Books my best friends
  • DropBox – My data always safe
  • Pluralsight Player – Learning never stops for me
  • Samsung Kies Air – Connecting Phone to Computer
  • Chrome – Replacing default browser

I have not included any social media applications in the above list, but you can be sure that I am linked to Twitter, Facebook, Google+, LinkedIn, and YouTube.

Reference: Pinal Dave (


SQLAuthority News – Windows Efficiency Tricks and Tips – Personal Technology Tip

This is the second post in my series about my favorite Technology Tips, and I wanted to focus on my favorite Microsoft product.  Choosing just one topic to cover was too hard, though.  There are so many interesting things I have to share that I am forced to turn this second installment into a five-part post.  My five favorite Windows tips and tricks.

1) You can open multiple applications using the task bar.

With the new Windows 7 taskbar, you can start navigating with just one click.  For example, you can launch Word by clicking on the icon on your taskbar, and if you are using multiple different programs at the same time, you can simply click on the icon to return to Word.  However, what if you need to open another Word document, or begin a new one?  Clicking on the Word icon is just going to bring you back to your original program.  Just click on the Word icon again while holding down the shift key, and you’ll open up a new document.

2) Navigate the screen with the touch of a button – and not your mouse button.

Yes, we live in a pampered age.  We have access to amazing technology, and it just gets better every year.  But have you ever found yourself wishing that right when you were in the middle of something, you didn’t have to interrupt your work flow be reaching for your mouse to navigate through the screen?  Yes, we have all been guilty of this pampered wish.  But Windows has delivered!  Now you can move your application window using your arrow keys.

  • Lock the window to the left, right hand screen: Win+left Arrow and Win+right Arrow
  • Maximize & minimize: Win+up arrow and Win+down arrow
  • Minimize all items on screen: Win+M
  • Return to your original folder, or browse through all open windows: Alt+up arrow, Alt+Left Arrow, or Alt+right arrow
  • Close down or reopen all windows: win+home

3) Are you one of the few people who still uses Command Prompt?

You know who you are, and you aren’t ashamed to still use this option that so many people have forgotten about it.  You can easily access it by holding down the shift key while RIGHT clicking on any folder.

shiftrightclick SQLAuthority News   Windows Efficiency Tricks and Tips   Personal Technology Tip

4) Quickly select multiple files without using your mouse.

We all know how to select multiple files or folders by Ctrl-clicking or Shift-clicking multiple items.  But all of us have tried this, and then accidentally released Ctrl, only to lose all our precious work.  Now there is a way to select only the files you want through a check box system.  First, go to Windows Explorer, click Organize, and then “Folder and Search Options.”  Go to the View tab, and under advanced settings, you can find a box that says “Use check boxes to select items.”  Once this has been selected, you will be able to hover your mouse over any file and a check box will appear.  This makes selecting multiple, random files quick and easy.

folderselect1 SQLAuthority News   Windows Efficiency Tricks and Tips   Personal Technology Tip

folderselect2 SQLAuthority News   Windows Efficiency Tricks and Tips   Personal Technology Tip

5) Make more out of remote access.

If you work anywhere in the tech field, you are probably the go-to for computer help with friends and family, and you know the usefulness of remote access (ok, some of us use this extensively at work, as well, but we all have friends and family who rely on our skills!).  Often it is necessary to restart a computer, which is impossible in remote access as the computer will not show the shutdown menu.  To force the computer to do your wishes, we return to Command Prompt.  Open Command Prompt and type “shutdown /s” for shutdown, or “shutdown /r” for restart.

I hope you will find above five tricks which I use in my daily use very important.

Reference: Pinal Dave (

SQLAuthority News – Storing Data and Files in Cloud – Dropbox – Personal Technology Tip

I thought long and hard about doing a Personal Technology Tips series for this blog.  I have so many tips I’d like to share.  I am on my computer almost all day, every day, so I have a treasure trove of interesting tidbits I like to share if given the chance.  The only thing holding me back – which tip to share first?  The first tip obviously has the weight of seeming like the most important.  But this would mean choosing amongst my favorite tricks and shortcuts.  This is a hard task.

dropbox1 SQLAuthority News   Storing Data and Files in Cloud   Dropbox   Personal Technology Tip


My Dropbox

I have finally decided, though, and have determined that the first Personal Technology Tip may not be the most secret or even trickier to master – in fact, it is probably the easiest.  My today’s Personal Technology Tip is Dropbox.

I hope that all of you are nodding along in recognition right now.  If you do not use Dropbox, or have not even heard of it before, get on the internet and find their site.  You won’t be disappointed.  A quick recap for those in the dark: Dropbox is an online storage site with a lot of additional syncing and cloud-computing capabilities.  Now that we’ve covered the basics, let’s explore some of my favorite options in Dropbox.

Collaborate with All

The first thing I love about Dropbox is the ability it gives you to collaborate with others.  You can share files easily with other Dropbox users, and they can alter them, share them with you, all while keeping track of different versions in on easy place.  I’d like to see anyone try to accomplish that key idea – “easily” – using e-mail versions and multiple computers.  It’s even difficult to accomplish using a shared network.

Afraid that this kind of ease looks too good to be true?  Afraid that maybe there isn’t enough storage space, or the user interface is confusing?  Think again.  There is plenty of space – you can get 2 GB with just a free account, and upgrades are inexpensive and go up to 100 GB of storage.  And the user interface is so easy that anyone can learn to use it.

What I use Dropbox for

I love Dropbox because I give a lot of presentations and often they are far from home.  I can keep my presentations on Dropbox and have easy access to them anywhere, without needing to have my whole computer with me.  This is just one small way that you can use Dropbox. You can sync your entire hard drive, or hard drives if you have multiple computers (home, work, office, shared), and you can set Dropbox to automatically sync files on a certain timeline, or whenever Dropbox notices that they’ve been changed.

Why I love Dropbox

Dropbox has plenty of storage, but 2 GB still has a hard time competing with the average desktop’s storage space.  So what if you want to sync most of your files, but only the ones you use the most and share between work and home, and not all your files (especially large files like pictures and videos)?  You can use selective sync to choose which files to sync.

Above all, my favorite feature is LanSync.  Dropbox will search your Local Area Network (LAN) for new files and sync them to Dropbox, as well as downloading the new version to all the shared files across the network.  That means that if move around on different computers at work or at home, you will have the same version of the file every time.  Or, other users on the LAN will have access to the new version, which makes collaboration extremely easy.

dropboxcartoon SQLAuthority News   Storing Data and Files in Cloud   Dropbox   Personal Technology Tip


Dropbox has so many other features that I feel like I could create a Personal Technology Tips series devoted entirely to Dropbox.  I’m going to create a bullet list here to make things shorter, but I strongly encourage you to look further into these into options if it sounds like something you would use.

  • Theft Recover
  • Home Security
  • File Hosting and Sharing
  • Portable Dropbox
  • Sync your iCal calendar
  • Password Storage

What is your favorite tool and why?

I could go on and on, but I will end here.  In summary – I strongly encourage everyone to investigate Dropbox to see if it’s something they would find useful.  If you use Dropbox and know of a great feature I failed to mention, please share it with me, I’d love to hear how everyone uses this program.

Reference: Pinal Dave (