vmware unix

A great place to find vmware virtual machines for freebsd, ubuntu, cent os, red hat linux (RHEL), Linux Mint, etc is over at bagside’s virtual appliance repository

here’s what they offer:

Virtual Appliance Repository.

This site is dedicated to virtual appliances that we build for you to use FREE of charge (except for Windows . . . → Read More: vmware unix

snort-2.8.6.1.tar.gz

Looking for snort-2.8.6.1.tar.gz ?

Download it here

in TD Tables Struct Dir; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘SEQUENCES’.;

How to fix

Failed to determine structure in TD Tables Struct Dir; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘SEQUENCES’.

This error may occur with Mercury Quality Center 9.0 if you move a project between databases.

The fix:

1. Detach the database 2. Reattach the database and make the owner ‘sa’

SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’

How to resolve this error:

[Mercury][SQLServer JDBC Driver][SQLServer]SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’.; Stack Trace: java.sql.SQLException: [Mercury][SQLServer JDBC Driver][SQLServer]SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’. at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source) at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)

The reason this error is occurring is because user td does not have rights to the tables . . . → Read More: SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’

Redmine Alert on New Admin or Public Project

Problem: How can I receive an email when the Redmine admin list changes or a project is changed to publicly viewable? You will need to run some mysql commands / queries in windows batch mode.

Solution:

Download blat and place in c:\windows\system32 Create directory c:\1admin and place these files in it:

These are the queries . . . → Read More: Redmine Alert on New Admin or Public Project

Howto: check database fragmentation sql server

Howto: check database fragmentation sql server

How to find all indexes that have fragmentation over 25%:

select * FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL , NULL, ‘LIMITED’) WHERE avg_fragmentation_in_percent > 25.0 AND index_id > 0 AND page_count > 1000 order by avg_fragmentation_in_percent desc

truncate sql log

First off, You CANNOT REVERT this command, so be sure you want to truncate the log! THE QUERY Instructions: Just replace with your DB

BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( ”, TRUNCATEONLY)

compare two files freeware

Howto: Compare two files using freeware or open source

Diffmerge is my favorite program (open source at least) that I use to compare files.

From their website:

DiffMerge is an application to visually compare and merge files for Windows, Mac OS X and Linux.

DiffMerge in Vault

DiffMerge was developed as the internal compare/merge tool . . . → Read More: compare two files freeware

clear flash cache

How to clear your flash cache

To clear specific sites:

http://www.macromedia.com/support/documentation/en/flashplayer/help/settings_manager07.html

When you click on the link, you are taken to the adobe site. On the right hand side of the frame, there is a box that will display a list of visited websites. All you need to do is click on the button that . . . → Read More: clear flash cache

Howto Backup your Bitnami Instance to a Remote Site for Free

Howto Backup your Bitnami Instance to a Remote Site for Free What you’ll need 1. Install dropbox to c:\My Dropbox 2. The names of the services bitnami uses (from command line type net start to get list of services) 3. A new local user in the administrator group that will just be used to run . . . → Read More: Howto Backup your Bitnami Instance to a Remote Site for Free