(John Goodson) Developing performance-oriented .NET applications is not easy. The .NET standard includes only basic guidelines and interface definitions to help programmers develop .NET applications. In addition, .NET data providers do not throw exceptions to say that your code is running too slowly

(Chris Sully) The intention of this article is to provide a brief overview of the main features of the new version of SQLServer (Yukon) that will be of interest to developers. Note that the information presented is based on the Beta 1 release. This is not available as of the time of writing, and

(Syed Hasan Adil) Imagine yourself in front of an exquisite buffet filled with numerous delicacies. Your goal is to try them all out, but you need to decide in which order. What exchange of taste will maximize the overall pleasure? Although much less pleasurable and subjective, this is the kind

A common web application architecture is one or more application servers which handle requests from client browsers by consulting one or more database servers and performing a transform on the data. When an application must consult the database on every request, the interaction with the database

(Martin Fowler and Pramod Sadalage) In the last few years, we’ve seen the rise of a new breed of software methodologies, the agile methodologies. These make some new and significant demands on database design. One of the most central of these demands is the idea of evolutionary design. On an agi

(Garry Robinson) In this chapter, we discuss PL/SQL efficiency. We have deliberately avoided the term “performance” because efficiency is more than just performance. We’ll define exactly what we mean by “efficient PL/SQL” and explain how to ensure that the PL/SQL you build meets that definition.

(Craig Stuntz) When writing a WHERE clause in your InterBase SQL, it would sometimes be convenient to write WHERE FOO IN (:SomeParam) and pass a list of values to SomeParam. You can’t do that; here’s why. Note: This article applies to InterBase. However, many SQL database servers have a similar

(Kay Lee) With security being the strongest aspect of major development issues, encryption for sensitive data is essential in everyday development. MD5 hashing algorithm is one of the most commonly used algorithms and, mixed with salted hash, is one of the best. Let’s stop fluffing, and get right to

(Tharak Ram) I take this opportunity to write about the Command line switches for making our .NET Project Release Builds without much fuss. The Reason I am writing this is that this topic mentioned above is much ignored topic across .NET developers circles.

Developers and documentation are like oil and water—they just don’t mix well. Many developers find writing documentation to be a boring waste of time. It’s no wonder, then, that most companies hire separate personnel to create technical documentation rather than try to persuade developers and progra