Friday, November 13, 2009

Sage Summit Recap

We set up our booth at Sage Summit 2009 with fairly low expectations of any kind of turnout. As the doors opened for the Tradeshow we were surprised to have several visitors to our booth. But more than that, the people that were there, seemed to be there hungry to find solutions to better their business. And as the conference progressed, we received plenty of traffic to our booth.

Our iPhone App for hh2 Remote Payroll was a huge success there. Even though all we had was a poster and a live demo on my laptop and iPhone, we impressed everyone who stopped by. Some people asked us if we’re also going to build an interface for the Blackberry, but we had to tell them that it wasn’t in our immediate plans. Several others left excited because their company had already made the switch to iPhones and couldn’t wait until the final release. One lady asked if she could take home our poster because it was perfect to show her colleagues back at the home office.

It was fun to stand out and really be different from the rest of the solutions there. By adding the iPhone as a new client interface for our hh2 Remote Payroll software, we are boldly stating the claim that the iPhone is ready for the construction industry. And boy did we get some attention. The Otterbox cases allowed us to drop our phones on the hard floor and show the durability of the cases and the phone inside.

We also got the chance to demonstrate the software, including the iPhone App, to several key Sage Executives who stopped by our booth. We just couldn’t have bought that kind of face time. Strengthening our ties with Sage will help us accomplish our goals of developing outstanding web services for the construction industry and making them affordable for companies of all sizes.

While there we got to see some of the sites and restaurants of Atlanta Georgia. We ate one night at a small but very nice diner called Wysteria. The seafood there is excellent. I personally ate the Skate which is kind of like Stingray, but to me, it tasted like halibut. Another night we ate at another seafood place called Six Feet Under. It too had excellent food. We ate the Snow Crab Legs there. Very Good.

All in all is was a very productive trip. Made some friends, forged some partnerships, found several very intriguing prospects, and sure made some impressions on the people we met with.

Thursday, November 5, 2009

Sage Summit 2009

hh2 Web Services is headed to Altanta Georgia next week for Sage Summit 2009. Held from the 9th through the 12th of November, this is the conference where customers of Sage come to see the latest from the software they depend upon. We will be exhibiting in booth #810. We’ll be showing off an early beta of our iPhone app for hh2 Remote Payroll. If you are going to be attending the conference, we would love for you to come and see us. We can also break out and give one on one cusultations between Trade Show Exhibition times.

Tuesday, November 3, 2009

Snapshots

In my last post we discussed Storage Area Networks or SANs and their outstanding abilities to manage your storage needs. There is a lot more technical information we can cover on SANs but I decided a followup post was needed to explain what a snapshot is.

For many companies in the construction industry, they might have a single server that has their accounting and file serving roles combined. As storage runs out and processing and memory run dry, inevitably, an additional hardware server will be required. For those companies, many have a dedicated file server, and users simply access the data on in through a UNC path \\Servername\Sharename, or the IT director maps the UNC share to a mapped drive for the users. Backup and recovery is typically done either through a USB drive or a Tape drive. Although there are many valid reasons for using these methods for backup, Snapshots provide huge advantages to traditional tape backup and even some big advantages over simple disk backup, but snaps are not a total backup solution unless they are used in conjunction with a cloned volume on a SAN.

OK, now what is a snapshot. A snapshot is a picture of what a volume looked like at an exact point in time. Snapshots can be done instantly but accurately record an entire volume, even if the volume is hundreds of gigabytes. How can it do this so quickly and yet use up such a small amount of space? Well the snapshot actually uses the volume it snaps as the data for the snap. So when a snap is made, nothing really happens, other than a record that a snap was made. Then as the contents of files, actually the individual sectors on the volume, are changed, it writes the changes to an unused sector and maps the old sectors to the snap. Using this method the original volume can make changes throughout the course of business and the snaps gradually get the old sectors mapped to it so by combining the volume as it stands now and substituting the old sectors, the snapshot can recreate the data as it existed at the exact moment of the snap. For volumes that do not change that often, snaps typically remain small and only contain the data that has changed since the snap. For volumes that have transactional data that change frequently, the snaps can eventually take up as much space as the volume itself, but never more than the volume. Snaps do not cause additional I/O load on the drive and can be accessed at any time and mounted as new volumes that you can recover data from.

The real disadvantage with snaps is that it relies on the the original volume staying intact and healthy in order to recover data. This means snaps are awesome for recovering corrupt or deleted files, but do not allow you to recover from a complete volume failure. For that, you mitigate the risk by using raid or SAN technology, and then use another solution for offsite backup. While some might think this limits the usefullness of snapshots, most of the recovery that takes place in the IT world is due to deleted and damaged files, not storage system crashes.

How do you get your hands on snapshots? Three ways I know of. Buy snapshotting software, get a direct attached storage array that supports it, or get yourself a Storage Area Network. The latter of which I am a fan of. I’ll post another article about snapshot scheduling and remote snapshots, both features of high end SANs.

