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) and bilinear interpolation (for filling in missing pixels).   Rotate and shrink photos, correct image distortion, clone areas, edit in portrait and landscape modes, zooming...

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 the iOS app for a client: OpenCV – aka Open Source Computer Vision Library, a neat library of programming functions main...

Column-Oriented Database banner
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. And 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, update, and delete that data. Most database vendors like Oracle, Microsoft, Sybase, Informix,...

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...

Featured Project: An Awesome Coloring App for iPad
16 Jul 2012

Kids love coloring. They love being able to create something to remember. And they can learn new skills and develop creativity while coloring on the iPad. On the other hand, parents are happy when their children are spending time with educational tools – sometimes coloring keeps kids entertained for hours. Definitely a win-win situation. There’s no shortage in coloring apps on the market, but we believe we’ve created a very efficient and beautiful one that children will love and find it hard to put down. For this educational app, our Design and Mobile Development teams are using Scalable Vector Graphics as SVG drawings can ...

Case Study: A Video Streaming App for Android
13 Jul 2012

Our client wanted to create a visually engaging app that streams completely safe, parent-friendly cartoons (clips, full episodes, trailers, and features). It’s like creating a mobile entertainment channel for 3- to 8-year-old children that fits right into the palm of their hand. The Process The server side and the API for this application were provided by the customer. Our Mobile Development crew ported the app from iOS to Android. The app is optimized for tablet PCs and smartphones. To support constantly updated video content, we created a custom video player that supports https media streaming and allow watching a video in any way you lik...

Team Behind DB Best: The Books We Read
05 Jul 2012

Today I decided to take a 10-minute walk around the office to see what my colleagues are doing. Can you imagine my surprise when I discovered that almost everyone was reading. I quickly turned on my camera and now you can see what sort of books make us tick. Natalie, DBA maven – Windows PowerShell 2.0 Best Practices by Ed Wilson. “This guide captures the field-tested tips, real-world lessons, and candid advice of practitioners across the range of business and technical scenarios and across the scripting life cycle.”   Mike, creative juice – Graphic Design Now by Charlotte and Peter Fiell. “What is ...

raising errors from UDF
How to Raise an Exception in SQL Server User Defined Functions
02 Jul 2012

There are a lot of differences between Oracle and MS SQL Server and you will face many of them trying to move your database from one platform to another. If you use SSMA, which we highly recommend, you can avoid countless hours of manual work, but you will have to solve some specific problems by yourself after the SSMA job has finished. One of them can be raising errors from UDF, which you can easily do in Oracle and can’t in SQL Server. Let’s discover the workarounds to raise an exception in SQL Server User Defined Functions because of T-SQL limitations for UDF. Converting Oracle UDF to SQL Server So let’s create some pretty simple...