(Torsten Kleiber) Do you know, that PMD can analyse XML files since version 5? Many of ADF files are XML configuration files – wouldn’t it be a good idea to create some static code analysis rules for ADF too?
Author: SSWUG Research
XML Parser Function in PHP: Part 4
(Sharad Gupta) In this article I describe the PHP XML Parser functions xml_set_default_handler, xml_set_element_handler, xml_set_external_entity_ref_handler, xml_set_notation_decl_handler and xml_set_object.
Using ngOptions In AngularJS
(K. Scott Allen) The ngOptions directive in AngularJS allows you to build and bind an HTML select element with options to a model property. It’s quite a versatile directive and is smarter than trying to build the select options with ngRepeat since ngOptions is optimized for two way data binding.
Using OUTPUT to back up a change
(Kenneth Fisher) How will you back out if your change doesn’t work?! Always take a backup! There should always be a back out script to go with any change script! These are things that have been drilled into me time and time again.
Move DB2 schema objects to another schema using ADMIN_COPY_SCHEMA
(Jack Vamvas) Question: How can I move DB2 objects from one schema to another schema in the same database? When I migrated a database to a new DB2 instance with new logon , I couldn’t access the tables.
Oracle Database 12c: In Line PL/SQL Functions in SQL queries
(Lucas Jellema) At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences with this major milestone in the history of Oracle’s flagship product.
A new big data structure for streaming counters – bit length encoding
(Justin Swanhart) One of the challenges of big data is that it is, well, big. Computers are optimized for math on 64 bits or less. Any bigger, and extra steps have to be taken to work with the data which is very expensive. This is why a BIGINT is 64 bits. In MySQL DECIMAL can store more than 64 bit
Disaster Recovery Planning for Microsoft SQL Server – Getting Backups and Restores Right
(K. Brian Kelley) I’m responsible for ensuring that my SQL Servers can be recovered properly in the event of a disaster. I’ve heard a lot of the acronyms, but how do I apply this to practical steps with respect to my environment? What else do I need to know other than the magic acronyms?
Building and Consuming Async WCF Services in .NET Framework 4.5
(V.N.S Arun) In .NET Framework 4.5 the async and await keywords are pretty good additions. In this article I am going to explain on how simple is to build and consume WCF services using async and await keywords in .NET Framework 4.5. I will also provide the code examples of how the asynchrony was do
Displaying and fixing compilation errors on a SQLTXPLAIN package
(Carlos Sierra) If you are installing SQLTXPLAIN and for some reason you get a PL/SQL compilation error in a SQLT log like the one below, chances are the SHOW ERRORS command on SQL*Plus won’t show the actual error.