Author Archives: Dylan Barrett

The SQL Server OVER Clause

One useful feature in SQL Server is something called the OVER clause. The OVER clause has been available since SQL Server 2005 and allows you to perform window functions over a set of data.  SQL Server provides two types of window functions: aggregate window functions and ranking window functions.  I will explain what aggregate [...]

Posted in SQL Server | Tagged , , | 2 Comments

Java EE 6 Overview

Introduction
For the past year or so I have been working on a web development project using Java.  Like many Java projects, the project I was working on used 3rd party frameworks like Spring and Hibernate rather than utilizing the official Java EE stack.  Many developers have turned to these frameworks because the official Java EE [...]

Posted in Enterprise Java | Tagged | Leave a comment

jQuery Part 3: Advanced jQuery

Introduction
Welcome to the third and final installment of the jQuery saga.  This post will cover some of the more advanced features of jQuery such as Ajax, utility functions and plugins.  Along the way I will give examples that show how to use the functionality.  I suggest that you read through the first two parts of [...]

Posted in JavaScript, jQuery | Tagged , | Leave a comment

jQuery Part 2: More jQuery Basics

Introduction
Welcome to the second part of my overview of jQuery. This article is part of a 3 part series. If you did not read the first article, you may want to go back and read that first. This article is going to pick up where the [...]

Posted in JavaScript, jQuery | Tagged , | 1 Comment

The Unstandard Tag Library: Using Constants Within JSPs

Introduction
The Unstandard Tag Library is a JSP tag library that was developed as part of the Jakarta Project. Its purpose is to provide a collection of useful tags that people have been requesting for JSTL. The library serves as a place to keep all of these tags [...]

Posted in Enterprise Java | Tagged , | Leave a comment

jQuery Part 1: jQuery Basics

Introduction
Welcome to my first blog post on the topic of jQuery. This is the first part of a three part series. This post will cover most of the basic features of jQuery. The next post will wrap up the basic [...]

Posted in JavaScript, jQuery | Tagged , | 1 Comment