(Aravinth C) A few days back we were given a MySQL database hosted in EC2 with around 5TB data to move some of the tables to a new server. The intention was to share the tables between 2 EC2 instances. Since AWS had the option to take online snapshots, the plan was to take a snapshot, create a new
Other News
Drawing Foreign Keys & Relationships in SQL Developer Data Modeler
(Jeff Smith) It’s all in the wrist, literally.
Why Automate Target Patching with Enterprise Manager 12c
(Kellyn Pot’Vin) Every job comes with tasks that no one likes to perform and database administration is no exception. Patching is one of those necessary tasks that must be performed and when we are expected to do more with less everyday, the demands of patching another host, another agent, another
Time Is On My Side, Maybe
(David Fitzjarrell) A recent MOS document discusses, albeit briefly, an issue with AWR reports that’s been going on since 10.2.0, namely that the elapsed time numbers for queries executed in parallel are considerably greater than the actual elapsed clock time. Let’s look at why that is and what can
IBM Datacap 9.0 DDK: Customizing ruleset configuration panels for FastDoc and Datacap Studio
(Robert Ferin) IBM Datacap 9.0 provides ruleset configuration panels, which are used at application design time in FastDoc and Datacap Studio, allowing easy ruleset configuration by providing a UI that prompts the user for configuration settings and then creates the appropriate ruleset XML. Addition
Introduction to MVC in Javascript
(Nitesh01) In order to understand MVC in Javascript, I will first explain briefly about MVC. What is the purpose of each component in MVC? How this pattern is becoming popular and How you can implement it using Javascript? At the end of this article, I will be sharing one dummy example (task checker
When more is not always a good thing
(Willie Favero) Sometimes receiving an extra cup of coffee, a second handful of M&M’s, a few more minutes of sleep, or a little extra time to get to your destination is a good thing.
DB2 Resource Limit Facility
(Troy L Coleman) With early DB2 releases, many customers would restrict dynamic SQL on a production online transaction processing system (OLTP). DBAs had no way to lock in the access path to avoid unexpected performance problems that could occur due to ad hoc queries impacting business critical appl
JavaScript ascends as Objective-C falls in language popularity
(Paul Krill) JavaScript has ascended to its highest position ever in the monthly Tiobe Index of language popularity, while Objective-C is on a downward slope.
ASP.NET 5 and AngularJS Part 1, Configuring Grunt, Uglify, and AngularJS
(Stephen Walther) This is the first part in a multiple part blog series on building ASP.NET 5 (ASP.NET vNext) apps with AngularJS. In this series of blog posts, I show how you can create a simple Movie app using ASP.NET 5, MVC 6, and AngularJS.