(Marco Gilbert) This tip is for people who use Oracle Resource Manager in Oracle Database 10g to manage CPU usage by consumer group.
Other News
Learning XPath with XSLT using ASP.NET 2.0
(Jagadish Chaterjee) This is the first article in a series focusing on XPath with XSLT using ASP.NET 2.0. In this article, I will be focusing on setting up your own XSD, XML and XSL to test XPath expressions along with a few of the basic XPath expressions, together with XSLT constructs.
Calling Cross Domain Web Services in AJAX
(Chris Ullman) One of the current vogues in web applications is the creation of mashups. This involves the marrying of content and/or functionality from two different sources. Over the last few years, the opening up of formerly proprietary APIs from the likes of Google, Yahoo, Last.fm, Flickr, YouTu
Read and Write Open XML Files in MS Office 2007
(ZeljkoS) With Office 2007, Microsoft decided to change default application formats from the old, proprietary, closed formats (DOC, XLS, and PPT) to new, open and, standardized XML formats (DOCX, XLSX, and PPTX). New formats share some similarities with old Office XML formats (WordML, SpreadsheetML)
Building a data mining solution using IBM Intelligent Miner Scoring and WebSphere
(Stefan Warwas) The objective of this tutorial is to get you confident with executing Intelligent Miner Scoring statements from a J2EE Web application. The calculation and presentation of the scoring results is done in real time. (R)
MySQL Session variables and Hints
(Peter Zaitsev) MySQL has two ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT, STRAIGHT_JOIN, FORCE INDEX etc. You place these directly into the query to change how query is executed for example: SELECT STRAIGHT_JOIN * FROM A FORCE INDEX(A) JOIN B
Faster Filtered SQL Server Imports
(Colin Goddard) This article shows how to bulk load data from text files into SQL Server, using Perl’s Win32::OLE module to control Microsoft’s Database Transformation Services (DTS).
Inside SQL Server 2005 Management and Administration Tools
(Dima Sonkin, Thierry D’Hers, Kami LeMonds and Michael Raheem) SQL Server Management Studio is a rich and comprehensive tool that enables many management and administration scenarios. This sample chapter provides some tips and tricks for using the tool, straight from the Microsoft team that created
Dynamic Management Views [DMV] – A SQL Server 2005 Feature
(Hari Prasad K.) The DMV’s; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance. DMV’s are designed to be used instead
DB2/Informix and open source: Database defense against the dark political arts
(Marty Lurie and Aron Y. Lurie) A down system is one of the most stressful events for system administrators. This article shows you how to create a real-time monitor for your database so you can be alerted when problems arise, and also provide valuable information to others about the status of the d