How to search a Keyword in all columns of all tables in a MSSQL database?

Being a Network Administrator, I more often required to search some keywords in a database or all columns. I did search and found a good store procedure called “SearchAllTables“ that can give the required results. It can give you results back from any kind of parameter like varchar, char, nchar or nvarchar columns from own created database tables. If you are the guy, how can make it more good, come up with the idea, I will update it here for next reader.

Read More

How to Port Forward from External to Internal with Zentyal SBS

I was required to access a Java Website from my external/internet to internal local area network. I have done this with this simple thing. I know it’s pretty easy but I just want to show up here on my blog for new comers to help them quickly as usual (I assume that you have everything up and running and now just need to forward port ! Firewall Modules is required to do this task)

Read More

How to Install Java-Plugin for Firefox on Linux RHEL/CentOS 5.X & 6.X

Many of you might need someday to Install Java Plugin for Firefox on CentOS 6.x and you might face that after even completing it successfully, it is not working. Well, after installations Java Plugin in CentOS, you must have to create soft link to get the Java Plugin working. I did it and it worked but I thought to create a post for this and next time I will only check from this post while installing Java Plugin on any of the Linux CentOS box. Cool, here I have done to get it working.

Read More

How to Flush DNS in Windows, Mac OS and Linux?

Almost all well-known Operating Systems like Microsoft Windows, Apple MAC OS and many Linux clients automatically cache IP Address and DNS as well. It’s normally called ARP and it help PC to look in this table to quickly get same host information related to it. Sometimes, PC give you old saved results related to IP Address and Host and you need to clear these records from cache to update the new records.

Read More

How to Find your Static IP Address on Windows 8.1

I will say, it’s up to you that what procedure you would like to adopt, there are different techniques and I will write down all possible methods from easy to advance level but some of the solution might work or not, as it totally depends on the situation and the way you are proceeding.

Read More

Get Socially Engaged with IP Address and Host Team !