Limited User For SSH Proxy/Tunnel

I’m not 100% whats going on in the useradd part, but I like the outcome…Can’t do shit!

This was posted 5 months ago. It has 0 notes.
Y PPA Manager - An Easier Way Of Handling PPA's?

I’m finding that more and more even the almighty APT can’t provide everything I need…Installing from source is getting easier, but all these Launchpad PPA’s can be cumbersome. This app might help…Or it could complicate things even further ;)

  • sudo add-apt-repository ppa:webupd8team/y-ppa-manager
  • sudo apt-get update
  • sudo apt-get install y-ppa-manager
This was posted 5 months ago. It has 0 notes.
Install ADB And FastBoot Via APT/PPA

Makes getting those simple, but critical tools installed on your Ubuntu 11.x/12.x instances:

  • sudo add-apt-repository ppa:nilarimogard/webupd8
  • sudo apt-get update
  • sudo apt-get install android-tools-adb android-tools-fastboot
This was posted 5 months ago. It has 0 notes.

You Done Lost Your Mind!

(Source: Spotify)

This was posted 7 months ago. It has 0 notes.

Something this simple should have been easy to find, eh? NOPE! Was a pain in the ass, since it’s so generic of a search string….Better late than never!!!

This is the “Dramatic Impact” sound that Moss has for his cell, course in real life it’s not as funny as the episode but it’s still cool enough to rock as my notification tone…

This was posted 7 months ago. It has 0 notes. Played 0 times.
miracleblog:

Wizard 130 (2002)
This magazine contained a wonderful full color illustration by Alex Ross featuring numerous Alan Moore creations including Miracleman and Johnny Bates. 

Can you imagine if those two (Moore & Ross) teamed up for something epic like Twilight of the Superheroes? Would cripple Kingdome Come, and that’s not small statement!

miracleblog:

Wizard 130 (2002)

This magazine contained a wonderful full color illustration by Alex Ross featuring numerous Alan Moore creations including Miracleman and Johnny Bates. 

Can you imagine if those two (Moore & Ross) teamed up for something epic like Twilight of the Superheroes? Would cripple Kingdome Come, and that’s not small statement!

This was posted 7 months ago. It has 2 notes. .
C# COM Port Example
This was posted 8 months ago. It has 0 notes.
Remove BIOS Password On HP ProBook

Just got our first one in at work (4535s to be exact) and so far I’m very happy with it, glad work looking towards more corporate solutions instead of just cheap consumer laptops.

The problem is that is looks like there is some deep integration. I didn’t go into the BIOS until after I had done the initial software setup, which may explain why I saw what I did…

Instead of the normal BIOS screen, or even a standard BIOS-level password, I was prompted for my Windows account credentials. Cool at first, but then I reminded myself how often I reload and muck around with things.

So I have a feeling I’m going to need to reference this page in the near future. My first goal is just to test and ensure that things work if I use a standard non-HP OEM Win7 Pro installation without any of HP’s software .

This was posted 9 months ago. It has 0 notes.
AMD Chipset Drivers For WinXP

Until this job I’ve been blessed with only dealing with Intel-based hardware…Unified drivers rule!!! That’s not to say AMD doesn’t have it too, but I’m just not as intimate with their driver stack as I am with Intel’s.

The WinXP angle is due to the fact that we need some physical (Virtual machines won’t work for hardware reasons) machines to do some testing on.

So I whipped out my trusty FinalXP image that I made a few years back…The “Final” part of the name was because at the time I figured I would never have to touch it again…Oppps! ;)

Either way, the fix was simple…I didn’t bother with manually integrating it since I’ve lost most of that knowledge since Win7 has taken over. So what I did was extract the ISO, download the RAID drivers from the link (Don’t worry, it works with SATA/AHCI as well), and then used nLite to integrate the drivers. CDImage to reconstruct the ISO and then burned using Win7’s built-in ISO Recording Support.

I’m pretty sure my Intel SATA drivers are still there (And very out-of-date at this point), I’ll have to test that out on another machine but I’m not sure if I have any available Intel hardware to test it on…Boo!

This was posted 9 months ago. It has 0 notes.
SQL Server 2012 - Shrink Transaction Log

We’ve been doing some heavy load testing lately, requiring us to make artificially massive databases. To do this we’ve been using a stored procedure that takes one records and duplicates it (While changing one column by adding a incremental number to the end).

We’ve been doing this to hit sizes like 8,000,000 records, and while it’s slow it seems to work…With one major exception.

The database transaction log is massive, many times it’s larger than the actual database! This is because (I think at least) the 8,000,000 transactions are all logged in verbatim, which is great for recovery/troubleshooting but totally unnecessary for our needs.

After much searching I finally found a simple process/script that takes the log file and dumps it down to 1MB…And it’s fast too!

Word to the wise: Make sure you have full backups and at least two disaster recovery plans. I’m not a DBA, so I have no experience working with db’s of this size and I may be suggesting a very bad idea. You’ve been warned!!!

NOTE: I used Example B

This was posted 11 months ago. It has 0 notes.