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 »

Microsoft SQL Server – measure operation time

In previous post we’ve described how to get simple good looking information about your data. Now let’s try to find out how we can measure time required by db operation (stored procedure, sql query etc) to perform. Read the rest of this entry »

User management – permissions issues

Lets talk more about permissions management in jxmpp-bot.

Read the rest of this entry »

User management – Service layer

Today let’s talk about User Management use-cases more closely. We need several database mappers, several services and facade pattern.

Read the rest of this entry »

Jxmpp-bot: User management

Now, when Syslog subsystem is ready it’s time to create user-management subsystem

Read the rest of this entry »

Cellphone for my syster

Recently I’ve received distress call from my sister. She wants simple but elegant cellphone for herself.

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 »

Some random thoughts

It’s time to do some planning for future

Read the rest of this entry »

Sqlite in Java. Performance.

I’ve prepared comparison and gathered some statistical information about sqlite performance in Java. Performance overhead in auto-commit enabled mode is huge.

Read the rest of this entry »