(James Serra) A “data lake” is a storage repository, usually in Hadoop, that holds a vast amount of raw data in its native format until it is needed. It’s a great place for investigating, exploring, experimenting, and refining data, in addition to archiving data. Some characteristics of a data lak
Author: SSWUG Research
Improving performance – A full stack problem
(Ronald Bradford) Improving the performance of a web system involves knowledge of how the entire technology stack operates and interacts. There are many simple and common tips that can provide immediate improvements for a website. Some examples include:
Auditing Read-Only Standbys
(Neil Chandler) If your company has a passing interest in database security, you are probably running some sort of session auditing at the very least [audit session] (although this can also be useful for troubleshooting connectivity issues).
A Simple Example With V$BACKUP
(Andrew Reid) I tested this in an Oracle 12.1 database. The V$BACKUP view tells you if a datafile is in hot backup mode. I started off with none of the datafiles in hot backup mode so they were all shown as NOT ACTIVE:
Discovering if a System level Parameter has changed its value (and when it happened)
(Carlos Sierra) Quite often I learn of a system where “nobody changed anything” and suddenly the system is experiencing some strange behavior. Then after diligent investigation it turns out someone changed a little parameter at the System level, but somehow disregarded mentioning it since he/she tho
Read/Edit datetime Field on a XML File
(Bhis) I had a simple requirement yesterday to read an XML file, change a date field and save. This was a very simple task, but I had to refresh my XML basics and figure out how to change its contents which still took me an hour. There seem to be hundreds of web posts on XML reader issues, resolutio
Configuring InfoSphere Data Replication CDC on Microsoft cluster services with failover capability
(Amit Kumar) InfoSphere Data Replication (IIDR) CDC supports data replication from databases running on Windows Cluster services. Follow the step-by-step process that outlines all the required tasks to configure IIDR CDC on MSCS with failover capability.
ASP.NET WEB API: Consuming Binary Contents (Images)
(Mahesh Sabnis) HTTP is simple and ubiquitous in nature and almost any platform has a HTTP Library. ASP.NET Web API is a web framework built on top of the .NET framework and can be used to build or consume HTTP services.
Solving RMAN-06059: Errror identifying file
(Natik Ameen) What? When using RMAN to backup archivelog files, an error “RMAN-06059: Errror identifying file ” is returned. Prior to this the backups have been running successfully.
Catching Performance Issues in Development
(Chris Hurley) Recently, it came time to refactor and improve the code that manages our online product licensing at Redgate. This code handles requests to activate products, when users enter their serial number, as well as various other licensing tasks, such as deactivating a license on one machine