(Sreeharsha Naik) This article introduces a high data availability solution on IBM DB2 for z/OS using DB2 BINDs for shops having their test, development and production environments on a single LPAR. Using this method, it is possible to map the test program onto production qualifiers and retrieve dat
Author: SSWUG Research
Using Oracle Enterprise Manager Command Line Interface Part 1 – Installing and Basic Configuration
(Karen Reliford) Oracle Enterprise Manager 12c brings a wealth of configuration, monitoring and maintenance tools to DBAs. The primary emphasis of OEM 12c is the web-based graphical interface. However OEM also has a command line interface, which can be used to perform many of the activities that the
Practical RPG: BLOBs, CLOBs, and XML Part 2
(Joe Pluta) In the first article in this series, I identified situations where it is preferable to store stream data in a database rather than in the IFS. Specifically in my case, I had literally millions of stream files proliferating in the IFS and causing some real processing issues. My alternativ
Replication : Be careful while executing DCL with replicate-ignore-db=mysql
(Ramesh Sivaraman) Normally in mysql replication Data Control Language (DCL) statements won’t replicate into slave if we are configuring replication with replicate-ignore-db=mysql.
Oracle Enterprise Manager 12c Configuration Best Practices (Part 1 of 3)
(Bethany Lapaglia) The objective of this three-part blog series is to summarize the most commonly implemented configuration changes to improve performance and operation of a large Enterprise Manager 12c environment. A “large” environment is categorized by the number of agents, targets and users.
Primary Keys Guarantee Uniqueness? Think Again.
(Arup Nanda) When you create a table with a primary key or a unique constraint, Oracle automatically creates a unique index, to ensure that the column does not contain a duplicate value on that column; or so you have been told.
Working With Inherited Collections In AngularJS
(Ben Nadel) In an AngularJS application, $scope instances are all part of a prototypal chain. That is, every $scope instance (except $rootScope, I believe) has, as its prototype, the $parent scope. This is a brilliant way to architect the view-model because it means that data loaded in one controlle
What’s the use of code reuse?
(Tony Davis) All great developers write reusable code, don’t they? Well, maybe, but as with all statements regarding what “great” developers do or don’t do, it’s probably an over-simplification.
What is Eager Loading and what is Lazy Loading and what is N+1 Problem in Entity Framework
(Abhimanyu Kumar Vatsa) In this post you will learn what Eager Loading is and what Lazy Loading is and how this works in the application, and how you can take its advantages.
SQL Server 2014 all about big data, in-memory analytics and cloud
(Mark Fontecchio) In this edition of SQL in Five, Mark Kromer, national platform architect at Microsoft, dishes on his favorite features of the upcoming SQL Server 2014 and discusses how database administrators should start thinking about their upgrade path.