Create a Local Ubuntu Repository using Apt-Mirror and Apt-Cacher
How can a company or organization minimize bandwidth costs when maintaining multiple Ubuntu installations? With bandwidth becoming the currency of the new millennium, being responsible with the bandwidth you have can be a real concern. In this article by Christer Edwards, we will learn how to create, maintain and make available a local Ubuntu repository mirror, allowing you to save bandwidth and improve network efficiency with each machine you add to your network.
Read Create a Local Ubuntu Repository using Apt-Mirror and Apt-Cacher in fullMySQL Linked Server on SQL Server 2008
Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets on disparate databases.
This article by Dr. Jay Krishnaswamy explains how to set up a MySQL linked server on SQL Server 2008 Enterprise. Configuring a linked MySQL server as well as querying a table on the MySQL linked server is described. The reader would benefit reviewing the first article on this series on MySQL Servers.
Read MySQL Linked Server on SQL Server 2008 in fullUsing Graphs to Manage Networks and Devices with Cacti 0.8
In this article by Dinangkur Kundu and S. M. Ibrahim Lavlu, we will see how to add network-attached devices in the Cacti system and produce graphs to monitor LAN-sized installations to complex networks with hundreds of devices. It is fairly easy to manage devices through the Cacti web front-end. It provides a fast poller, advance graph templating, and multiple data acquisition methods out of the box, wrapped in an easy to use interface that makes sense to the network administrator.
Read Using Graphs to Manage Networks and Devices with Cacti 0.8 in fullBuilding a Facebook Application: Part 2
In the previous part of this article by Dr. Mark Alexander Bain and Hasin Hayder, we covered developing a simple Facebook application and the way to write the Facebook profile. In this part, we will cover Mock AJAX and data storage.
Read Building a Facebook Application: Part 2 in fullBuilding a Facebook Application: Part 1
You'll obviously want to start building applications, and that's just what we'll do in this two-part article. By the end of this two-part article by Dr. Mark Alexander Bain and Hasin Hayder, you'll be able to:
- Extract Facebook information to be displayed by your application.
- Store information in the Facebook cache, so that it can be displayed on your users' profile pages.
- Store your own custom data.
The first part will cover the concepts of developing a simple Facebook application and also the way to write the Facebook profile.
Read Building a Facebook Application: Part 1 in fullTroubleshooting and Gotchas in Oracle VM Manager 2.1.2
The journey with Oracle VM Manager is not free of troubles and errors. In this article, Tarry Singh will attempt to address the ones that are bound to bother you the most as far as Oracle VM Manager is concerned.
What will we cover in troubleshooting?
While we tackle the following issues in troubleshooting VM Manager. We are assuming that you are using the latest version of Oracle VM Manager and the Oracle VM Server version is 2.1.x:
- Oracle VM Manager login takes too much time
- VM guest creation fails
- Not enough disk space available for ISOs and Templates
- Cannot login to the VM remotely
Read Troubleshooting and Gotchas in Oracle VM Manager 2.1.2 in full
Storing Planning Data in IBM Cognos: D-Cube (Part 1)
In this two-part article by Ned Riaz, Jason Edwards, and Rich Babaran, we will discuss how data is stored in IBM Cognos Planning Analyst. We will begin by defining the D-Cube and explaining the things that you need to think about before creating the D-Cube. We will discuss the importance of the order of dimensions in enforcing calculation and format priorities. We will show you how you can view the multiple slices of the cube and how you can save a selection of the cube as a separate object. We will explain how you can restructure the dimensions of the cube by adding, deleting, substituting, and reordering dimensions. We will cover some of the important functions available with the D-Cube, including global formatting, exporting, and other options that can make it easier for you to work with the program. We will illustrate how you can use data entry commands that will enable you to enter data, execute mathematical operations, or set restrictions for a cell, a range of cells, or the entire cube. Finally, we will cover Breakback—a powerful feature that allows you to cascade changes throughout the cube simply by making the change to a calculated item.
Read Storing Planning Data in IBM Cognos: D-Cube (Part 1) in fullExtending Oracle VM Management
In this article by Tarry Singh, we will learn more about Oracle VM Management.
The following topics will be covered in this article:
- Managing Oracle VM Server repository
- Backing up or Restoring Oracle VM Manager
- Enabling security
Read Extending Oracle VM Management in full
Adding Interactive Course Material in Moodle 1.9: Part 3
Read Part One of Adding Interactive Course Material in Moodle 1.9 here.
Read Part Two of Adding Interactive Course Material in Moodle 1.9 here.
Read Adding Interactive Course Material in Moodle 1.9: Part 3 in fullAdding Interactive Course Material in Moodle 1.9: Part 2
Read Part One of Adding Interactive Course Material in Moodle 1.9 here.
Read Adding Interactive Course Material in Moodle 1.9: Part 2 in fullDebugging the Scheduler in Oracle 11g Databases
In this article by Ronald Rood, we consider the fact that when the jobs get more complicated, it gets harder to understand why something works differently than planned. This article gives the reader a fresh look at how to follow and debug Scheduler jobs in Oracle 11g.
Read Debugging the Scheduler in Oracle 11g Databases in fullAdding Interactive Course Material in Moodle 1.9: Part 1
In this three-part article series by William Rice, we will learn how to add Interactive course material in Moodle. Interactive course activities enable students to interact with the instructor, the learning system, or each other. Note that Moodle doesn't categorize activities into 'Interactive' and 'Static'. In Moodle, all activities are added from the Add an activity... menu after turning the editing on. We use the terms 'Interactive' and 'Static' as a convenient way to categorize the activities that Moodle offers.
Read Adding Interactive Course Material in Moodle 1.9: Part 1 in fullQuery Performance Tuning in Microsoft Analysis Services: Part 1
In this two-part article by Chris Webb, we will cover query performance tuning, including how to design aggregations and partitions and how to write efficient MDX. The first part will cover performance-specific design features, along with the concepts of partitions and aggregations.
One of the main reasons for building Analysis Services cubes as part of a BI solution is because it should mean you get better query performance than if you were querying your relational database directly. While it's certainly the case that Analysis Services is very fast it would be naive to think that all of our queries, however complex, will return in seconds without any tuning being necessary. This article will describe the steps you'll need to go through in order to ensure your cube is as responsive as possible.
Read Query Performance Tuning in Microsoft Analysis Services: Part 1 in fullQuery Performance Tuning in Microsoft Analysis Services: Part 2
In the previous part of the article by Chris Webb, we covered performance-specific design features such as partitions and aggregations. In this part, we will cover MDX calculation performance and caching. We'll see how important caching is to overall query performance.
Read Query Performance Tuning in Microsoft Analysis Services: Part 2 in fullGetting Your APEX Components Logic Right
In this article by Douwe Pieter Van Den Bos, we will get ready for our Forms conversion and generation. In this part of our conversion project, we will investigate, analyze, and adjust some of the most important parts of our application. This means that we will set everything up for the generation of the application. We will discuss the following parts of the conversion project in this article:
- Investigating the components that will be generated
- Getting to know the database blocks in our Forms files
- Looking deeper into the block items inside our blocks and editing them
- Enhancing the queries on which our blocks are based
- Analyzing the triggers we have in the Forms XML files
- Massively changing the completeness and applicability of triggers or items
- Customizing the query that the blocks are based on in order to complete our generation
- Understanding the way our pages will be generated in APEX
- Editing the titles of our blocks and items
- Analyzing our business logic (probably the most important part)


