IT CHALLENGES

I operate a business, Cinevate, that designs and manufactures highly innovative tools for filmmakers. As a former IT analyst, I’ve been experimenting with NAS units, LAN topolology and affordable integrating into typical video and photo editing workflow.Stillmotion is a highly successful studio based out of Toronto, Canada, that is raising the bar for wedding and corporate video world wide.  With an award winning team of both photographers and cinematographers (sponsored by Cinevate, Canon and Steadicam), the team travels worldwide with a pile of equipment including from two to five MacBook Pro laptops.  Once back in their studio, data that was backed ...

We have unbalanced binary tree, growing at speed of 5,000 new records in a day. Database is MSSQL 2005. We are using stored procedures (looping) to count legs for each ID. We want to know what should be the best method to do such calculations?

Our office has multiple users who want remote access to a database system. Possible complication is that we have multiple IP addresses. We don’t have a full-time IT person, so the system has to be easy to set up and administrate. I also want to control who has access. Finally, I like the router/gateway we have, which doesn’t have VPN endpoint capability. So I don’t want to buy a new router. What’s the best way to do this? If I went with a service like GoToMyPC, can it be centrally administrated? Or should I swallow hard and get a VPN/SSL gateway router? SHARETHIS.addEntry({ title: ...

We’re a company comprised of 22 separate North American locations with roughly 2,500 users. We’ve also got a multinational presence that probably numbers in the 20k user range. We use various versions of Windows server products and Windows desktop OS’s. We are currently researching VASTLY expensive products to prevent data leakage by preventing printing on specific documents for specific users, prevent transfers to USB (or only allow to approved devices for approved users), prevent emailing, etc.. etc.. while educating the user about their infraction. It would be great to have some really quantitative advice on how Microsoft RMS (Rights Management Services) ...

There’s a local real estate office where agents each have their own Wi-Fi connected notebooks, which they use on the office network. Access isn’t required just for the Internet, but also to files on the office server. So simple “guest” access isn’t an option. The office doesn’t have a full, or even part-time IT person, so setting up and maintaining RADIUS-based authentication probably isn’t an option. Given the nature of the business, turnover is high. So what’s the best approach for providing secure wireless access while agents are here, but ensuring they can no longer access the network once they leave? SHARETHIS.addEntry({ title: ...