Jan
04
2009
0

Delete Revisions from WordPress DB

I ran into this revisions annoyance in WordPress…It’s no problem to turn off the beast, but rather to clean out the existing revisions from the DB.

Luckily others also get annoyed.  Andrei Neculau cooked up a nice sql query that took care of all the leftovers

  1. DELETE a,b,c  
  2. FROM wp_posts a  
  3. LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)  
  4. LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)  
  5. WHERE a.post_type = 'revision'
Written by Kimmo in: jernstrom.org |
Jan
04
2009
0

Moved over to WordPress

So, I got tired of the old CMS and after having evaluated a few alternatives I decided to use WordPress. The feature set (over)matched the simple needs of this site…

j

Written by Kimmo in: jernstrom.org |
Sep
12
2008
0

Windows Installer Wrapper Wizard (WIWW)

Here’s the short

Windows Installer Wrapper Wizard (WIWW) 0.2.0 can create Windows Installer msi wrapper files that will execute commands you specify in a wizard. Its intended use is allowing administrators to execute commands or install software using machine assigned or user published group policies…/

Article here
Backup copy: windows_installer_wrapper_wizard_020

Written by Kimmo in: Legacy |
Apr
05
2008
0

CHM (HTML Help) file annoyance

Aside of the NTFS alternate data stream manipulation (aka. blocked content) that can be circumvented by GPO
User Configuration\Administrative Templates\Windows Components\Attachment Manager there is the issue with CHM files over the network.

See http://support.microsoft.com/kb/896358

REGEDIT4
  1. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp]
  2. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\HHRestrictions]
  3. "MaxAllowedZone"=dword:00000001
  4. "EnableFrameNavigationInSafeMode"=dword:00000001
  5.  
  6. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions]
  7. "MaxAllowedZone"=dword:00000001
Written by Kimmo in: Legacy |
Mar
29
2008
0

Vista/ 2008 Compound TCP and ECN

I better just dump this for reference before I forget about the whole thing….

You can check if your home router supports ECN with Microsoft Internet Connectivity Evaluation Tool

Summary below stolen from
http://technet.microsoft.com/en-us/library/bb726965.aspx

Compound TCP
For TCP connections with a large receive window size and a large bandwidth-delay product, Compound TCP (CTCP) in the Next Generation TCP/IP stack aggressively increases the amount of data sent at a time by monitoring the bandwidth-delay product, delay variations, and packet losses. CTCP also ensures that its behavior does not negatively impact other TCP connections. In testing performed internally at Microsoft, large file backup times were reduced by almost half for a 1 Gigabit per second connection with a 50 millisecond round-trip time. Connections with a larger bandwidth-delay product can have even better performance.

Receive Window Auto Tuning optimizes receiver-side throughput and CTCP optimizes sender-side throughput. By working together, they can increase link utilization and produce substantial performance gains for large bandwidth-delay product connections.

CTCP is enabled by default for computers running Windows Server 2008 and disabled by default for computers running Windows Vista. You can enable CTCP with the netsh interface tcp set global congestionprovider=ctcp command and disable CTCP with the netsh interface tcp set global congestionprovider=none command.

ECN Support
When a TCP segment is lost, TCP assumes that the segment was lost due to congestion at a router and performs congestion control, which dramatically lowers the TCP sender’s transmission rate. With Explicit Congestion Notification (ECN) support (RFC 3168) on both TCP peers and the routers in the routing infrastructure, routers experiencing congestion mark the packets as they forward them. TCP peers receiving marked packets lower their transmission rate to ease congestion and prevent segment losses. Detecting congestion before packet losses are incurred increases the overall throughput between TCP peers. Windows Server 2008 and Windows Vista support ECN, but it is disabled by default. You can enable ECN support with the netsh interface tcp set global ecncapability=enabled command.

Written by Kimmo in: Legacy |
Mar
29
2008
0

Batch remove %20 from filenames

Got tired of the %20 in downloaded files

@echo off
  1. setlocal EnableDelayedExpansion
  2. for /f "delims=" %%I in ('dir /b ^| find "%20"') do (
  3. set var01=%%I
  4. set var02=!var01:%%20=_!
  5. call :ren
  6. )
  7. :ren
  8. ren %var01% %var02%

mycmd

Written by Kimmo in: Legacy |
Feb
21
2008
0

How to connect to console session with RDC 6.1

With Remote Desktop Connection 6.1 (RDC) some things have changed.
That you now need to use mstsc /admin to connect to the console session is common knowledge….
However, when using .RDP files we used to add “connect to console:i:1″ in the .RDP to connect to the console session, well turns out that this no longer works….

Long stroy short, here’s what you need to do:

Before…
mstsc /console = “connect to console:i:1″ in .RDP file

After…
mstsc /admin = “administrative session:i:1″ in .RPP file

Written by Kimmo in: Legacy |
Feb
13
2007
0

Parted Magic - free alternative to Partition Magic

I actually used this on a HP DL360 (with a RAID set) through ILO over a WAN connection. Worked like a charm!

parted
 

Parted Magic is a ~30mb LiveCD/USB with it’s only purpose being partitioning hard drives. Although GParted and Parted are the main programs, the CD/USB also offers programs like partimage, TestDisk, fdisk, sfdisk, dd, ddrescue, etc…

Read more and download here

Backup copy (//090102) pmagic-3.4.iso.zip

Written by Kimmo in: Legacy |
Jan
02
2007
0

Sharepoint v3 Forms Authentication

Allrite, so this is the way to implemt forms with System.Web.Security.ActiveDirectoryMembershipProvider

sharepoint_v3_forms

…and this the way to do it with System.Web.Security.SqlMembershipProvider (with roles)

sharepoint_v3_forms_sql

…you need to have the membership provider in web.config for central admin

Written by Kimmo in: Legacy |
Oct
30
2006
0

Troubleshooting Tools for Citrix Environments

A nice list of troubleshooting tools over at citrx.com

Read more here

Written by Kimmo in: Legacy |

Copyright (c) jernstrom.org