Are Naming Conventions Still Relevant? I recall a discussion Steve introduced a couple years ago about naming conventions. In it we were discussing the value of how things were named that provided enterprise services. The discussion was targeted primarily at SQL Server. There was a lot of feedback with good ideas and good reasons behind them. Others simply used favorite […]
Other News
Pre-Order Now: DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition)
(Susan Visser) This book will publish in May this year, just in time for IDUG Denver, and for the first time, will publish under the IBM Press imprint:
Using Application Editions To Make Upgrades Less Painful
(David Fitzjarrell) Oracle 11g introduced Application Editions, a tool that can be used to make changes to an existing schema, without actually changing the source schema by creating a child edition of the base edition.
Diagnosing MySQL AUTO-INC and Gap Locks
(Aaron Brown) At ideeli, there is an asynchronous process that allows internal users to import SKUs into our MySQL database. As ideeli has grown, more people are doing more of the same thing at the same time and the SKU import process had become a pain point. At its core, it simply inserts records i
No Significant Fragmentation? Look Closer…
(Luciano Moreira) If you are relying on using ‘best-practice’ percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional ‘edge’ conditions on larger tables that will cause severe degradation in
Parsing XML in Android with SAX
(maccyd) Android applications can make use of imported XML data from remote locations over the Web, or from the local file system. The Java language provides a range of utilities for processing XML data, including the SAX and DOM parsers. In this tutorial we will use the SAX parser, which is more ef
RoundedCornersExtender Control in AJAX Using ASP.NET
(Alok Pandey) The RoundedCornersExtender control adds rounded corners to elements. Its properties are given below.
Virtual Indexes: My 2nd Chance in DB2 Has talent 2012
(samkumar) I will share the story of my 2nd chance at DB2 has talent… A better experience and managed the time well… But everyone was at their best in that episode and for a moment I thought have a got a wildcard entry in final round of DB2 has talent…
Railo – Parsing Dirty HTML into Valid XML
(Mark Drew) There are many times that you want to parse the output from a dirty HTML document. What do we mean by “dirty”? Well, we are used to parsing XML files fine, but HTML isn’t like XML, it has open tags with no closers, it accepts both and and generally it is all round messy.
Selecting all SDO_GTYPE values for all tables/sdo_geometry columns in a schema
(Simon Greener) This article demonstrates how to craft a piece of PL/Sql that queries the Oracle metadata to find all objects with sdo_geometry columns and then, for each object/column, queries the data to return all sdo_gtype values.