Archive for the ‘online database’ category

Binghamton University Shoulda Had TrackVia

March 19th, 2009

Binghamton UnivIt appears the information security officer and other administrators responsible for securing data at Binghamton University went on Spring Break a little early this year.  A reporter exploring one of the most trafficked lecture halls open to the public recently discovered a door taped open and unlocked to a two-story storage room filled with unlocked filing cabinets.  Given the evidence, it became clear that filing cabinets, which held student payment information (Social Security numbers, credit card numbers, tax documents, salary information) that dated back at least ten years, had been compromised. It is estimated that the breach may have impacted over 100,000 people.

Sad to say this was not the first time a breach occurred on campus; however, I hope it will be the last time.  While some businesses may feel more secure having their data on premise, this story illustrates a potential vulnerability of data kept under the mattress.

At TrackVia, we know how important securing one’s data is and would encourage Binghamton to investigate securing student data in a secure online database.  A few of the reasons Binghamton shoulda had TrackVia:

  • Access to data could have been restricted to designated IP addresses.
  • Hard copies could have been scanned and uploaded into a document field type.  Documents could then have been shredded vs. stored in unlocked filing cabinets
  • User permissions could have been set on fields, records and features restricting access to information.
  • Change history notes would have indicated who changed what/when.

Data security is one class that should not be skipped.  If you decide to keep documents on premise, lock the file cabinet and the door.

Additional Shoulda Had TrackVia Posts:

Top 10 Tips for Effective Email Campaigns

March 13th, 2009

Whether you are sending marketing information or a newsletter, your email is only worthwhile if the end user gets to see it.  Here are our top 10 suggestions for effective email campaigns:

  1. Don’t send spam. Really.  Put processes and procedures in place to make sure you and your servers are not sending spam.  If a client wants to use your system to send spam, make sure your end user license agreement says that you can cancel them – and then do it!  If you send spam the email administrators of your recipients will eventually figure it out and blacklist you from sending any email to them at all!
  2. Have a database to track and send your emails. If you manage a list of any significant size, it takes too much time and effort to implement the other things on this page with just a spreadsheet.
  3. Have a one-click unsubscribe link. In each email, there should be a link that the recipient can click on that automatically removes them from your mailing list.  To save you time, it should just update your email database so that the person is not selected the next time you do a mailing. Don’t send these people another email!
  4. Monitor blacklisting. If an ISP or corporate email server thinks you are sending spam, they often “blacklist” your servers, which means they won’t ever accept email from them again.  A lot of times they will put you on their blacklist as a precaution, but if you explain why you shouldn’t be, they will usually remove you.  Watch the email sending logs and keep an eye for who might have blacklisted you, and then contact them and ask to be removed.
  5. Monitor your email server’s reputation. Several companies online keep track of each server that is sending significant quantities of email and assign them a reputation score based on a number of criteria.  The better your score, the more likely it is that ISP’s will accept your email.  Things that hurt your score:  sending email to bad addresses, people complaining your email is spam, high volume.
  6. Remove email bounces. If an email bounces, don’t keep sending emails to that address.  It is not going to start working on the 40th email!  Use a technology such as Variable Envelope Return Path (VERP) to automatically disable the user in your database.  TrackVia accomplishes this through Email Flags.  One flag is for “opt-in”, meaning the user hasn’t unsubscribed like in #3 above, and another is “valid address” meaning that it didn’t bounce the last time you sent it to them.  Using flags lets you report on what percent of your list bounced or unsubscribed after each email blast.
  7. Email authentication. Since greater than 90% of all email is spam and goes undelivered, ISP’s look for these email authentication techniques to show that your message is coming from a server and in a format that is likely not spam.  Sender Policy Framework (SPF) tells the ISP which servers are allowed to send emails on behalf of this domain.  DomainKeys/DKIM proves that the message wasn’t modified in transit and that the content of the email is what was intended to be sent.
  8. Volume. Spammers stereotypically send a huge amount of email.  If you are sending hundreds of thousands of emails, you’d better have a good reason or they’ll think you are a spammer too.
  9. Respond to email filters. Some companies have systems that don’t let the first email from anyone through to its intended recipient.  Instead it first sends a reply asking you to click a link to ensure that a person really sent the email.  Once you click the link, it will deliver this message, as well as future ones, without hassle.  If you want your email to get through, you have to click the link.
  10. Spam filters. If it looks like spam, it probably is.  Certain words, phrases, or the structure of your email can cause the ISP to put your email in the recipient’s spam folder.  Each suspicious item has a score associated with it, and if your score exceeds a threshold (usually 5 points), it is considered spam.  Avoid things like:
    - links to an IP address instead of a domain name
    - broken links/images
    - vertical words
    - lots of blank lines
    - gappy text like t h i s or t.h.i.s
    - the words “As Seen” in the subject
    - and all the catch phrases you see in the spam you get!

Sound like a lot of work?  It can be, or you can use a better database that does all of the server side work for you when it comes time to begin an email campaign.

Additional Posts with Email Campaign Topics:

Put your professional network to work in a database

The Web Email-Enabled Database

No Longer Dread the Holiday Card Process

Tracking with TrackVia – NAI 1st Valley Commercial Real Estate

March 12th, 2009

In observation of Make a Referral Week, Ed Dunigan speaks with Rozilynn Mitchell of NAI 1st Valley Commercial Real Estate about the power of referrals and how NAI is using the TrackVia’s SaaS database for its commercial real estate business.

The referral tips Roz discusses in this podcast easily translate across industries. Some highlights from the podcast include:

Strong Relationships and trust lead to referrals.

To increase referrals, brokers should:

  • Promptly return calls (return calls within minutes vs. days)
  • Be available even if there is no monetary reward
  • Be a good Samaritan

Finding the right tools that give your team quick and easy access to information will increase referrals.

  • Make sure tools selected are accessible no matter where you are.
  • Make sure the software vendors you select have good support.
  • A customizable database will make it easier for you to manage your relationships and share information with others.

Click to read a case study featuring NAI 1st Valley’s use of TrackVia.

Additional Tracking with TrackVia Podcasts:

Five Ways a Database Protects Data

March 6th, 2009

Preventing Data TheftDon’t leave your data unattended. According to a recent study by Symantec Corp. and the Ponemon Institute 79% of all workers who left an employer within the last year took data without an employer’s permission. Businesses must protect their data from employee theft in good and bad times.

As I read a recent post on Computer World that identified steps to protect your business from angry ex-employees, I could not help but think of how an online database helps businesses maintain control over data and data theft.

Five Ways to Protect Data in a Database

1. Control data access through user permissions. Set appropriate permissions to restrict access to records (viewing, editing and deleting), fields (viewing and editing), and features (tools and reports). For example, you can allow sales reps to view leads assigned to them while restricting their ability to export leads to Excel.

2. Restrict access to data with IP Filtering. Grant access to a group or range of IP addresses. No longer worry about employees accessing and downloading data from home.

3. Track database activity with automatic change history notes. These notes provide an audit trail so administrators can keep track of who did what when.

4. Enable Email Collection for laid off employee’s email. Eliminates the need to forward former employee’s emails to another employee and wonder if they are being monitored. Simply have them collected in a database making it easy to monitor any business correspondence received after the departure.

5. Delete user from database prior to notifying of lay off. All permissions previously granted will cease to exist so former employees can no longer access business critical data.

Leverage the power of your database to control access to your data and prevent former employees from walking off with your data.

TrackVia News: New Alerts Feature and Partnership with Parallels

February 4th, 2009

During the Parallels Conference in Las Vegas, we announced the public launch of our Alerts feature and a new partnership with Parallels.

The Alerts feature allows database users to receive real-time email notification whenever data is added, removed or changed in a database.  Data Alerts support a wide range of workflow and business process applications.  For example, an alert could be used in a CRM database to notify a sales rep when they have been assigned a new lead.

