Rob Paller A blog about databases, business intelligence, and an outlet for my inner geek

All Your URL are Belong to Us

Posted on December 14, 2009

Today's Lesson

Today, Google announced the launch of goo.gl, its own URL shortening service. It is currently in a "limited" release for users of its Google products such as Feedburner and the Google Toolbar. This was done in concert with Feedburner's new enhancement called Socialize, which will currently send your feed to the Twitter account you specify. In order for your feed to be socialized in near real-timte they suggest you leverage Feedburners "ping" feature whenever you publish a post. Overall, the Socialize feature of Feedburner is a nice enhancement and I hope that we will see additional services like Facebook, MySpace, and LinkedIn included in the future.

However, the most important feature that was launched today was the URL shortening service.  Why is this so important? Because several URL shortening services have come and gone over the past couple years. With the demise of these services comes the inability to redirect the user from the shortened URL to the target URL, also known as linkrot.  Brent Ozar wrote about his suspicions of using free web services to shorten URLs for this very reason. With Google the chance that your shortened URL will rot is virtually nil given Google's appetite for data.

While Google has said it will protect users of its URL shortening from malware and phishing it would be nice to see a link preview feature enabled. The current version of TweetDeck (v0.32.1) simply opens your web browser with the resolved goo.gl link while for other services such as bit.ly a preview of the full URL is given in a pop-up window . This is either due to TweetDeck not understanding how to handle goo.gl's URL preview or because goo.gl has not exposed a URL previewing feature. Google would be doing its users a disservice if a URL previewing feature is not exposed sooner than later.

Finally, how long before the current crop of URL shortening services fade away or are bought by Google. With the adoption of bit.ly as the default URL shortening service by Twitter in 2009 combined with Twitter's explosive growth in 2009 the loss of bit.ly's URL resolution over time could be troubling for many.

Will goo.gl become the dominating URL shortening service or do you think services such as bit.ly and ow.ly can survive?

  • Share/Bookmark

Engaging the Teradata Community

Posted on October 2, 2009

If you are looking for Teradata developer or DBA resources, you are not going to find an equivalent to SQLServerPedia yet. The Teradata developers and DBA's aren't found tweeting about join indexes, DBQL, or fallback, nor are they  blogging about multi-value compression, UDFs, or Teradata Active System Management (TASM) on a regular basis. That doesn't mean the community doesn't exist you just have to know where to find it and how to engage it.

Piecing together the Teradata Community

Finding the pieces...

The TeradataForum

The TeradataForum has been around for over a decade now. However it is not a traditional forum, it is an independently operated, semi-moderated listserv that is maintained by John Hall.  A listserv is a lot like a party line in your Inbox. You can listen in and talk when you feel the need. However, there are some drawbacks in that conversations can't be easily taken offline as email addresses were stripped before the message goes out on the listserv. The website for the TeradataForum provides a collection of sample threads, archive of threads by year, and the ability to search the listserv via Google. All in all, it is a great resource that has been serving the community well for quite some time.

Teradata Forums

A few years back Teradata established the Teradata Forums, a traditional discussion forum, for Teradata users to congregate and discuss all things Teradata. It currently boasts over 8,000 users discussing over 4,500 topics. The Teradata Forums are a great place for those who would rather not participate in a listserv to engage the Teradata community when they have a problem or to give back to the community when they have a spare minute to answer some questions.

Teradata Developer Exchange

Announced just this summer, the Teradata Developer Exchange is the latest step toward building a stronger community for Teradata developers and DBA's. Here you will find articles submitting by some of Teradata's own brightest employees on topics ranging from Priority Scheduler, Statistics, Viewpoint, and UDF development. There is also a forum here as well that allows community members to discuss many of the same topics that are discussed on the Teradata Forums without having to leave the Developer Exchange to ask or answer a question. There is also a section here to download some of the things that may be useful to developers like an Eclipse plug-in or the recently released alpha version of SQL Assistant Java Edition.

TeradataQuestions

TeradataQuestions is the most recent member of the Teradata Community. TeradataQuestions is an independently run forum based on the Stack Overflow Knowledge Exchange. (The best example of this can be seen at StackOverflow.)  StackOverflow has become wildly successful in part because the community not only provides answers to the questions but they have the ability to flag the best answer and also vote on the question or the answers within the question. Participation in the community earns you reputation points and badges. Is there better way to encourage community involvement and self policing than by allowing your input to be voted up or down by your peers?

Get involved

The Teradata developer and DBA community is flourishing. You just have to know where the pieces are and figure out which pieces fit the missing pieces that make up your involvement in the community.  How are you engaging the Teradata developer and DBA community? Let me know in the comments...

  • Share/Bookmark

