(Scot Reagin) Successfully implementing a business intelligence (BI) solution is a challenging, complex and valuable endeavor. Overcoming challenges and complexities requires a combination of the right implementation strategy and technology. Understanding the interdependency of these factors is crit
Author: SSWUG Research
Encryption and the Assured Business. Do it or Die
(Nigel Stanley) No one ever wants less security, and in today’s mobile computing world securing mobile data is becoming a real issue.
A Basic Monitoring Engine in PHP
(George Schlossnagle) When you’re writing a daemon, it is usually advisable to have it set its own working directory. That way, if you read from or write to any files via a relative path, they will be in the place you expect them to be. Always qualifying your paths is of course a good practice in an
Access Object Enhancifier
(Danny Lesandrini) There is a clever, poke-fun-at-George-Bush web site named Weekly Radio Address where you can listen to a new parody of the president each Monday morning. It’s irreverent and probably exaggerates GW’s difficulty with the English language, but it’s funny all the same, and a little c
XML data solutions with xfy and DB2 9, Part 2: Deliver dynamic XML information solutions
(Laura Giddings and Andy Stewart) The record adoption of XML and evolution of database technology to natively store both XML and relational information, have revolutionized the way enterprise data can be managed and shared. Justsystems xfy Enterprise Solutions combined with IBM DB2 9 let you manage
Intelligent Miner articles and tutorials: Mine DB2 XML columns with DB2 Data Warehouse Edition data mining
(Peter Bendel) Data mining methodologies traditionally find rules and patterns in structured input data such as relational tables or views. However, IBM DB2 9 XML columns cannot be directly used as input to DB2 data mining algorithms. Learn how you can create a relational view over semi-structured X
Using MySQL Programs
This chapter provides a brief overview of the command-line programs provided by MySQL AB and discusses the general syntax for specifying options when you run these programs. Most programs have options that are specific to their own operation, but the option syntax is similar for all of them. Later c
Influencing Query Performance
(Fernando Echeveste and Tom McKinley) What are the key factors that influence query performance in my IT shop? You may have asked yourself this question several times when running your workloads. Perhaps you questioned it when you noticed your workload wasn’t running as efficiently as you thought it
adpatch fails- Cannot connect to RAC databas
(Arnoud Roth) Yesterday I needed to apply a patch to my Oracle E-Business Suite 11.5.10.2 environment.
Alerting on Database Mirroring Events
(Phillip Garding) An important part of monitoring a mirrored database is configuring alerts on significant database mirroring events. SQL Server 2005 supports two types of events for database mirroring: • SQL Server message events based on user-defined performance thresholds that are logged to th