Joshua Eddy

I've been an avid Anaheim Angels fan (I'll never call them Los Angeles) since my first game in 1984.  These days with my team in the hunt for another American League Championship; I'm sick and tired of reading all the sports "experts" writing off the Angels vs. the Red Sox. Overall Record: Angels. Runs scored: Angels. Head-to-Head: Angels.  How can the experts pick the Red Sox? In their reasoning, it always comes down to one thing, the intangibles. In the IT world, there are literally hundreds of categories of processes you may wish to document. Passwords, Network Architecture, Installed Software and their Update Histories, Backup Schedules; the list goes on and on.  Here at Attivo we considered doing what so many have done - to create a shared database containing all of this information in one place.  From that database, we have one document for each of the above categories, then refer to that document easily when we needed to. We track our own information this way, but more importantly, we keep track of this data for our clients as well. Exact Synergy ,our CRM system,  has the capability to simplify the approach by allowing us to attach this data and documents to the customers. So why did we choose to go with a "workflow" approach instead of documents? Answer: the intangibles. Before I get started, let me explain what a workflow is.  Also called a "process flow" or "request", a workflow is a pre-defined business process that carries information from one employee or resource to another, for the benefit of the required process, until the information is no longer needed. This is best exemplified by a customer comment or complaint. The comment first gets "created" by the satisfied (or angry) customer, then travels with the remarks themselves to the customer's account manager, then on to the general manager - notifying everyone along the way.  As it gets passed along, various people log their own information into the workflow, such as the date of the comment, what product or service the comment concerns, what type of comment it was, to the final resolution of the problem.  A document, on the other hand, is alot like this blog: alot of information on a white sheet of digital paper. I can sort it by category, date, and author...but that's about it.  And that's where the intangibles comes in. Suppose you're a technical support operation and you'd like to see a list of all your customers' installed software sorted by install date. But you'd also like to filter it by Operating System and sort it by the softwares' last updated date. Finally, you'd like to export that data including the updater's comments into an excel spreadsheet.  If this were an online document, you could handle the first and last parts, but all the additional fields and filters in the middle would have required customizations to the document management system that may never be completed. But with Synergy's workflow solution we have at our disposal an almost unlimited number of free fields that are searchable straight out of the box, and the requests themselves carry just as much textual data as a document.

In this modern age of internet capable "Smart-Phones" like iPhones and Blackberries, instant access to sports scores and facebook accounts, and linked email, calendars and other applications - one problem existed for all smart phone owners - until just a little while ago.  What happens to all that saved information when you lose your phone?  Contacts. Phone numbers. Addresses. Calendar Entries. Chat Usernames. All need to be re-entered into your new phone! (unless you remembered to manually backup this information to a computer).  A small application from Google (who else?) now exists that solves this problem as well as several others.  Sync automatically logs into your GMAIL (account required) online email service and synchronizes your contacts from your phone with the contacts on your GMAIL.  It will even carefully search for names that appear to be similar in order to prevent duplication. If duplication does occur, you can easily log into GMAIL from a computer at your convenience and merge similar contact records. The contact records themselves are extraordinarily detailed; affording you the ability to save unlimited Phone Numbers and Email Addresses for each contact name. Because most smart phones afford you the same luxury, all those detailed contacts are now updated on your phone the very next time the Sync application runs. Google Sync also updates your phone's calendar entries with your Google Calendar application - saving your appointments and reminders and alerting them on your phone instead of waiting for you to sign into a computer terminal to be alerted. Imagine, your own rolodex, personal reminder service and datebook - automatically updated - right in your pocket. Then, when someday the inevitable happens and you lose your phone, break your phone, or just decide to replace it: just re-install Google Sync on your next phone and let Sync update your contacts! No more fancy cord transfers and downloads! No more backups! It's all online!  I can't express to you enough how valuable this service can be. Just think about all the times you've had to send an email out to everyone you know letting them know you've "lost" their phone numbers and email addresses, and to please send them to you as soon as they can.  Now it all occurs wirelessly and in moments. To get this incredibly useful feature on your phone, visit http://m.google.com from your phone's browser and select the "Sync" application.  Then, choose your phone's make and model and begin the download. After you install with all requested permissions, sign into the application one time with your GMAIL username and password, and let Sync do the rest.

