mysql-400x375.png

How to select non empty columns in MySQL?

Select non empty columns in MySQL

Sometimes it’s required to troubleshoot or optimize MySQL database and we need to select non empty columns in MySQL. To Select non empty columns in MySQL and as a general our query is totally understandable like we need to write SELECT Query for MySQL, We need * to chec Read More »

mysql-400x375.png

How to import large MySQL file in phpmyadmin

I am working on IP Address Host Website Optimization as previously I was using only one table and inserting all the information related to IP Address in Single Table but I just notices that I am repeating un-necessary data in every row and it was increasing my database size rapidly. I download IP Address Host MySQL database and tried to restore / import in phpmyadmin on XAMP / Local Server but it gives me an error “You probably tried to upload Read More »

logo-pfsense-225x185.jpg

How to block HTTP and HTTPS Facebook with pfSense

Facebook works on HTTPS and there are some tutorials that help you to install “Squid3” Development Package on pfSense to configure pfSense for blocking some of websites but I found issues with it and it wasn’t worthy for my work environment along with “blocking Facebook with pfSense”. I have tried many of tutorials to block Facebook on pfSense box and some of them works but these also blocks som Read More »

The Network Bridge on Device VMnet0 is Temporary down because the Bridge Ethernet Interface is down

The Network Bridge on Device VMnet0 is Temporary down because the Bridge Ethernet Interface is down.

[av_image src='http://www.ipaddresshost.com/blog/wp-content/uploads/2014/12/vmware-bridge-network-error-300x18.png' attachment='3644' attachment_size='large' align='center' animation='no-animation' link='lightbox' target='' styling='' caption='' font_size='' appearance=''][/av_image]

Read More »

Event ID 8193 vss windows 2008 0x80070005 Access Denied - Volume Shadow Copy Service error

I was on routine Servers maintenance and notices that Volume Shadow Copy Service error with Event ID 8193 followed by Event ID 8224 is being generated again and again under File Service on Windows Server 2008 R2. I start goggling for this purpose but all I come across was about DHCP Server & SharePoint Server. I was facing this issue on my Hyper-V Server and wasn’t have a runn Read More »