I’m getting my first experience working with the newest version of Microsoft’s SQL Server. We recently installed SQL Server 2008 at a client and we are setting up a web application on their servers now.

In  my experience with SQL when I needed to edit data in a table I would right-click on the table name and select "Open Table" to display all the data in that table. I realize this probably isn’t the preferred or perhaps even "correct" method to use, but for me it worked, was quick and allowed me to immediately edit data in the table.
With SQL Server …read more

Filemaker Inc. announced today, the mobile version of its Bento database application. For $4.99, iPhone and iPod Touch users can have the power of Bento in their hands. They can use it as standalone application for their mobile device or in tandem with the desktop app in order to sync and have their data wherever they go.
The mobile app comes with 25 pre-designed and ready to use templates, which can have you up and running in minutes. They’re also customizable so that you can add other data that you want. It also ships with a blank template so you can …read more

I’ve run across a little bit of an issue with an application for a client that we’ve been working on the last few days. We’ve re-written an Access database application. Our normal protocol is to always separate the data from the application.
The problem is that when we do this the application runs it’s processing routines and queries run at fractions of the speed. When the data and application are joined, the queries run and process 300+ records in just over a minute. When separated that time jumps to about 30-45 minutes.
Has anyone seen this and determined a solution for making …read more