(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?
Other News
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
A DBA’s Guide to the MySQL User’s Conference
(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
Oracle to Buy Tangosol for Data Grid Help
(Darryl K. Taft) Amid the aggressive churn of the rumor mill, Oracle has announced that it is has entered into an agreement to acquire Tangosol, a provider of in-memory data grid software.
Download DataStage 8, Information Analyzer and IBM Information Server for Windows AIX and Linux
(Vincent McBurney) Looks like the Information Server 8.0.1 is now available for AIX, Linux and Windows and can be downloaded from the IBM website.
XML Driven Validation
(Subal Mishra) Input validation ensures a user not only enters or selects values when required but also enters appropriate and correctly formatted values. Any user input form/window that support insert, update, delete or any calculated functions are all common scenarios where input validation should
Control presentation with ASP.NET 2.0’s FormView control
(Tony Patton) ASP.NET 2.0’s FormView control resembles the DetailsView control in that it facilitates the display of single records from a backend data source. This article drills down on the control’s syntax and application.
The Helper Table Workbench
(Robyn Page and Phil Factor) Sometimes, when writing TSQL code in functions or procedures, it is tempting to do iterations, or even worse, a cursor, when it isn’t really necessary. Cursors and iterations are both renowned for slowing down Transact SQL Code SQL Server just isn’t designed for it.
Myths, GUID vs Autoincrement
(Brian Aker) I am a fan of using GUIDs as primary keys. They are database independent, object independent and I can either create them in my application or in the database (MySQL since 5.0 has had a UUID() function but since it does not replicate I don’t use it normally… this has been fixed in 5
IBM puts the shizzel into the Data Warehouse
(Vincent McBurney) IBM has been trailing Oracle in the data warehouse market share for years now. To make IBM products more attractive they have just put some shizzel into the DB2 warehouse offerings.