(Rudy Limeback) How could I sort a query result according to a specific order (not ascending or descending) that I will be supplying from the values of the column to be sorted? (R)
Other News
Secure Your ASP.NET Apps And WCF Services With Windows CardSpace
(Michèle Leroux Bustamante) In May 2005, Microsoft introduced its vision for an identity metasystem that would reduce the complexities and risks associated with managing and exchanging digital identities. This vision-discussed in the article “Microsoft’s Vision for an Identity Metasystem” explains i
Drill down into data with ASP.NET 2.0’s DetailsView control
(Tony Patton) The past two weeks I have examined using ASP.NET 2.0’s GridView data control to view and manipulate data within a Web page. (You can catch up on parts one and two here.) While the GridView control makes it easy to work with sets of data, you often need to work with the data in individu
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
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)
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
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.
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
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.
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