(Willie Favero) Although I am part of the cast of thousands that keep the DB2-L list behaving as correctly as we can make it behave, I don’t always have time to answer as many DB2 questions on the list as I would like to. It looks like when I do have the time to answer the occasional question, it ap
Other News
DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
(Paolo Bruni, Sabine Kaschta, Marcel Kutsch, Glenn McGeoch, Marichu Scanlon and Jan Vandensande) This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code
Implementing Interfaces
(Jim Mischel) As you saw back at the beginning of this series, the native integer types implement a large number of .NET interfaces. Those interface implementations aren’t required in order to do “normal” integer operations, but they do allow the types to interact with the rest of the .NET runtime i
MySQL Information Schema Plugins: the best kept secret of MySQL 5.1
(Roland Bouman) MySQL 5.1 offers an extremely useful feature called information_schema plugins. This feature allows dynamic runtime loading of a shared library into the MySQL server to implement a table in the information_schema database. The SQL standard (ISO/IEC 9075-11:2003) allows database imple
Oracle provides SQL and PL/SQL features so that we can do a lot more with fewer lines of code
(H.Tonguç Yýlmaz) Recently I started a discussion on oraclecommunity.net database forum with subject “Why Oracle?”. Hans Forbrich and Billy Verreynne gave important feedbacks. As a group we are preparing a free half day seminar to the computer science students in Istanbul.
Displaying and reading the execution plans for a SQL statement
Generating and displaying the execution plan of a SQL statement is a common task when trying to understand a change in the performance characteristics of the SQL statement.
Schema Comparison with Visual Studio Team Edition for Database Professionals
(Dinesh Priyankara) Most DBAs work with different environments such as production, quality assurance and development where the same database schema exists. One of the biggest issues we have been facing while maintaining the same database schema in various environments is making sure that the objects
Microsoft SQL Server 2008 – Change Data Capture – Part 2
(Muthusamy Anantha Kumar) One of the new feature in Microsoft SQL Server 2008 is track the changes on a table. You can enable change tracking on a table using Change Data Capture feature.
SQL Server 2008: Enabling FILESTREAM through T-SQL and SSMS
(Paul S. Randal) The second post in my series on FILESTREAM (see here) deals with how to enable FILESTREAM through T-SQL and using SSMS.
Find blocking processes using recursion in SQL Server 2005
(Tim Chapman) Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This causes the second process to wait until the first process is done so it can acquire the records; this can cause