About a month ago, I encountered a dilemma while monitoring our Backup Exec software.  While our daily backup to network drive feature was humming along quite successfully, our weekly tape backup began to show repeated failures. It seemed to backup the first 60GB of our network drives and database successfully, then it would pause and ultimately fail.  I tried a few more tapes to make sure it wasn't a corruption issue, but it did not resolve the problem. Then I decided to shave a few GB off our backup policy, taking us under the 60GB threshold.  Drat. We had outgrown our taped backups. We toyed with the idea of buying bigger tapes, but that meant also updating our Tape Drive hardware itself, a significant investement that would no doubt become obsolete itself someday.  Or we could remotely backup to an offsite backup service, but this meant clogging our internet line mercilessly during backup times - and 60GB takes a very long time to transfer even over broadband. It was time to embrace a different option.  USB external drives were the answer. Not only are USB External Drives significantly more inexpensive than Tape drives, but they also have the unquestionable appeal of being able to be plugged into any computer/server - without any additional hardware to buy/install!  Additionally, the transfer rate both to and from the external drive over the USB 2.0 connection is at times more than 30x the rate of transfer we received over the old tapes.  30 hour backups on the tape systems were now taking just over an hour to complete! We purchased 2 500GB Iomega drives from http://www.tigerdirect.com for less than $100 each. They shipped in just a few days and within minutes of opening the box I had them programmed into Backup Exec to backup our entire network on a weekly basis.  They are about the same size and weight as the old tapes, but at 10x times the size they are useful for a variety of purposes beyond just backing up our system.  Now, every Monday our new routine consists of the following steps:

1. Unplug old USB drive.
2. Plug in new USB drive returned from the offsite location.
3. Return to the offsite location with the old USB drive.

There have been a whole lot of fires down here in Southern California recently, but with our new backup plan in place, we're no longer worried about losing our valuable data.

