(Robin Schumacher) I live in absolute and abject poverty. No, I don’t mean financially – I’ve been blessed beyond what I deserve and MySQL pays me very well. What I mean is that I am utterly time poor. Isn’t it amazing how you can be so free in terms of lifestyle and yet have so little time to enjoy
Author: SSWUG Research
WCF Messaging Fundamentals
(Aaron Skonnard) When you start pulling the layers away from Windows Communication Foundation, you find a sophisticated XML-based messaging framework that offers a world of possibilities when connecting systems using a variety of protocols and formats. In this month’s column, I am highlighting some
Scaling your SQL Server system
(Tim Chapman) What do you do when your database servers become busy and performance deteriorates? Is it better to purchase more hardware to beef up your servers, or do you rethink your database server design so your database platform is highly scalable?
Use XForms to create an accounting tool, Part 1: The making of X-Trapolate
(Stony Yakovac) This six-part series demonstrates how to leverage the power of XForms in conjunction with MySQL and PHP for support processing to create an online accounting tool called “X-Trapolate.” Every good programming technology possesses a range of problems it excels at solving. The series hi
Data Entry application with PIVOT processing in GridView
(Ole E.) The standard GridView does not work very well for data-entry pages. The GridView class is however very flexible and may be adapted in different ways
DATEDIFF Function Demystified
(Peter Larsson) I have seen many questions about the DATEDIFF function where people are baffled about why it doesn’t calculate the correct result. The short answer is ‘It does’.” This article discusses the DATEDIFF function and provides two functions that calculate years and months the way you think
Dojo AJAX with JSON
(Jayaram Krishnaswamy) The DOJO toolkit is an extension of JavaScript being developed by the dojo foundation. The present release version is 0.4.1 and it is still very much in development. Notwithstanding, it has a lot of promise in delivering AJAX enabled rich internet applications. It has been use
How to Correlate a SQL Server 2005 Profiler Trace With System Monitor Performance Counter Data
(Brad M. McGehee) Before SQL Server 2005 became available, I often ran into two situations when using either Profiler or System Monitor that were completely frustrating. First, I’d see a long duration event in Profiler and I wanted to know how it affected server performance. Or second, I would see a
Oracle 10gR2 RAC Load Balancing Features
(Jim Czuprynski) To insure an even workload distribution, a clustered database must employ methods to distribute incoming sessions evenly and effectively across the various components of its cluster. This article explores how Oracle 10gR2 takes advantage of simple client-side connection load balanci
Working With Dynamically Added Controls
(Gaidar Magdanurov) It is very easy to use ASP.NET controls on a web form. You may drop a control on a form in the Visual Studio designer or type in markup code for a control manually. After that you may reference a control by its ID.