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 […]

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, […]

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 […]

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, like birthdays, adventures, weddings, holidays, concerts, parties, new movies coming out and other events you’re excited about. The app is integrated with the iAd Network providing our customer with an automated and intuitive environment to easily incorporate iAd rich media ads into the app, monitor advertisement performance, and track revenue. What users are saying? A funky design Aesthetically pleasing […]

How to Emulate Oracle Sequences in SQL Server
14 Aug 2012

When migrating Oracle tables to SQL Server, the problem of sequence conversion is one of the most common. SQL Server 2008 does not have any object even distantly resembling an Oracle sequence, and some tradeoffs 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 […]

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 […]

Case Study: Custom Developed iOS Graphics Library
28 Jul 2012

Beauty salons and plastic surgery clinics are now entering into the mobile app scene. And we take tremendous satisfaction in watching a client’s business grow and in knowing that we’re a part of their success. In this video case-study, we’d like to show you an app that allows image editing almost on the fly. The graphics library we developed is a core part of the app – it uses mesh-warping algorithm (Bezier curve for warping the images and various effects) […]

Case Study: Augmented Reality Development for iOS
26 Jul 2012

If you’re familiar with Google’s ‘Project Glass’, The Layar app and Sherlock (TV series), you already know what Augmented Reality is and how cool it looks, especially on mobile devices. Being a part of a parent concept called Mediated Reality, Augmented Reality is a view of a physical, real-world environment whose elements are augmented by a computer-generated sensory input – graphics, video sound, or GPS data.” In this video, we’d like to showcase three core technologies we used while developing […]

Column-Oriented Database Technologies
24 Jul 2012

Column-Oriented Database Technologies (click to download) My recent blog (Big Data & NoSQL Technologies) discussed various NoSQL technologies and market vendors.  Today let’s dive into column-oriented databases and why they should play an important role in any data warehouse whose focus is on aggregations or metrics (and whose isn’t?). So you are all probably familiar with row-oriented databases.  Tables of data where rows of fields (also called columns) represent the structural storage and the corresponding SQL queries that select, insert, […]

We Are The V-TSP Champions
23 Jul 2012

Each year the Microsoft Worldwide Partner Conference – the company’s premier annual event for industry peers and partners – offers technology partners the opportunity to vie for awards in three different categories (Sales, Technology, and V-TSP achievements). For the 3rd year in a row (we hear the sound of applause), Microsoft recognized our efforts in helping customers modernize their applications and infrastructure. Now in Toronto, Canada (July 8-12), DB Best Technologies (DBbest.com) received the Microsoft Platform Modernization Award for V-TSP Achievement, with special recognition for: Database migration focus Field […]