Have you ever been writing a new view and had the need to use an ORDER BY only to be greeted by an error message when you go to create the view. Never fear, there is a solution. ORDER BY can only be used in views, inline functions, derived tables, sub-queries, and common table [...]
In recent years, the boom in mobile devices has caused more and more users to abandon their desktop internet browsers and opt for the ones sitting in their pocket. As a result, nearly 10% of 2011’s internet traffic was attributed to mobile device browsers. As more people are browsing the internet in this manner, it [...]
 Experience 1 : No ServerPassword?Â
The client required a scheduled transfer of multiple TIF files from one server to another over FTP. Since this task was initially implemented using SSIS, the change seemed to be trivial; I would create a new FTP Connection in the job’s Connection Manager window and replace the current copy task (a [...]
Recently I was tasked with migrating a Microsoft Access 2010 database to SQL Server 2008 R2 while preserving the form functionality built into Access. While the migration using Microsoft Access’ ‘Upsizing Wizard’ was easy enough for a majority of the objects, I found that a few of the more complex Access queries and tables needed [...]
Requirements
jQuery (tested on 1.6.2)
Introduction
Limiting the character length on a text input is one of the most commonly used patterns in web applications. In this post I’ll go over an easily re-usable implementation that is compatible with Internet Explorer, Firefox and Chrome using jQuery
Considerations
Setting a character length limit on text input is fairly simple to implement. [...]
So, I was trying to hook up Quartz.NET with a Windows Service to provide a scheduled job that would execute on a daily trigger. I am using SQL Server as the persistence store for the jobs and triggers created by quartz.
I deployed and tested it on my local box and everything was working great until [...]
Requirements
Android SDK (version r11)
Robotium (version 3.0)
Eclipse Helios
Introduction
Automated tests are key in maintaining high quality software. They help catch bugs immediately when introducing new code and also ensure that new features do not conflict with existing functionality. Another advantage of automated tests, specially for Android applications is that it greatly speeds up testing when you have [...]
Requirements
I will assume the following has been installed and configured.
Android SDK (r07 or later)
Maven 3 (version 3.0.3)
Set environment variable ANDROID_HOME to point to the root directory of the Android SDK.
Add ANDROID_HOME/tools to your PATH environment variable.
An Android project to build
Introduction
Building an Android project consists of 3 steps. The code is compiled to create an executable [...]
The first keynote of Build was all about the launch of new Windows 8 for developers. As they said, Windows 8 is a reimaging of the way we interact with devices and use computers. With all this reimaging comes some major changes to the development paradigms that we are currently use to and [...]
Posted in Uncategorized | Tagged WinRT |
Background
I was preparing for a convention where Tallan was going to demonstrate two web-based systems in an exhibit hall. To do this, I needed to setup Virtual Hard Disks (VHDs) running Windows Server 2008 R2. I wanted to be able to run the VHDs in a Virtual Machine (VM) so that I could setup the [...]