(Roland Bouman) There is a popular myth about the SQL GROUP BY clause. The myth holds that ‘standard SQL’ requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of vi
Other News
Training Wheels: Using DB2 (and my DataStage Configuration Error)
(Beth) As an IBM employee it’s embarrassing to admit I’ve never administered a DB2 database before. I did test one briefly last fall, attempting to load large XML SAP iDocs into DB2 or Oracle (turned out the xml was too large for either engine).
Rolling Your Own Website Administration Tool – Part 1
(Dan Clem) Forms-based authentication combined with ASP.NET 2.0’s Membership and Roles systems makes creating and managing user accounts incredibly easy. I continue to be amazed at how the login-related Web controls encapsulate the array of tasks that I had always had to code by hand in classic ASP.
Block Change Tracking Internals: X$ Tables Research — X$KRC ‘Snappack’
(Alex Gorbachev) With this post, I’m starting a series about Oracle Block Change Tracking internals. The feature was introduced in Oracle 10 Release 1. I have already published my past presentations and the white paper about that, so what pushed me to get back to this topic again?
Introduction to LINQ, Part 2: LINQ to XML
(Marius Bancila) In the first article of the series, I introduced the LINQ to Objects API, showing how the language integrated queries can be used for querying sequences with C#. In this second article, I will introduce LINQ to XML, formerly code-named XLinq.
Sorting and case sensitive collations
(Louis Davidson) One of the more confusing parts of collation is how they affect the ordering of data when sorted and how that can affect other operations like the LIKE operator. When it comes to case insensitive collations, it is pretty clear, data is sorted as if ‘A’ and ‘a’, are the same charact
MySQL System Architecture
(Mike Kruckenberg and Jay Pipes) In this article, we’re going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL’s implementation is a fascinating mix of technology that is truly a remarka
SOA management and composite apps key for IBM Tivoli
(Rich Seeley) At IBM’s Impact 2007 conference this week, Al Zollar, general manager of IBM Tivoli, stressed the need to automate management to make sure Web services work in an SOA environment. (R)
CodeSnip: How to Group Data in the GridView Control
(Sushila Bowalekar Patel) It is a very common requirement to Group the data based on particular column or cell data.
Choose the Right Web Services Security Solution
(Hyder Alkasimi) Web services are designed to expose business functionality in an interoperable and loosely coupled manner. While they have the potential to reap the benefits of an SOA infrastructure, they also introduce the risk of unauthorized access to your business assets. Therefore, it is impor