Through our partnership with the Parallels SaaS ISV Initiatives Program, TrackVia gains access to Parallel’s 10,000+ Service Provider Channel.  Parallels VP of SaaS and Service Provider states, “The TrackVia SaaS database provides our hosting partners with a high value-added product offering that complements and extends their existing hosting solutions.”

For more information on our new alerts feature or our partnership with Parallel’s drop us a line at support@trackvia.com or call us at 1.800.673.3302.

Database Architecture Meets Prefab Architecture

February 4th, 2009

The February 2009 issue of Dwell on Prefab Architecture intrigued me and led the data architect in me to identify some similarities between current prefab and database architecture.  In the past, all prefab options were kits.  For example, in the early 1900s a Sears and Roebuck home came with a 75 page instruction manual and 30,000 pieces, not including screws and nails.  There was little if any freedom to deviate from the manual.  The same could be said of packaged database software; you got what you purchased and nothing else.
As the issue pointed out, the times have changed in the prefab housing world; you can now purchase prefab offerings that you can customize with your own personal touch.  Your prefab pad no longer has to scream, “I am just like the house next door!”  The same is now true for the database world.  You can now purchase an online database solution like TrackVia, without worrying about getting trapped into a specific mold that was designed or dictated by someone else. Today, online databases are extremely flexible and give you a host of options to customize the database to suit your business’ individual needs.
Like the Dwell article, I have outlined the benefits of today’s prefab database architecture:

  • Affordable – Online databases are more affordable than pre-packaged and custom designed databases, and come with unlimited free phone and online support (at least with TrackVia).
  • Mobile – Online database solutions can be accessed wherever there is an Internet connection, allowing you to take your database with you.
  • Reconfigurable – Edit your database to meet your needs: easily add/concert fields, control user permissions and change format views to meet your specific criteria.
  • Completely Custom – Easily customize database to meet your specific data tracking needs without the need of a consultant with programming knowledge.  Also, receive new features in real-time.

There is always the option to hire an architect to build a custom house or a programmer to build a custom database, however it does not come cheap.  If you were an architect designing the future of “prefab” databases, what features would you look for to differentiate your blueprints?

Google Shows Its Human Side

February 3rd, 2009

Were you one of the Googlers worried you were infecting your computer with viruses on Saturday morning?

For about an hour on Saturday, each and every Google search resulted in a warning that “this site may harm your computer.” What happened, according to a Google statement, is due to – human error. Google works with a nonprofit that tracks the sites that install malicious software on visiting computers. On Saturday, someone accidentally checked the input value that applied to ALL URLs – ouch!

The term “human error” in situations like these is kind of amusing. It’s framed almost as a good thing (”don’t worry – there’s nothing wrong with our software. Bob just pushed the wrong button!), but the reality is that human error can be just as harmful as systemic errors – especially because you can usually weed out the systemic errors by fixing the code (or, for you Office Space fans out there, “fixing the glitch”).

There’s often no such quick fix for human error. And the more times you have people manually enter and manipulate data, the more risk you’re running of human error.

Obviously we are all humans, and this event has proven that even Google can’t escape the occasional human error.

TrackVia’s online database solution has a few features to help us with our humanly ways. Features such as automatic change tracking notes, user permissions and relational databases help to eliminate human error or at a minimum easily identify the culprit making changes to the database.

How do you prevent human errors?

Put your professional network to work in a database

January 29th, 2009

Networking… an important aspect of every successful professional’s career but especially important now. The act of networking has changed with the introduction of the many online networks such as LinkedIn, Facebook and even Seth Godin’s invitation-only Triiibes network are great tools for staying in touch with new and old colleagues. But not everyone is using these tools and let’s face it you don’t want everyone having access to your profile. These tools have really enhanced the ways in which we stay in touch with our networks but relying on these tools to manage your contacts is just not enough. As I write this, there is a reporter on TV talking about a recent increase in identity theft on Facebook. If your profiles are compromised, what happens to those contacts? Perhaps it is a good reminder to keep your contacts in a database that you control.

