Portfolio Spotlight: An Android App For Restaurant Savings
21 Dec 2012

Uncover potential customers on mobile and turn them into loyal buyers. As you probably know, we’ve been developing our social commerce platform – Pikaba.com – for a few years now. The platform can be used as a white-label e-commerce marketplace for any niche or industry. And now we’re proud to share our expertise to help our clients succeed. The big idea behind a new Android app we delivered for our client is to have a platform that can serve as a tool where social, local and mobile commerce meet. Get Instant Savings On The Spot The app shows users coupons and deals at restaurants nearby, with reviews and ratings from other users. The...

Mobile Walkie-Talkie Or A Skype-Like App Based On SIP Protocol
14 Dec 2012

The R&D part of our mobile division always comes up with new ideas and smart solutions. While experimenting with VOIP technologies and reimagining routing engines, they created a very special app that enables you to call people on their phones, anywhere in the world for free. The app supports iOS and Android platforms, and it makes calls to a mobile device by using its ID (or UDID). All you need is Internet connection and the app installed on your mobile device. Intrigued? Watch this video to see all the great things you can do with the app. (more…)...

Portfolio Spotlight: A B2B Website For A Telecom Company
07 Dec 2012

Tadiran Telecom is a privately held company owned by Afcon Industries, which is part of the Shlomo Group, a financially robust conglomerate involved in developing a wide variety of businesses in the industrial and services sector. The company’s global presence is well established, with over 200 Business Partners and affiliates around the world. Our web development team created a fast, clean and easy-to-navigate website that provides Tadiran’s customers and partners with Intuitive navigation Products / Solutions categories PDF downloads The site search functionality Here’s a list of tools and technologies we used while developing...

Portfolio Spotlight: SharePoint Based Solution for a Photo Restoration Community
04 Dec 2012

As a collaboration application, SharePoint (sharepoint.microsoft.com) helps simplify business intelligence, content management, search, and sharing for intranet and internet sites. Using SharePoint 2010 and Silverlight 4 (microsoft.com/silverlight/) – as per the client’s requirements – our web development team created a portal for photo restoration artists with features ranging from File System and Image Viewer (we used jQuery for the latter) to online collaboration, file moderation and sharing. We did this short video review so you can see the website in action: https://youtu.be/xge1Qc5dVZ0 Some interesting facts about SharePoint: ...

SAP HANA — a New Database Management System
08 Oct 2012

In 2007 I worked for a company which provided data warehousing solutions. Our biggest client database was about 2-3 TB which was not so much even five years ago, but because of extremely complicated ETL and complex reports we had a lot of troubles. We spent hundreds of hours monthly on code optimization, but every 30 minutes saved on ETL and processing were compensated with monthly data growth and we had to start over and over. Finally it comes the time when we couldn’t improve anything else in programming code and company decided to drastically upgrade the hardware. But extremely expensive servers and disk storages gives us only several pe...

Case Study: A Note-Taking Application for iPad
18 Sep 2012

The exciting thing about custom development is that with every project we learn something new. And it’s awesome that we have clients who want us to work our magic on their projects. Take, for example, the recent game on Unity 3D or the pissing contests app, where Accelerometer and Cocos2d were used as the core technologies. After all, the mobile landscape is a fast moving target. From HTML5 to native apps, we’re seeing new interesting solutions are spreading extremely quickly. Now, for a note-taking app for iPad, we used Dragon SDK for voice recognition and picture-in-picture (PiP) technology. The app lets you to write, scribble, add pic...

Case Study: We Can Build Games with Unity 3D Engine
12 Sep 2012

Are you a King’s Bounty fan who follows King Maximus since 1991 (yeah, times flies)? Then we have some good news for you. Our mobile development team started experimenting with Unity 3D – a neat tool for video game development, architectural visualizations, and interactive media installations. As you guessed, the platform was used for creating King’s Bounty. King’s Bounty: Legions is the world’s first 3D social strategy game. Unity’s development environment runs on Microsoft Windows and Mac OS X, and the games it produces can be run on Windows, Mac, Xbox 360, PlayStation 3, Wii, iOS and Android. Don’t you ag...

Case Study: CountDown — an iOS App for Event Planning
27 Aug 2012

  Developed by our mobile development team for IAM Web Services LLC, the CountDown event app allows you to count down or count up until important dates. This can be birthdays, adventures, weddings, holidays, concerts, parties, new movies coming out and other events you’re excited about. Then we integrated the CountDown iOS app for event planning with the iAd Network. This provides our customers with an automated and intuitive environment to easily incorporate iAd rich media ads into the app. Also, this solution helps monitor advertisement performance and track revenue. What users are saying about the CountDown iOS app for even...

oracle sequences
How to Emulate Oracle Sequences in SQL Server
14 Aug 2012

When migrating Oracle tables to SQL Server, the most common problem you will face is sequence conversion. SQL Server 2008 does not have any object even distantly resembling an Oracle sequence, and some trade-offs are inevitable when you make decisions about the mechanisms to implement its behavior in the target system. In SQL Server 2012 Microsoft introduced sequences, but several incompatibilities with Oracle implementation still exist. First, let us discuss what you can do if the target system is SQL Server 2008. (more…)...

Create Autonomous Transactions in SQL Server banner
How to Create Autonomous Transactions in SQL Server
13 Aug 2012

You probably heard about autonomous transactions in Oracle. In a few words, using just one pragma directive in a PL/SQL block you can isolate it from the callers’ context, so it becomes independent transaction. It’s quite useful if you want organize data audit and is pretty widely used in production databases. As you might guess these autonomous transactions do not have direct equivalent in Microsoft SQL Server. The only way to isolate a Transact-SQL block from a transaction context is to open a new connection. There are several options here, so let’s start with SSMA approach. Automated conversion Assume that we have some logging logic ...