Today is Tuesday, May 12th. This officially makes it 1 week since I installed Microsoft Windows 7 Release Candidate 1 on my 3 year old Dell XPS laptop; and as I glance over at the screen, I still see the little betta fish ("beta fish!") swimming in the blue desktop. That's right, I haven't even considered going back to XP or Vista. Not this time. Not ever. I have a little experience with beta testing windows.  A few years ago, I was one of the early trial users of the new Vista operating system: then known as Longhorn. Quite a while before that, I was one of the first to try out a vastly new operating system upgrade to Windows 98 to be named Windows 2000. I would compare the changes Windows 7 brings to that first change to Windows 2000 and not the debacle that was Vista. RELIABILITY When I look back to my first experience with Windows 2000, I remember being struck by how astonishingly stable it was.  In hindsight, this was due to it being built upon the same architecture of a Windows NT server as opposed to the old MSDOS structure.  A welcome change to the all-too-common blue screen of death in those early Windows 95/98 days. Windows 7 RC1 has had just 1 application crash on me in the past week. (On day 1 it apparently didn't like my choice to install FireFox as the default browser: a second try accomplished the task.)  This may not sound so impressive, but you really need to see the new ways that Windows 7 handles basic tasks to appreciate the additional thought and design that must have gone into the new interface. Every tool, every icon, even Windows Explorer has been redesigned...not just aesthetically, but also functionally. Yes, Windows Search is still built into the start menu like in Windows Vista, but it now works all the time and is an invaluable file and application management tool. USABILITY Back when I beta tested Windows 2000, I was just an average Desktop OS user with little server experience.  Still, the user interface made the new tools and functions very simple to understand.  Disk Defragmenter, for example, was no longer the only useful item found in System Tools, but instead was located in a brand new folder called "Administrator Tools," side by side with a host of other useful goodies. Windows 7 is alot like that, but on a much grander scale.  The Windows 7 interface is remarkably intuitive when paired with our existing experiences with Windows operating systems. Back when we were introduced to Windows Vista, we were told again and again how "cool" Windows Aero would be.  Then, once I had Vista, I had to do some extensive research to learn that Windows Aero was simply a glorified Alt-Tab. A great example of an easier introduction to new Windows 7 technology is that one can learn about what a button or tool does by simply hovering the mouse over the taskbar icon.  In Windows XP and Vista you would see a little tooltip caption that would explain the window to be restored. Windows 7 has gone visual.  Now you see a thumbnail representation of the window to be restored. If that window has multiple tabs - as is now the rage in web browsers - you see a separate thumbnail for every tab within the minimized window. Then the correct tab is just a single click away - on the thumbnail - at any given moment.  PRODUCTIVITY Windows 7 is entirely about Productivity.  In addition to the mouseovers described above, the OS has made open windows easier to navigate by automatically making open windows slightly transparent as you roll your mouse over other open windows.  This reduces the NEED to repeatedly Alt-Tab or resize windows on smaller monitors as you can often see the data you need to recopy right through the window you're currently utilizing. This also works with the new and improved show-desktop tool in the tray. Mouseover that tool, and you can quickly open a new application from your desktop without minimizing a single window. MAINTAINABILITY My number one problem with Vista has always been its overbearing security features. While great for the casual employee with a Windows Vista Certified IT department monitoring the needs of the company, the security features severely increase the time it takes the casual user to get up and running with a new computer system.  The constant prompts and administrator logins are a huge pain.  But I was very pleased with Windows 7's new approach in this area. Many of those same security features are now only defaulted in the public domain.  If you are signed in with an Administrator Role, you can continue doing whatever you like unless you choose to increase the security on yourself.  Within just a day I was able to successfully install MS SQL Server 2005 Developer, MS Office 2007, and Exact Synergy Enterprise (using IIS 7.5) without problems.   The only software I have so far been unable to install has been the enterprise version of Trend Micro antivirus that we use here at Attivo, but Windows 7 was even helpful on that problem too. With just one click Windows redirected me to the Trend Micro website for a special Windows 7 supported version of their antivirus software.  Now think back to Windows Vista for a second. Do you remember any kind of help like that when Windows Vista went live? How about during it's BETA? Yeah, I didn't think so.

We all know that Event Manager is a terrific data-entry slave for businesses. Need Table 1: column A totaled and copied into Table 2:column B?  No problem. Need Table 3: column B tallied and copied into Table 3:column C? Cake. Need Table 1: column A to somehow related all the way across to Table 3: column C? Might be a little messy in SQL, but Event Manager can handle it with relative ease. But sometimes our linking between tables forces Event Manager into the position of needing to separate rows that later we need to be totaled, or vice-versa.  The quick solution to this would be to populate a free-field on each individual row with that total amount; but it's easy to see that so many "writes" are unnecessary and can cause confusion later on.  Instead, it is much more beneficial to split up the single event into 2 or more separate queries. One of The Attivo Group's customers recently needed to implement an Order Acknowledgement that would be automatically distributed when certain criteria were met.  Event Manager satisfied that initial requirement easily with a simple Order Acknowledgement Event provided with the software.  Then the customer recognized that the canned event contained Total Amounts on the order that deducted back-ordered items. While this logic makes sense to many businesses; this customer preferred to include the total amount of all order lines on the acknowledgement.  When initially contacted about this task, I explored the idea of combining the total process into the existing query, but found that I was always forced to convert linked tables from outer joins to inner joins, thereby removing my ability to display multiple rows on the acknowledgement itself.  With that idea shelved, I split my task in two. First I wrote a query to total all the order lines at the line level, and store that total on the order header.

SELECT sum(line.qty_ordered*line.unit_price) AS "total", header.ord_no, header.ID FROM (line LEFT OUTER JOIN header ON line.ord_no = header.ord_no)   GROUP BY header.ord_no, header.ID

Then the triggered event stored the "total" above in a free field at the header level, virtually next to the "incorrect" amount. 

update header set freefieldX={total} where ID={ID}

Finally, I then added an additional filter to my separate Order Acknowledgement query/event that made it ONLY query orders that had a filled in freefieldX.

SELECT line.id, line.ord_no, line.(...),header.freefieldX, header.ord_no, header.(...), etc... FROM (line LEFT OUTER JOIN header ON line.ord_no = header.ord_no)  WHERE header.freefieldX <> 0 AND header.freefieldX is not null, etc...

Notice I did not group the resulting rows together this time, as I no longer needed them to be totaled; this was already done in the previous event!  I then let the second Order Acknowledgement run as designed, with the single exception of replacing the default TOTAL AMOUNT with the amount stored in freefieldX. While this nearly completes the event's multi-step procedure, there's two small steps needed to be absolutely sure that query/event #1 always runs before query/event #2.  First, I make sure the queries/events are on the same schedule in the system.   Then I set the priority of the first event to be higher than the priority of the second event. These steps prevent event #2 from waiting until the next scheduled time before processing - thus allowing event #2 to process immediately after event #1 completes.