Five Ways to Embrace your Geekness

Posted on July 13, 2009

Geek Edition

Today is officially the day were us geeks have a chance to celebrate being a geek. It is an opportunity to enjoy all of our gadgets and time spent in front of the computer. Here are few ways that you can spend your day. I have done several of these already and others are on my list of things to do.

  1. Turn your $60 router into a $500+ router with Tomato Firmware. Tomato is a easy to use replacement firmware for Linksys, Buffalo, and other Broadcom-based routers. It has a simple and easy to use GUI, ability to monitor bandwidth, advance QOS, multiple DynDNS services, and other advanced features.
  2. Turbocharge your DNS services and add advanced content control using OpenDNS. By simply replacing your DNS Servers from your ISP with OpenDNS's DNS servers you gain anti-phishing protection via PhishTank and improved speed by automatically resolving your DNS requests with the DNS server that is located closest to you. Advanced content control is available to you if you choose to open a free account with them. Automatically determine how wide or restricted you want your internet to be for the entire house. No software installation is required on any computer in your house. I could dedicate an entire blog post to using this service. For more information, check out their website. I can't speak highly enough about this service.
  3. Run multiple virtual environments. Want to run Windows 7 RC on your system but don't want to dedicate a physical partition on your machine? You may want to consider trying Sun's VirtualBox. VirtualBox is available under the GPL. It supports a large number of Guest OSes including Ubuntu, Windows 7 RC, SUSE, Fedora, and many others. The host OS can be Windows, Linux, Macintosh, and OpenSolaris. The latest release, 3.0.0, includes support of Direct 3D 8/9, OpenGL 2.0, and Guest SMP with up to 32 virtual CPUs.  What else were you planning to do with that 1 terabyte hard drive?
  4. Run a SSH Proxy using PuTTY that you can access anywhere to tunnel your web browsing for increased security. Chad Perrin has provided a nice write up on how to configure a SSH proxy using PuTTY. Sadly even as Microsoft prepares to release Windows 7 they have yet to figure out a way to provide a built in SSH client or daemon. However, once you have installed Tomato firmware you can configure your own SSH server and with Port Forwarding access it from anywhere you have internet access. By signing up for a dynamic DNS hostname you can access your SSH proxy without having to remember your dynamically assigned IP address. (You can sign up for free a dynamic DNS hostname using DynDNS. Don't forget to modify the Firefox setting to use your network proxy to resolve your DNS entries as well. (about:confg -> network.proxy.socks_remote_dns = true)
  5. Brush up your 100 essential skills as a geek. Anton Olsen over at GeekDad has comprised a list of 100 essential skills any self-respecting geek should be able to accomplish. These skills inlcude being able to open a Master combination padlock in under 10 minutes, being a Google search ninja, and knowing the answer to life, the universe and everything.

Bonus Material: Do you find that your spouse, girlfriend or parents just doesn't understand your inner geek? Well here is something you can share with them: The Nerd Handbook. While your reading the Nerd Handbook be sure you add Rands to your RSS feeds, he is a fantastic blogger worth following.

Bonus Material: Here are some well known geeks worth following on Twitter: Chris Hardwick (@nerdist), Adam Savage (@donttrythis), Grant Imahara (@grantmahara), and Levar Burton (@levarburton)

I may just take a few of these items listed above and blow them out into full blog posts to show how I am using some of these. I glossed over many of them for the sake of your attention span because I know you have Twitter open, four other tabs in your browser, and your iPhone next to you playing Pandora or Last.fm.

Do you have a secret project or geek skill that you are keeping close to the chest? Why not share it below in the comments with the other readers.

  • Share/Bookmark

Improving the Signal

Posted on May 22, 2009

Twitter is full of meme's such as #musicmonday and #followfriday where people will throw out a list of music that you should add to your iPod or people you should start following. All too often these recommendations are made without any context leaving it up to you to do your homework and see if the recommendation is something valuable to you. Having a list after list of people come across TweetDeck from your followers with not context is not helping the signal. It is more bot-like and less personal.

I have recently decided to take it upon myself to make better use of the 140 characters that I am given. I have started to individually recommend people that I am following and give my followers something about that person, company, or organization that would help them decide whether or not it is worth heeding my recommendation.

For example:

#followfriday @ellohay - Enabling those without access to technology the chance to have it at their fingertips.

It takes a little more thought every Friday morning to craft my list of #followfriday recommendations. But getting into the habit of putting a little more thought in your tweets isn't such a bad thing.

What are you doing to help increase the signal in your social networking interactions?

  • Share/Bookmark
Tagged as: 1 Comment