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…
Looking for snort-2.8.6.1.tar.gz ? Download it here
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…
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…
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…
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…
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)
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…
How to clear your flash cache To clear specific sites: 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…
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.…
