(Henrik Loeser) Today I wanted to test some options around encrypting DB2 backups and restoring encrypted database backups. I can report that the security features work, only my stupidity (or call it “vacation readiness”) caused some delays.
Author: SSWUG Research
Will the R language benefit from Microsoft acquisition?
(Robert Sheldon) Microsoft’s recent acquisition of Revolution Analytics represents a significant move on the company’s part. Revolution Analytics is built around the highly popular R language, an open source programming language designed specifically for statistical analytics.
Time Slots – An Essential Extension to Calendar Tables
(Dwain Camps) After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that devel
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
(Natik Ameen) What? I am trying to restore the controlfile but and getting the RMAN-06563 error. I know I have a backup on the controlfile but RMAN is not able to see it.
XML Database and XQuery to the Rescue
(John C Rayan) Regardless of the platform and languages, processing a very large XML (for example, a size > 8G) is a daunting task. Traditionally XML is loaded into memory and using DOM the XML is processed.
MySQL Performance Schema : setup_actors ENABLED column
(Mayank Prasad) performance_schema.setup_actors is a table in MySQL Performance schema which could be used to specify what users/hosts one wants to have instrumentation on for. By default connection from all users and hosts are enabled to be instrumented for.
Recursion in Oracle 12
(Andrew Reid) Oracle 12 has a new parameter called PGA_AGGREGATE_LIMIT:
Oracle SOA Suite 12c – Create, Deploy, Attach and Configure a Custom OWSM Policy – to report on service execution
(Lucas Jellema) This article describes how to develop a straightforward custom assertion that can be used as part of custom OWSM policy to be attached to Web Services in WebLogic, such as services exposed by SOA Composite applications and Service Bus projects as well as custom JAX-WS or ADF BC Web S
SSWUGtv: Laura Rose is on the show today, giving tips on how increase customer satisfaction survey results
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
SQL Server Index Report with Included Columns, Storage and more for all Tables in a Database
(Percy Reyes) I am sure sometimes as SQL Server DBAs and Developers we would like to report on more detailed information about indexes on a table. One of the primary means to find the information is sp_helpindex which is a system stored procedure to check index summary information.