(Leons Petrazickis) My team at IBM recently released DB2 Express-C 9.7.4, the latest and greatest version of our free database.
Other News
Innodb Caching (part 2)
(Peter Zaitsev) Few weeks ago I wrote about Innodb Caching with main idea you might need more cache when you think you are because Innodb caches data in pages, not rows, and so the whole page needs to be in memory even if you need only one row from it.
How to Eliminate Wait Events in Oracle Database?
(Charles Hooper) In the last couple of days I have been busy with a couple of non-Oracle Database specific tasks, and I started wondering what types of wait events I might be posting during this time period if I had to report what I was doing.
How do I get an application to use the same execution plan I get in SQL*Plus?
(Maria Colgan) Let me provide a little background to this question before answering it.
What is the Difference Between XLink and XPointer
(Darla Ferrara) There is one distinctive difference between the two XML languages, XLink and XPointer. Both provide a standard syntax for defining links within XML code.
Oracle Date Functions in PL/SQL
In this tutorial you will learn how to use Oracle date Functions using PL/SQL, including: to_date, to_char, sysdate, round, trunc, add_months, months_between, and last_day.
With the DB2 Storage Engine for MySQL, It’s YourSQL
(Erwin Earley) Those readers who have dabbled in open-source technologies may already be aware of the availability of the MySQL open-source database server on IBM i. In this article, I’ll explore why MySQL is available on i, how you can take advantage of it, and how you can use MySQL’s abstraction t
How to configure an instance of SQL Server to listen on a specific TCP port or dynamic port
This article describes static and dynamic port allocation in Microsoft SQL Server 2000,in Microsoft SQL Server 2005 and in SQL Server 2008. It also discusses how to configure an instance of SQL Server to use either a static port or a dynamic port.
Enhanced Textbox Control
(Pranay Rana) In application development, there is always the need for validating input controls. To validate input controls, ASP.NET has a set of validation controls. To apply validation on input controls, you require to attach a validation control with the input control.
Looking at how the ASP.NET MVC Authorize interacts with ASP.NET Forms Authorization
(Jon Galloway) ASP.NET MVC includes an [Authorize] attribute, which when placed on any controller actions will forbid unauthorized access. The AuthorizeAttribute allows you to specify a list of roles or users, like this: