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