(Dmitri Popov) If you’ve ever worked with MySQL databases, you are probably familiar with phpMyAdmin, a PHP-based tool that allows you to create and manage MySQL databases via a browser. It is an indispensable tool for anyone building a PHP/MySQL-based Web application. But while phpMyAdmin eases the
Author: SSWUG Research
Teaching XSLT new tricks with EXSLT
(Michael Day) Following on from Kurt’s detailed reevaluation of XSLT 2.0, I thought that I might share an example of what you can do in XSLT 1.0 with the assistance of EXSLT, a useful set of extension functions that are supported by most XSLT implementations.
SQL Full-text search anomolies
(Hilary Cotter) On the newsgroups recently I have encountered some posters who are perplexed by the results of their full-text searches.
Using UserName to Control Data Access and Default Member in SSAS 2K5
(Carrie Williams) This paper will discuss how to use the UserName function to restrict data access and control the default member in SSAS 2K5. To most effectively demonstrate the topic being addressed we will refer to the Adventure Works cube and discuss the modifications necessary. The Adventure
PowerSMO at Work Part 2
(Dan Sullivan) My previous article, PowerSMO at Work I, demonstrated how to create and deploy secure, signed DBA scripts and then showed how to use PowerSMO functions to manage the extended properties of SQL Server objects.
Oracle RAC Administration : Backing up your RAC with RMAN
(Tarry Singh) VMware has this very cute VCB utility. Although on the ESX 3.0.1 server where I am currently building my RAC, I just use FTP/SCP to copy the files to some network drive. This is handy, as I need to do all kinds of things, like remove a node, simulate rebuilding and recovering RAC files
Upgrading to MSXML 6.0
Microsoft Core XML Services (MSXML) 6.0 is the current version of the core XML stack in the COM / Scripting environment. This document covers installation of MSXML6 and application upgrade, supported operating systems and changes from MSXML 3 and MSXML 4.
Multiple Buffer Pools with Oracle
(Kevin Closson) The multiple buffer pools feature of Oracle has always seemed much underappreciated. Back in the late 90s we found the feature invaluable when running audited TPC-C benchmarks on Sequent gear. With that workload it is critical to be able to size blocks according to the row size and m
OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4
(Hernando Bedoya, Jaime Gaug, James Kerlk, Ser Ser NG and Jose Cardoso dos Santos) The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network traffic, disk I/O, and CPU time. (pdf)
XML for PHP developers, Part 3: Advanced techniques to read, manipulate, and write XML
(Cliff Morgan) PHP5 offers the developer a lot more muscle to work with XML. New and modified extensions such as the DOM, SimpleXML, and XSL make working with XML less code intensive. In PHP5, the DOM is compliant with the W3C standard. Most importantly, the interoperability among these extensions i