Is real time processing really required?

As processing power has increased, data caching has jumped to the forefront and user-demand for immediate response has grown, developers seem to have moved away from batch processing. But in a lot of situations, this can be a better approach than real-time processing.

[More]

SQL Server Tuning: Stored Procedures vs Ad Hoc Queries

When I first started writing Coldfusion applications I was very naive about data and architecture. I can admit it. I did not use components and I wrote (and often re-wrote) queries in-line when needed. As my development matured and I began to more fully understand SQL Server as an independent platform I recognized my failures.

[More]

Let Bartlet Be Bartlet

My friends know I am a huge fan of the tv show The West Wing, hence the title of this post. As I was writing my post on using stored procedures, this one slapped me in the head and began forcing its way out. Too often developers think their language of choice is the end-all be-all of the development world. As a result they force it to do every necessary function when sometimes other tools, already readily available, can provide not only a better method, but can lead to exponential performance gains.

[More]

SQL Server Tuning: Using the Tuning Wizard

A post in a troubleshooting forum on Linked In got me thinking about query optimization. The original poster asked about identifying and solving deadlock situations. Many great responses preceded mine, but it got me thinking about how I troubleshoot these problems. So I thought I would write it up over a series of posts.

[More]