(James F. Koopmann) Everyone is looking for an edge. With PL/SQL that edge is compiling the PL/SQL code into native code. This article will show you how to setup and compile your PL/SQL procedures and packages.
Other News
OLAP SQL Part 3 – Grouping Sets
(Chris Eaton) So far we have talked about ROLLUP and CUBE. Now let’s look at GROUPING SETS. Have you ever had a query where you wanted to see the results on different groups? For example you want to see a report of sales grouped by sales rep and you also want to see sales grouped by week and geograp
Track and Monitor Resources
(Luis Adalberto) Running this query will produce a list of database statements and objects that are using the most resources.
Get better search results with this advanced SQL pagination searching technique
(Anthony Molinaro) This chapter excerpt from the SQL Cookbook explains how pagination and other advanced search techniques can be used to increase the quality of your SQL queries. (pdf)
Moving Data from SQL Server 2000 to SQL Server 2005
(Jayaram Krishnaswamy) This article explains how to move data out of SQL 2000 Server and into SQL Server 2005. This hands-on tutorial shows a step-by-step procedure for moving to SQL 2005, the new database from Microsoft released in November of 2005.
Setting up SQL Server clusters on a SAN
(Serdar Yegulalp) Storage area networks, (SANs), make it easy to connect massive amounts of expandable storage to a server. SANs are particularly useful for SQL Server installations: Enterprise databases don’t just require a great deal of storage; they also have continually-expanding storage needs.
Zooming In On Saturn
(Greg Crawley) DB2 Universal Database for Linux, Unix, and Windows version 8.2.2 (code-named Saturn) introduced many features designed specifically for SAP customers — so many, in fact, that they’re difficult to count. I’ll help you focus in on the features I find particularly useful (and suspect yo
Commanding ASM
(Arup Nanda) Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manag
A Kick-Start to SAX with C++, Part1
(Marius Bancila) This series of articles is not a complete tutorial on SAX, but rather a kick-start. Familiarity with XML is required. In this first article, you will see what SAX is, how is it supported with the Microsoft XML Parser (MSXML), and how can you create a simple SAX application.
Oracle Tuning Tips
(paviagrawal) These rules are simple but easy to follow and will yield lots of benefits.