Monday, November 2, 2009

Storage Area Networks or SANs

Storage Area Networks are cool. Everyone should have one. What are they, you say? Why would a respectable construction company want one, you say? Let’s just explore that for a moment shall we.
Storage Area Networks consolidate your data storage into a single device or cluster of devices that then lend their storage to the computers or servers that need the storage capacity. In plain english, it simply means you get one big server with a lot of hard drives, and use that server to provide storage to all your other servers. SANs make their storage available to the other servers usually through iSCSI or FibreChannel and the servers behave as though the storage is internal, meaning the storage shows up as a single hard drive in the OS disk management. On top of that, you get a ton of extra managment capabilities that you just can’t get any other way.

SANs Reduce IT Costs

SANs are expensive, so how is the cost justified? Having a SAN means that you don’t have to pour so much money into every single server you buy making sure it has enough capacity, redundancy, and storage performance you need for the application. You only need to make sure it has enough hard disk resources for the OS and Server Applications. Then you put all the data on a SAN volume.

SANs Make Adding Capacity Easy

You might think your project folder will last forever with 100GB of space but think again. In this age of paperless office and digital take-offs construction companies are using more storage space than ever. If you are using a SAN, its no problem, just increase the volume to 500GB or even 1TB when its needed. A simple command run in a command prompt and the OS now knows it has the extra capacity. No reformatting, no copying data, no upgrading your server.

SANs Have Outstanding Snapshotting Skills

Want to snapshot your volume on an hourly basis so that you can recover a file someone accidentally deleted 10 minutes ago. No problem. Most SANs support overlapping Snapshot schedules that auto delete aging snaps. Want another schedule that does 1 snap per day for 10 days, and another schedule that snaps the volume 1 time per week for 6 weeks. No Problem!

SANs Have Advanced Storage Features

Now all these big volumes can use up your SAN fast right? Not with thin provisioning. Your SAN tells the OS it has a 1TB but really, the SAN only gives it 100GB. The SAN will automatically allocate more space as it gets used and you get alerts as certain thresholds are passed. Awesome!
What about backup? Most SANs support remote volume cloning or snap shotting which makes sure you have a high performance method of backing up offsite, and an easy, high performance way of disaster recovery as well. Just plain cool!

SANs Can Outperform Internal Storage

Since you have spent your pennies buying a high performance SAN, you dont need to buy expensive systems for each server. The SAN will likely outperform what you would put in those servers anyway. If you find that your SAN is starting to lag in performance, most SAN solutions allow you to simply add a new SAN server and add it to the cluster. In a matter of minutes, your SAN begins to replicate and load balance accross the SAN (It’s not called a storage area NETWORK for nothing). You’ll find that you can build your SAN incrementally as your budget allows so that even the tiniest volume mounted on the lowliest server in your network has over 100 hard disks or better yet solid state disks serving up data at speeds just not achievable without ordering all your servers with massive dedicated direct attached storage.

Conclusion

I actually have a lot more to say about SANs. I’ll make some future posts that concentrate more on how they are used and also talk more about the specific vendors and costs. I can say that for hh2 Web Services, we use iSCSI SANs because they are high performance and cost effective. And after using two other solutions in production, I can say with confidence that Dell’s Equallogic platform is the best iSCSI solution on the market. I believe you get the most bang for the buck. Beat Dell up a little on the price when you negotiate though. They usually have wiggle room in the pricing for a first time customer.

hh2 Web Services

Let’s explain a little bit about hh2 Web Services. hh2 Web Services is a suite of tools that come in the form of a fully hosted website that helps companies in the construction industry better collaborate with thier employees out in the field. We work primarily with companies using Sage Timberline Office as their accouting system. We could technically plumb the integration with any construction accounting system, but hey, Sage Timberline Office is the standard, and it will keep getting better…trust us. The current modules include the following:
  • hh2 Remote Payroll – An online web service designed to capture, approve, and report on payroll data from anywhere in the world and integrate it into the home office accouting system.
  • hh2 Human Resources – An online web service designed to manage employee information and make it available, securely to those who need it, where ever and when ever they need it.
  • hh2 Field Reports – An online web service allowing field or office personnel to manage daily project information into a legal log so the the events of the day can be archived for managerial or legal use.
These modules work together in a single website that we host. A synchronization client makes sure the data on the website and the data in the accounting system stay synchronized. There’s a lot more to say about it, but you can check it out for yourself at http://www.hh2.com/.

Welcome to hh2 Power Tools

This is the official blog of hh2 Web Services. Here we will discuss technology trends that we have learned through our own blood, sweat and tears. We hope to inspire all who use technology to use it more effectively, and to look to technology and web based collaboration to streamline your businesses. But more importantly, since we provide web based technology to the construction industry, we hope to provide some best practices for companies that use Sage Timeberline Office, an accounting and estimating system dedicated to the construction and real estate industry.