(Blaise Doughan) Today I answered a question on Stack Overflow (feel free to up vote) about JAXB and generating Java enums from an XML Schema.
Other News
How to compare dates selected in a Date Time Picker control
(Ged Mead) VB has several options that let you compare dates to check which is earlier than the other, or even if they are the same.
Does GATHER_TABLE_STATS update Index Statistics?
(Hemant K Chitale) In 9i, the GATHER_TABLE_STATS procedure would default CASCADE to FALSE.
DB2 HADR and HADR_PEER_WINDOW settings
(Jack Vamvas) Setting HADR_PEER_WINDOW at zero , only blocks primary transactions for the time specified in HADR_TIMEOUT.
SQL Server – Split Database Full Backup to Multiple files
(Paresh Prajapati) As a maintenance activity DBA need to take care of the database backups and monitoring for the same because database backups are more important in recovery.Production live databases have more sizes and because of heavily size of the databases it is require more time and IO to main
SQL Server: Limit Millisecond Part in DateTime2 Datatype
(Madhivanan) Till version 2005, SQL Server supported only the datetime datatype which stored date and time with milliseconds upto three digits. However SQL Server 2008 supports separate data types DATE and TIME as well DATETIME2 datatype which stores milliseconds upto 7 digits.
Introduction to Big Data Solutions
(Conor O’Mahony) Here’s a short video that was recorded at the IDUG conference, where I talk about the characteristics of Big Data solutions, discuss some of the technologies involved, and describe some real world Big Data solutions that IBM has implemented. Its a high-level introduction, but if you
Modeling trains with SPSS
(Marc Fiammante and Gregory Neuveglise) The ability to predict a failure before it happens is tremendously valuable. Learn how an IBM team worked with a train manuacturer to develop this capability using IBM SPSS Modeler and IBM DB2.
Dynamic Management Views
Introduction to SQL Server Reporting Services – Tomorrow, August 25 Last chance to sign up for the next virtual class, "Introduction to SQL Server Reporting Services". This "Made Simple" course, taught by Sherri McDonald, a Business intelligence expert from Pragmatic Works, is a great investment for your personal development. If you’re ready to up your game, come on in and […]
Re-implementing udf_init_error in MySQL 5.5 and up
(Roland Bouman) Today, I received an email from a user of the udf_init_error UDF (which resides in the lib_mysqludf_udf library). The purpose of this UDF is to generate an error condition, which can be used to abruptly terminate a trigger or stored procedure.