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.

SQLAuthority News - Storing Data and Files in Cloud - Dropbox - Personal Technology Tip dropbox1
Source: Dropbox.com

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.

SQLAuthority News - Storing Data and Files in Cloud - Dropbox - Personal Technology Tip dropboxcartoon
Ref: rzfeeser.com

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 (https://blog.sqlauthority.com)


Personal Technology
Previous Post
SQL SERVER – Finding Different ColumnName From Almost Identitical Tables
Next Post
SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post

Related Posts

6 Comments. Leave new

  • Dropbox is the greatest thing ever. As a uni student dropbox has made group assignments that much easier. With the combination of dropbox, skype and google docs there is no longer the need to physically meet up to do work. Also with the Dropbox great space race we’re getting more storage.

  • Dropbox? Google Drive is integrated with all Google services so there’s no need of Dropbox.

  • Mohammad Murtuza Ali
    October 19, 2012 9:49 pm

    Dear Pinal,

    i am facing with issue while writing a view in SQL database in which i need your help and expertise.
    i am working with sales tracking software application.
    i made a Pivot report in crystal reports (customized software) linked with SQL database in which i created columns as Sales target and sales achieved and also i created a new table which will be the difference between sales achievement and sales target, now i want to create a new table as achievement percentage %. which will give me the % between achievement and target.
    i tried this “select float(salesachievement) / (salestarget) * 100.”
    so i really dont know the query how to implement it in SQL.
    please can you give me a query so that i can work on that.

    your usual cooperation is highly appreciated.
    Thanks and Regards
    Mohammad Murtuza Ali.

  • As far as backup, we use our own servers, and a third parties, but many of our employees use Google Drive.

  • Great post…………thanks for sharing about drop box……

  • Skydrive is now much better than DropBox including the Sync and also Skydrive is Much Better integrated with Office Apps then Google Drive. I have moved to Skydrive now from DropBox.


Leave a Reply