Jerry Dixon

Over the past year, I've been discussing some of the various technologies found inside SQL Server 2005. Three of these technologies are CLR integration, HTTP endpoints, and Service Broker. (Articles on these topics were published, respectively, in the November 2005, March 2006, a... (more)

Over the past year, I've been discussing some of the various technologies found inside SQL Server 2005. Three of these technologies are CLR integration, HTTP endpoints, and Service Broker. (Articles on these topics were published, respectively, in the November 2005, March 2006, a... (more)

In today's complex and demanding environments, it is quite common for users to be able to submit requests faster than those requests can be processed. In some situations, this is because the system has an enormous number of users. In other situations, it is because the requests t... (more)

A number of years ago, I worked for a company that was developing internal applications with SQL Server 2000. We didn't have any real database administrators. I was given that responsibility, but I was really a developer, one of many in fact. The problem with this arrangement was... (more)

SQL Server 2005 has many new and improved features. So many, in fact, that it would be very difficult to cover them all thoroughly. Therefore, I've been concentrating on those features that I feel will have the most impact on developers. Because of this, I want to present two mor... (more)

These days, applications built around a service-oriented architecture (SOA) are all the rage. Complex systems can be written as a collection of services that communicate with each other through standard protocols. When implemented properly, these systems can become immensely flex... (more)

Sequential numbers. Sooner or later, you'll find a process that requires you to generate a series of sequential numbers. As a matter of fact, most database engines provide at least one method of producing such numbers. Microsoft Access, for example, has AutoNumber columns, while ... (more)

Do you love XML? Have you been using XML with SQL Server? Many people have, starting way back when with SQL Server 7.0. Back then, there was no support for XML in the database, so we had to write external programs to convert the relational data into an XML format. This was time-c... (more)

Have you ever heard the expression "I want it so bad that I can taste it?" Well, that's the way I feel about SQL Server 2005. I've been looking forward to the official release for quite some time. When people ask me why, I usually say "SELECT TOP X." In addition to generating som... (more)

For most of this year, I've been giving presentations and teaching classes on various aspects of Visual Studio 2005 and SQL Server 2005. In my consulting role, I've been constantly presented with problems that, while definitely solvable with current tools, simply screamed for the... (more)

In a previous article (DNDJ Volume 3, issue 4), I discussed an application that had to load, process, and transmit data received from multiple customers. The system had to perform a specific set of tasks or steps for each customer. Because of the diverse needs of each customer, h... (more)

Like many of you, I have been using .NET since before it was officially released. Even now, after years of using the product, I am still impressed by its incredibly flexible nature. When using the classes in the .NET framework, there are usually half a dozen ways of performing th... (more)