(Hernando Bedoya, Elvis Budimlic, Morten Buur Rasmussen, Peggy Chidester, Fernando Echeveste, Birgitta Hauser, Kang Min Lee and Dave Squires) 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
Other News
The Future of Perl in PostgreSQL
(Andrew Dunstan) My first article about PL/Perl discussed using triggers written in PL/Perl, and the second showed how to exchange data with the database and running database commands from inside PL/Perl. This final article in the series explores the improvements in PostgreSQL versions 8.0 and 8.1 a
Useful SQL Queries to Analyze and Monitor SharePoint Portal Solutions Usage
(Syed Adnan Ahmed) It is a very common requirement in SharePoint Portal Solution to analyze a SharePoint solution in terms of storage capacity and statistics of sites, document libraries, area etc., to monitor the growth of the SharePoint solution and to take prompt action, if any thing goes wrong.
Q Replication and Consistent Change Data tables
(Sean Byrd) Consistent Change Data (CCD) tables have been a popular type of target table in SQL Replication. By enabling CCD tables as another target option, it is simple for someone familiar with Q Replication to take advantage of this new functionality. So at this point, you might ask, “Why should
Design for Performance
(David Beulke) Relational databases and relational set theory hold many performance advantages over other networked and hierarchical databases. Relational set theory and the ability to process multiple rows through one database SQL statement can be very powerful. Unfortunately, I continue to find pe
Applications for Real-Time Access
(Ari Kaplan) Database applications for wireless handhelds have an important role for business IT because they can increase productivity and lower costs for an enterprise. Let’s look at an experience I had designing and deploying a wireless application where access was the key.
Views in SQL Server 2000
(Kristofer Gafvert) A view is quite easy to define, but a lot more difficult to create, use and manage. It’s not anymore than a named SELECT statement, or a virtual table. You can select data, alter data, remove data and all other things you can do with a table (with some limitations). But there is
Oracle RMAN Backup and Recovery Script Example
Oracle database backup and recovery becomes a lot easier when you use RMAN. This script is indicative of the ease and should not be considered a full script for RMAN backup management in Oracle.
Regular expressions in Oracle
(René Nyffenegger) With 10g, regular expressions are finally available in SQL. That is, they were already supported through the owa_pattern package.
JavaServer Pages as Web service clients
(William Brogden) JavaServer Pages, or JSP, are an extension of Java servlet technology designed to facilitate dynamic creation of HTML pages by Web developers without writing Java code. When a JSP-capable server gets a request for a JSP page, it initiates a series of events that result in a Java se