How to add Microdata to markup structured data for blogs

Microdata is a set of schema rules which can be added to HTML code to markup structured data . This helps search engines to display rich snippets in search results.

MySql - resetting deleted root user and password

resetting an accidently deleted mysql root user or password requires you to have command line access to mysql daemon which needs to be stopped and restarted.

Types of Database Relationships

Generally speaking, database relationships refer to the way data is organized across multiple tables where data in one table is referring to data in another table by some relation. Technically speaking, database relationship is a term that

Recovery of a deleted dataset

There can be an instance when somebody unknowingly deletes your data set or by mistake you have deleted it but now you need it. HMS takes the back up of the dataset on each night. You can check whether your data set is backed up or not w

Basics of UMDT - User Maintained Data table

In February 1989, CICS announced enhancements for the CICS/MVS product and CICS/MVS 2.1. Most notable was the introduction of CICS Data Tables support, either as CICS Maintained Data Tables (CMDT) or User Maintained Data Tables (UMDT). ‘D

5 SQL tuning Strategies - DB2

Tuning Strategies:   Ø       Tuning Strategy 1: ü       Adjust the COLCARD, FIRSTKEYCARD and FULLKEYCARD columns to an artificially high value. Reason: ü&nbs

Tuning of SQL queries in DB2 when RUNSTAT is not feasible

Updating the DB2 Catalog Statistics: Ø       This method of tuning is chosen whenever standard methods (RUNSTATS) of influencing the DB2’s access path selection are not satisfactory.  Ø 

Function of OPTIMIZE FOR n ROWS in DB2

OPTIMIZE FOR n ROWS:  Ã˜       This method enables the programmers to specify the estimated maximum number of rows that will be retrieved. Ø       It provides more i

Tweaking of SQL queries in DB2 - Use of Filter factor

Tweaking the SQL statements:  Ã˜       Tweaking is the process of changing a SQL statement without changing its functionality Ø       Filter Factor is a ratio that DB2