(Dathan Pattishall) I’m really excited about Fabric which was recently announced. Everything it does has been a variety of scripts for me or manual tasks, but before I can integrate Fabric into my system I must know more about it.
Other News
DB2 Basics: Storage Groups
(Ember Crooks) A storage group is a layer of abstraction between the data in your database and disk. It is only used with Automatic Storage Tablespaces (AST). It allows us to group tablespaces together to live in similar places. Storage groups were first introduced in a roundabout way with automatic
Back to Buffer Pool Basics Octology
(Willie Favero) I’m not sure if Octology is word or not… I can’t find it on Dictionary.com although it does show up in Wiktionary.org. I’m using it anyway to describe my Back to Buffer Pool Basics Series of 8 posts. From this post, you can get to any of the posts in the series. Hopefully I’v
The APEX_JSON package: Generating JSON from PL/SQL
(Morten Braten) In my previous blog post, I took a look at the new APEX_JSON package that ships with Apex 5.0 and its capabilities for parsing JSON.
Row cache lock
(Nikolay Savvinov) A rather odd performance issue happened at work a few days ago. All of a sudden, one of the databases started to work very slowly, and a quick look in ASH data showed that it was spending over 70% of its time waiting on “row cache lock” (not to be confused with “latch: row cache l
ASM Startup Fails With ORA-04031 After Adding CPUs
(Don Seiler) A few weeks ago we upgraded one of our production server, adding another CPU tray. This brought the number of CPU cores from 80 to 160, and took us from 2Tb of RAM to 4Tb (just in time for Oracle to announce the in-memory database in 12.1.0.2!).
Build a simple web app for student math drills using the Bluemix SQLDB service
(Rodrigo Ferreira, Marcos Rogério De Mello and Jullyana Fialho Pinheiro) In a few steps, create a simple web application for students to practice basic math skills, primarily multiplication operations.
jQuery Templates
(Kamal Rawat) In this article, we will try to answer the three questions, What, Why and How, about jQuery templates.
The clustered index columns are in all of the non clustered indexes.
(Kenneth Fisher) Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look!
Get Ready to Learn SQL: 13. Introduction to Inner Joins
(Kris Wenzel) The series starts with the article Introduction to Database Joins. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server. In