Posts

Product Review – Three Smartphones and a High Speed Network

I recently dropped three new smartphones on the desktops of our technical support representatives at Nicom IT Solutions, and they immediately went to town with them. The devices, compliments of Andrew Sherbin of Rogers Communications, are the Nokia N95, the Blackberry Bold, and the Apple iPhone. All three were configured to work with Rogers’ 3G high speed wireless network that was launched this spring in Halifax and Moncton.

Nokia

The N95 is geared for multimedia. It comes with built-in stereo speakers, wires to hook it up to your home entertainment system, and a whopping 5 megapixel camera. It has a slide-out tray that contains multimedia controls on one side and a keyboard on the other. The keyboard is of the type where one key can stand for multiple letters.

The N95 even comes with a tiny clip-on remote control with the same multimedia controls as on the tray, connected via a wire to the main unit.

Read more

A Dozen Web Sites to Add to your Summer Reading Program

As we enter these dog days of summer, why don’t you take a break and visit some of
these interesting web sites to see if there are utilities you would like to use to
make your life a little easier.

I thank the folks at Nicom IT Solutions, particularly Barry Milne, for sharing these
with us. (The sentences in quotations following the web addresses are how the companies
describe themselves.)

www.xobni.com – “Drowning in Email? Find People,
Email & Attachments Instantly.” Xobni  is “inbox” spelled backward. This
is a clever little utility you can download and plug into Outlook to help you manage
your email traffic.  It keeps track of email conversations and organizes them
by person and topic. It identifies with whom you converse the most and what’s the
best time of day to find them at their computer.

Read more

SharePoint Portal Makes For Enterprise-Wide Collaboration

What a way to learn. I was with my colleagues Dave and Geoff, a couple of people from Microsoft, and a dozen or so customers at Glen Arbor Golf Course. We called it the Nicom IT Solutions/Microsoft “Golfinar”, a combination golf game and seminar.

Before we hit the links, we had a hands-on demonstration of Microsoft Office SharePoint Server, MOSS, the fastest-selling server software in Microsoft history. If you haven’t heard of it, chances are you will soon. Actually SharePoint has been out since 1999, but it is with the latest release along with Microsoft Office 2007 that it has really taken off. Some of our employees have been working with it since 1999, but they tell me it is this release that has reached the maturity required for large-scale enterprise-wide adoption.

Read more

Stay Connected with a Blackberry

this great little gizmo from rim
is incredibly small thats the thing
but i cant get the gist
of the alt and the shift
that i don’t really bother with them

I finally bit the bullet and got a Blackberry. To tell you the truth I’m not sure I need one all that much but being in technology and not owning a Blackberry just isn’t cool.

The moment of decision came when I was at a business function and I was setting up a meeting for the following week. The person I was arranging the meeting with lit up his Blackberry and asked if next Tuesday morning would be OK.

Read more

Database Replication Moves Data Efficiently Over Internet

We now have this huge computer network called the Internet and we usually think of it in terms of Web pages, but it has potential for a lot more than just providing online marketing material for us to look at. Organizations with offices across multiple locations can make use of high-speed Internet connections and replicated databases to transfer data from one place to the other, and keep one another up-to-date on what’s going on.

Replicated databases, as the name implies, are sets of data that are kept in more than one place. Since it isn’t practical to simply copy entire databases, technologies exist to keep multiple databases in sync by copying only those parts of the database that have changed. As I’ve said in past articles, at NicomIT, we work mainly with Microsoft technologies, so this article deals primarily with Microsoft SQL Server databases, although similar types of technologies are used in other database systems. Oracle, for example, offers synchronization, and there is even the capability to send data from an Oracle database to a Microsoft SQL Server databases in a replicated fashion.

We usually use what’s known as a Virtual Private Network, or VPN, running over the Internet to transmit data in replicated scenarios. A VPN can be set up on any computer and offers a secure channel, via passwords and/or data encryption, for data to flow. So you get the ease and pervasiveness of the Internet with the security of the VPN. Replicated database applications can be scaled from very simple to very complex, depending on the size and frequency of data traffic.

There are basically three types of replication: snapshot, transactional, and merged. Snapshot replication consists of simply sending a read-only copy of a database from one place to another. This would be used where periodic updates are required (say once a day or once a week) and the destination is only interested in the resultant data, not the transactions that were processed.

Transactional Replication keeps replicated databases in sync by sending every transaction from one place to the other. These may be sent in batches on a periodic basis, or done immediately. This later scenario is the most common, and requires the different locations to be always connected together.

Merged Replication is also very common, and is used where there is a centralized server and decentralized clients that are not always connected. This type of technology is similar to what you use if you have a Palm Pilot or other such PDA (personal digital assistant) that
you occasionally have to synchronize with your office computer. On occasion the clients have to be synchronized with the server, and changes made at either end are brought across to the other end. There must be rules put in place to deal with conflicts which occur when changes are made to the same record by different people.

We’re finding Merged Replication to be the most common in our client base, where multiple sites and/or agents in the field keep track of data that must be brought back to the central office, and vice-versa. One of our clients, for example, moves inventory in vans and we are setting them up so that their inventory application is available to the people in the vans, yet head office is kept up-to-date via their centralized system. Other uses we have found for replicated databases are creating subsets of data for reporting and business intelligence purposes, and for doing real-time instantaneous backups of databases in offsite locations, so that no data is lost in the case of a fire or some other disaster.

I should also note that a computer application does not have to be built with replication in mind. Replication can be retrofitted to existing applications if the need arises.

The bottom line: Replicating databases is a secure way of keeping data synchronized across multiple locations, and the network you need to send the data from one place to the other is the ubiquitous Internet.