Author: SSWUG Research

Community

Oracle: The Near-by Standby

(Mary Mikell Spence) Oracle standby database (aka DataGuard) has been around for years and has truly matured as a disaster recovery solution. For many of us, setting up a standby has become fairly old hat. Just remember, keep everything on the standby server exactly the same as the primary, and ev

Community

Allocation in Power Query

(Chris Webb) Now that the brave new world of self-service BI is upon us, old-school corporate BI types like me need to sharpen our Excel skills – and anyone learning Excel will, sooner or later, end up on Bill Jelen (aka Mr Excel)’s site. I found his latest podcast on splitting the value of a contra

Community

Assigning Roles to MySQL Users

(Rob Gravelle) Ever since Oracle became the owner of MySQL when it acquired Sun Microsystems in 2010, improvements to the software haven’t been as forthcoming as one might hope. In fact, some critics have gone so far as to contend that Oracle is willfully “trying to make it as difficult as possible