Web enabling business data is one of the key devices used to advertise and market products. This can be done with various technologies such as VB, ASP, JSP, ASP.Net and many others. This article shows how you may view data from a table on a MySQL database server on a web page using ASP.NET. The table used in this tutorial was the one described in the first article in this series on Exporting data from MS Access 2003 to MySQL.
This article by Dr. Jay Krishnaswamy explains how to populate a GridView on an ASP.NET web page by data retrieved from a MySQL Server. MySQL.Data.MySqlClient is a connector (provider) provided by MySQL which you can use with the .NET Framework applications whose details may be reviewed here. MySQL is well integrated with Visual Studio (MySQL Visual Studio Tools: MySQL.VisualStudio.dll).Read Displaying MySQL data on an ASP.NET Web Page in full
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 full
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 full
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 full
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 full
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 full
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
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 full
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
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 full
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 full
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 full
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 full