Featured White Paper(s) An Introduction to Workload Tuning Workload Tuning is just what it sounds like: tuning the performance of all processes that comprise a database workload in one… (read more) Featured Script dba3_fn_TableIdentityColumns_WithIdentCurrent_Article UDF, returns identity column names With Ident Current values for a designated table in the same database. Requires a paramete… (read more) Authentication vs. Authorization Authentication […]
Other News
SQL Alerts
Featured Article(s) Tips for using alerts in SQL Server 2008 In this article, you can find some useful tips to work with SQL Server 2008 alerts. Featured White Paper(s) Why and How You Should Find and Fix Index Fragmentation In a high-volume database you need frequent critical maintenance. If you skip this important task, index fragmentation may ca… (read more) […]
Client Templating with jQuery
(Brij Mishra) jQuery templating is becoming a new buzzword for the new Web applications. One cannot avoid jQuery in web applications. Currently most of the applications are using jQuery heavily. It provides very good look & feel and better performance.
Printing To The Primary Output Stream From Within A ColdFusion CFThread Tag
(Ben Nadel) A lot of the time, when we use ColdFusion’s CFThread tag, we use it in a “set it and forget it” style approach; that is, we spawn a parallel thread and don’t wait for it to come back. Other times, however, we do wait for the parallel threads to finish processing so that we can examine th
ASP.NET MVC 3 Validation and IValidatableObject
(David Hayden) I was working with ASP.NET MVC 3 validation today and was tickled to learn of the support for IValidatableObject. I mainly like to use the Enterprise Library Validation Application Block in my projects, but System.ComponentModel.DataAnnotations has come a long way in .NET Framework 4.
Getting data from the Semantic Web (Ruby)
This tutorial is for programmers used to building software on top of non-Semantic-Web data sources: using screen scraping techniques, or using APIs that return XML, JSON, CSV etc.
Applying XSLT template rules to strings / matching strings
(Andrei Lunjov) I extremely like template rules in XSLT (I miss them much in XQuery). But it’s impossible to match on simple types, only on nodes.
An obscure performance problem with the insert buffer
(Mark Callaghan) MySQL development is on a roll so now is the time for me to request a fix for another obscure performance problem in InnoDB. The insert buffer is a feature that can make InnoDB much faster than you expect.
DB2 init.d script for Ubuntu enhanced
(Radim Kolar) I improved startup init.d script from DB2 Express C for Ubuntu. This script can be used with other DB2 editions and distributions as well with little (if any) modifications.
DB2 for z/OS: KEYCARD Gets its Due
(Robert Catterall) By now, you’ve probably seen and/or heard a good deal of information about DB2 10 for z/OS, which was announced and became generally available this past October. There is indeed a lot of big news associated with this latest release of IBM’s mainframe relational database management