(Rob Garrison) The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to
Other News
Many-to-Many Relationship Implementation in ADF BC and ADF Faces UI
(Andrejus Baranovskis) Is not always obvious how to implement Many-to-Many use case. I will describe how to represent Many-to-Many data structure in ADF BC and how to display it effectively with ADF Faces. With my next post I will provide another sample application to describe how to create and dele
ST_RemovePoint for Oracle SDO_Geometry based on Jaspa/JTS
(Simon Greener) A missing function from the Ogc/SqlMM Apis is a function that allows a user, via Sql, to modify a geometry by removing one or more points. Here is just such a function for Sdo_Geometry users.
Centered fixed width design in SharePoint 2010 – The fast way
(Stefan Bauer) There are a lot of fixed width master page solutions available on the internet and I’ve read most of them. Some require JavaScript or don’t respect the ribbon, which means that the ribbon will be placed inside the fixed width design.
Verifying backup integrity with CHECK TABLES
(Baron Schwartz) An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB’s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt, InnoDB will crash the server to
Fix Removes Implicit DBADM Privileges
(Troy Coleman) Given the concerns over security compliance, IBM has steadily removed implicit authorities over the past few years. This direction of course extends to implicit authorities given to DBAs.
How to get the Menus Based on Role in XML Format and Bind them to the Menu Control in ASP.NET
(abhijit.dalvi29) Following are the steps of how to get the Menus based on Role in XML format and bind them to the Menu control in ASP.NET :
APAR Friday: A few HIPERs to help bring January 2012 to a close
(Willie Favero) In an effort to bring you meaningful and current information that hopefully can you both time and aggravation, and in an effort to differentiate my blogs from the others on the Internet (remember when there was just one DB2 for z/OS blog running around… LOL), here are a couple of r
Optimize InfoSphere DataStage jobs with Netezza Connector using InfoSphere DataStage Balanced Optimization
(Ritika Maheshwari) In this article, learn how to use a DatgaStage extension called IBM InfoSphere DataStage Balanced Optimization to rewrite a DataStage job to enhance performance by sharing or redistributing the processing load among InfoSphere DataStage and the source and target databases.
Exploiting the HTML5 Canvas with jqChart
(Peter Vogel) One of the earliest HTML5 tools to be widely implemented in browsers is the canvas, which provides both a platform-independent way to develop complex graphics and a standard JavaScript API for creating them. jqChart, a jQuery plug-in, takes advantage of canvas to deliver client-side ch