PeerGuardian Replacement PeerBlock

PeerBlock appears to be the exact same program as PeerGuardian except it installs on all windows system including 64bit w/o having to hassle with it.

http://www.peerblock.com/

Peer Guardian 2 64bit Installation Instructions

UPDATE: Use PeerBlock instead.
--------------------------------------------------------------

Download Driver Signature Enforcement Overrider and follow the directions.

But basically you run the program.
Select Enable Test Mode -> click next
Select Sign a System File -> click next
then put in your_peerguardian_directory/pgfilter.sys and hit ok.

Daemon Tools Windows 7 Upgrade Issue

You might find after upgrading to windows 7 that daemon tools (also alcohol 120%) won't run and is impossible to uninstall or reinstall.

To avoid this problem all together make sure and uninstall daemon tools before upgrading to windows 7.

If you didn't do that simply follow these steps:

1. delete your daemon tools folder


2. using regedit delete the
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\sptd
   directory. If it won't let you delete it, right click on the directory click the 'Full Control' checkbox then advanced and check the subfolder check box and 'ok' your way out. Then try and delete it.


3. Go into your windows installation folder/system32/drivers and delete sptd.sys


4. Reboot your PC


5. Now you should be able to install Daemon Tools

SQLServer 2005 Generate Scripts Append Bug

There is a known bug in SQL Management Studio 2005 where when you try to generate scripts and you set 'Include Descriptive Headers' to false, then 'Append to File' will always be true.

Sadly they fixed this in SMS 2008, but didn't include the fix in SP3 for SMS2005.

The only work around I've found is to download SQLServer 2008 and use SQL Management Studio 2008. The downside to this is that the scripts 2008 generates differ from what 2005 generates.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=387334

Select Into Multiple Variables

DECLARE @x nvarchar(max)
DECLARE @y nvarchar(max)
select @x=name,@y=city FROM (SELECT TOP 1 name, city FROM Table1) a
SELECT @x, @y

Visual Studio 2008: How to add a command line argument in debug mode

Right click on your project -> choose properties -> Debug tab

under 'Start Options' there should be a text box called 'Command line arguments'

Now just type your arguments there like you would at the command line.

example:
command line: program.exe my_argument my_2nd_argument

in the box you would just type: my_argument my_2nd_argument

SQL: 24hr Pivot

this is a little sample of how to pivot data in the form of
names|values|hours
a|1|12
a|9.1|13
b|2.5|12
b|3.6|13

and change it to:
names|12|13
a|1|9.1
b|2.5|3.6

SELECT * FROM (
SELECT names,Hours, Values
FROM aTable a
WHERE a.names IN ('a','b')
) p

PIVOT (
SUM(values) FOR [hours] IN ([0],[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23])

) AS pvt