Scala scripts are often used to quickly test Scala code or try out new ideas, but they also work well for handling small, one-time tasks or data conversions. For example, I often need to convert data from one format to another such as converting … [Continue reading]
Parse.com Cloud Code is like JavaScript Pseudo-Triggers on MongoDB
Using Parse.com allows me tremendous simplicity when writing mobile apps: it lets me focus on just writing the mobile code and the database, but lets me use an N-tier deployment model and a remote NoSQL database. However, there are times when I … [Continue reading]
How to Restore a Single iOS App from a Backup
As an iOS app developer, there are times when you need to restore an old version of an iOS app from a backup. Or perhaps the vendor of your favorite app released a particularly bad or buggy update, and you’d like to go back to the previous version … [Continue reading]
Parse.com – All the Joys of a RESTful Server without the Coding
Many times my mobile apps need a remote or a shared database, but often they need nothing more than only that: the mobile client and the remote database. I could write a new RESTful server for each of those apps but when the app needs only standard … [Continue reading]
Stored Procedure to Display Row Counts for all Tables in any SQL Server Database
Using the technique I discussed in this post, the following SQL Server stored procedure can be used to display the number of rows in each table and used/unused space for all tables in a specified database. Put the stored procedure into whatever … [Continue reading]