Once you return from your networking event, make it a point to put those new contacts into action before you forget the conversations or lose the cards all together. Here are a few tips for getting those business contacts organized.

1.    Immediately scan or enter your business cards into Excel or other spreadsheet/database (TrackVia users can easily import this data into an online database via an Excel import)
2.    Enter information on the date you met the contact and interesting points from your discussion
3.    Set a date to remind yourself to stay in touch, add value or share information
4.    Include location information – when you travel, sort your database and schedule stops during your trip
5.    Send a newsletter or email to your database letting people know what you are up to
6.    List social network profiles when applicable
7.    Back it up! (If it is in a TrackVia database, your contacts will be automatically backed up.

And if you need to refresh your networking skills, here are a few links to networking tips:
1.    Tips for networking in Silicon Valley on GigaOm
2.    Entrepreneur shares some insights from book, Smart Networking (see value section)

Once you have your contacts organized, go test your networking attraction factor.

JournalSpace Shoulda Had TrackVia

January 26th, 2009

TechCrunch recently reported that a disgruntled and clearly malicious ex-employee of blogging platform provider, JournalSpace, decided to overwrite the company’s main database resulting in a substantial loss of data for thousands of bloggers. Apparently this former IT person decided that RAID alone would be enough to handle the backup for its main database and then took advantage of the vulnerabilities that he created after he left.

Of course the people behind JournalSpace, which has since been taken over by new owners, learned a hard lesson and maybe that is to not rely on only one form of data protection.

I’m sure the thousands of bloggers who used JournalSpace to host their blogs assumed there would be adequate space on the platform’s servers to back up their entries.  For those who did not back-up their own data, it presents a painful reminder that you can’t rely on these platforms to protect your content. Lesson learned for all you bloggers out there, never assume a third party provider has adequate back-up or back-up procedures at all as this was not the case for JournalSpace. The new owners have since made the policy quite clear.

Had the bloggers using JournalSpace organized and tracked their posts in TrackVia, there would not have been a frantic rush to Google Cache in hopes of retrieving their content and comments.  Check your third party providers to make sure your data is being backed up.   If you’re curious, this could not have happened at TrackVia.  In addition to RAID mirroring in every server, we also store all data in duplicate on physically separate servers in real time, and from there we have a continuously running backup process.  That’s three different back-up strategies running simultaneously. 

Too bad JournalSpace did not look into an online databaselike TrackVia to back-up its data.

Reminder to all bloggers: back it up!

I’ve backed up this post in my TrackVia database.

How to Get Your Blog Program in Shape

January 23rd, 2009

January marks the month where everyone is keen on fitness and getting in shape so we thought it was the perfect time to share some tips for getting your blog program in shape.

We aren’t going to cover SEO tips, links or categories… No, for the purpose of this post and for what we are good at, let’s look specifically at how you are gathering ideas, organizing those ideas and tracking your blog information.

Hopefully some of these tips will help you “blog masters” out there not only maintain an active blog, but also get your blog program organized as well.

> SCHEDULE: create an editorial calendar of blog posts a few weeks out

> DETERMINE a TEAM: consider a team blog where different perspectives can be shared

> SET DEADLINES: get authors and editors accustomed to a schedule

> BUILD A BASE: always have a few extra posts written and on hand

> TIMING: time posts with relevant events and planned editorial calendar opportunities with industry-specific publications

> DIVERSIFY: mix it up from time to time and do a video post or an audio podcast when time is tight but you have a good source right in front of you

> ORGANIZE and TRACK: organize all notes, attachments and multimedia files in an easily accessible database for quick publishing and easy access (TrackVia can help)

> MEASURE: track and record the number of unique visitors a blog received, what time of day it was posted and contributing factors which made it a well-received post or one that received little attention in your database – surely you will need this data at a moments notice later in the quarter

We hope that these tips were helpful. Feel free to share your tips for keeping your blog content organized.