January 2013

Rob van der Woude has a nice batch script to get disk usage of folders & subfolders in Windows since there isn’t a built-in function.  This could be similar to Linux du command.   @ECHO OFF :: Use local variables IF "%OS%"=="Windows_NT" SETLOCAL :: Check command line arguments and Windows version ECHO.%1 | FIND "/"…

Read More Batch Script to get Disk Usage of Folders Recursively

Here’s a query I found that helps show database IO consumption. SELECT DB_NAME(DB_ID('DATABASENAME')) AS [Database Name] , mf.physical_name , io_stall_read_ms , num_of_reads , CAST(io_stall_read_ms / (1.0 + num_of_reads) AS NUMERIC(10, 1)) AS [avg_read_stall_ms] , io_stall_write_ms , num_of_writes , CAST(io_stall_write_ms / (1.0 + num_of_writes) AS NUMERIC(10, 1)) AS [avg_write_stall_ms] , io_stall_read_ms + io_stall_write_ms AS [io_stalls] ,…

Read More SQL Database IO Consumption

What is it? I created a small tool to help facilitate setting the default user to automatically logon to a system. Requirements Administrator Privileges .NET 2.0 or greater Details There are 4 registry entries of interest here: [HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionWinlogon] AutoAdminLogon=1 DefaultUserName= DefaultPassword= ForceAutoLogon=1 If you don’t want to download and run my program, you can…

Read More Tool: AutoLogon – Configure Windows’ Automatic User Logon

I have ImageMagick installed on a Linux system I use to host a few websites. From time to time, I need to quickly resize a photo, add a watermark, or do something else to an image on the server. I could easily FTP to the server, grab the files, modify then re-upload. I find it…

Read More Change Image Brightness, Contrast and Hue with ImageMagick Command Line