JBoss AS and JDBC DataSource tutorial

In this post I’d like to share my own expericence of creating of out-of-the-box database solution using JBoss AS, JPA and EJB 3.1

Read the rest of this entry »

Advertisements

PostgreSQL XPath tutorial

In this post I’d like to show some practical examples of XML processing in PostgreSQL using XPath

Read the rest of this entry »

jHolidays project

Some time ago I’ve decided to create a small utility which will be able to create ICal calendar using input file (listing of events, holidays etc). Read the rest of this entry »

Microsoft SQL Server – Complex Cleanup

Today my team manager asked me to create small interesting sql script. This script recieves time interval on input, splits given time interval into smaller parts (let’s say 24 hours per interval), counts total number of records for each interval, outputs this information and deletes records. Script mustn’t delete top”fresh” records though. E.g. manager would like to specify offset parameter, so records from interval [today-offset;today] mustn’t be deleted. Read the rest of this entry »

Microsoft SQL Server – gathering tables information

Let’s examine how we can output some statistical information about database tables.

Read the rest of this entry »

Oracle stats (Part 3)

Finally let’s find out how to gather per table statistics.

Read the rest of this entry »

Microsoft SQL Server – statistics

I’ve recieved interesting task from my boss. I need to prepare a few stats for MS SQL Server so let’s do it.

Read the rest of this entry »