An Incremental Servicing Model (ISM) is available from the Microsoft SQL Server team to deliver hotfixes for reported problems. The objective for the ISM is to deliver high quality fixes in an acceptable time and on a predictable schedule.
Author: SSWUG Research
Ubuntu Linux forges tighter DB2 ties
IBM’s DB2 has long been a Linux-friendly, cross-platform database. But as of this week, there will be improved coexistence between DB2 and the latest Ubuntu 6.06 Linux release.
Tuning Methodology for Demystifying the DB2 z/OS Optimizer
(Gene Fuh and Terry Purcell) In prior releases of DB2, the optimizer’s cost estimates were hidden from view in the mysterious “hidden plan tables.” But even if you could get your hands on them, it was generally difficult to determine what to do with the information these tables contained.
Develop with Choice
(Alan Joch) J2EE or .NET. Mashups or portals. PL/SQL or PHP. Developers don’t lack for choices when they need to build applications. There also aren’t any shortages of architectures, frameworks, and platforms.
MySQL: ibdata files do not shrink on database deletion [innodb]
(CrazyToon) One very interesting thing I noticed with MySQL was that if you delete a database, ibdata file doesn’t shrink by that much space to minimize disk usage. I deleted the database and checked usage of /usr/local/mysql/var folder and noticed that ibdata file is still the same size. So the pro
Returning a Random set of Records
(Parthasarathy Mandayam) The NEWID() function returns a uniqueidentifier for each row of data that is returned.
MERGE and TRUNCATE [DB2 9 for z/OS]
(Craig Mullins) Two additional new SQL statements available in DB2 Version 9 are the MERGE and TRUNCATE statements.
Say hello to XPath 2.0
(Ed Tittel) Amidst the many new recommendations approved by the W3C on January 23, 2007, you’ll find a brand spanking new version of XPath—namely, 2.0—to ponder. Formally entitled TR/xpath20/XML Path Language (XPath) 2.0, this document caps off what some might call the “Holy Trinity” of XML, all of
Oracle/PLSQL: Grant/Revoke Privileges
You can grant users various privileges to tables. These privileges can be any combination of select, insert, update, delete, references, alter, and index. Below is an explanation of what each privilege means.
SQL Server CLR Integration Part 1: Security
(Mark J. Miller) This is the first in what I plan to be a series of articles examining the Common Language Runtime (CLR) hosted by SQL Server 2005. This installment looks at the security model of the CLR. Following articles will address performance and stability of the CLR as a whole, performance of