(Steve Callan) We’ve recently been discussing installing Oracle Enterprise Manager, database preparation and installation of the middleware (Oracle WebLogic Server). Continueing in that vein, this article shows you how to install the Grid Control component.
Other News
Thinking about running OPTIMIZE on your Innodb Table ? Stop!
(Peter Zaitsev) Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so using less space, it is just OPTIMIZE TABLE might not be best way to do it.
IBM Cognos Proven Practices: Enterprise Planning – User Lockdown in DB2
This document describes methods to limit database permission in DB2 for IBM Cognos Planning 8.
Use a Table as a Message Queue
Featured Article(s) Installing and Configuring Reporting Services (Part 1 of 3) In this session, readers will learn the basics of installing Microsoft SQL Server Reporting Services. This session will cover common installation situations and will discuss some of the more common pitfalls that surround the installation. This session will also cover the basics of Reporting Services configuration options, including basic […]
Scheduling Jobs for Your Databases
Featured Article(s) Troubleshooting SQL Server 2008 full-text search In this article, Alexander Chigrik explains some problems you can have with SQL Server 2008 full-text search. Scheduling Jobs For Your Databases Steve has been doing a series of Articles on TSQL, the last of which he focuses on Job Schedulers for SQL Server, TSQL 10 – Need To Know Information About […]
Obfuscation And Code Protection In ASP.NET
(Richard Bean) If you create ASP.NET web application or custom web control that should be distributed to customers worldwide, you need to protect your code from pirates, unlicensed users and competitors. If you offer web service or solution hosted on your server only, you can even upload source code
ASP.NET 3.5 File Upload Tutorial Using VB.NET
This is a beginner tutorial on designing an ASP.NET web page that will accept file uploads using VB.NET (Visual Basic).
Designing XML: Some Notes
(Jeff Wyonch) Back in 2003, a couple of things happened. The program that I had bought to catalog my comic books had finally died. The company that sold it had gone under years before, and the program simply stopped working under Windows XP, and I didn’t have the money to buy a new program at the ti
Managed or Self-Service BI?
(Stacia Misner) I remember when I started my career in business intelligence, I heard a lot about self-service BI and was excited about the possibilities, but I found the reality of self-service BI tools did not match up to the ideals that were marketed at that time.
PL/R Part 2: Functions that take arguments and the power of aggregation
(Leo Hsu and Regina Obe) In Intro to PL/R and R, we covered how to enable PL/R language in the database and wrote some PL/R functions that rendered plain text reports using the R environment. What makes combining R and PostgreSQL in PL/R most powerful is when you can start writing SQL summary querie