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 »