Scrum And Xp From The Trenches

February 13th, 2009

Scrum And Xp From The Trenches

by Henrik Kniberg

He doesn’t offer a lengthy description of what Scrum is; he refers us to some simple websites for that. Instead, Henrik jumps right in and immediately begins describing how his team manages and works with their product backlog. From there he moves through all of the other elements and practices of a well-run agile project. No theorizing. No references. No footnotes. None are needed. Henrik’s book isn’t a philosophical explanation of why Scrum works or why you might want to try this or that. It is a description of how one well-running agile team works.
This is why the book’s subtitle, “How We Do Scrum,” is so apt. It may not be the way you do Scrum, it’s how Henrik’s team does Scrum.

Register and/or buy printed version at:

http://www.infoq.com/minibooks/scrum-xp-from-the-trenches

Download.

pjdc books , ,

Flush the buffer cache in Oracle

June 26th, 2007

Flush the buffer cache in [tag]Oracle[/tag]. This invalidates also the read cache, so the query performance results provides from the physical reads time.

alter system flush buffer_cache;

This command is not available prior to 10g. It flushes the buffer cache in the SGA.
9i had an undocumented command to flush the buffer cache:

alter session set events = 'immediate trace name flush_cache';

pjdc database

kill a Windows process from the command line with taskkill

June 26th, 2007

[tag]taskkill[/tag] usage
To kill a process by name:

taskkill /IM notepad.exe

To kill a single instance of a process, specify its process id (PID).
For example, if the desired process has a PID of 827, use the following
command to kill it:

taskkill /PID 853

pjdc Uncategorized, windows

ClearCase – Find view private files

March 16th, 2007

In a VOB dir,
cleartool> ls -recurse -view_only

Technorati Tags:

pjdc Uncategorized

How to check the timezone on a unix machine

February 7th, 2007

cat /etc/TIMEZONE

pjdc linux ,

Dump database schema to a file

January 30th, 2007

export all oracle database to a dump file:

  1. $ORACLE_HOME/bin/exp / GRANTS=y ROWS=y FILE="exp.dmp exp_1.dmp" FILESIZE=1GB LOG=export.log OWNER="()"

pjdc database

Implement pagination with SQL Server 2005

January 9th, 2007

With the new row_number() feature of the MS SQL Server 2005, now it’s very easy to implement pagination: get data rows page by page to avoid the retrieve too much data at same time. The new feature it’s very similar to the Oracle ROWUM.
The prepare statement could be like the follow:

  1. SELECT * FROM ( SELECT row_number() OVER (ORDER BY id) AS resultNum, id FROM table_name) AS numberResultsWHERE resultNum  BETWEEN ? AND ?

More information here.

Technorati Tags: ,

pjdc database

Error: no `server’ JVM at … jvm.dll

January 5th, 2007

- remove the -server parameter from your command line, or
- download de Java JDK. The JVM server configuration DLL are not included in the JRE.

Technorati Tags: ,

pjdc java

Retrieving identity column values from MS SQL Server by JDBC

January 3rd, 2007

Retrieving identity column values in JDBC applications:

You define an identity column in a CREATE TABLE by specifying the IDENTITY clause when you define a column.
This feature is defined in the JDBC, and implmented in the MS Sql Server 2005, not in the older version. For Oracle database this is not implemented, but the common solution of the rownum can be used instead.

1.Set the prepared statement to get the identity column from DB:

  1. Connection.prepareStatement(sql-statement,
  2. Statement.RETURN_GENERATED_KEYS);

or

  1. Statement.executeUpdate(sql-statement, Statement.RETURN_GENERATED_KEYS);

2. Get the generated values from the statement

  1. rs = stmt.getGeneratedKeys();
  2. while (rs.next()) {
  3. rs.getBigDecimal(1);
  4. }

Technorati Tags: , ,

pjdc database, java ,

List the open ports on a windows machine

December 11th, 2006

run netstat -a

pjdc windows