How to get current MS SQL 2008 Version

Here's a quick T-SQL to get you the current version of your SQL server. SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY ('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition GO You can also use: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') Continue reading →

XP Windows Task Scheduler Advanced Menu

Windows XP's Tasks folder view has an Advanced menu (which I've never paid attention to) that allows you to choose additional functions for the task scheduler. I *never* knew this existed via the GUI.  I always used the command-line and registry snooping to find/create tasks and the event viewer to review task's runs.  This menu lets you show hidden tasks, view the log, setup notification, etc. Continue reading →

Ncurses Motha F##ka

I love when I read through code as I'm hacking it up and I actually laugh out loud.  This one got me today when I was hacking up Linfo (PHP Linux System information script). // Extensions runExtensions($info, $settings); // Make sure we have an array of what not to show $info['contains'] = array_key_exists('contains', $info) ? (array) $info['contains'] : array(); // From the command prompt? Ncurses motha fucka! if (defined('LINFO_CLI')) { $out = new out_ncurses(); $out->work($info, Continue reading →

UPHCleanup, Handle, ProcExp vs. NTUSER.DAT

The infamous: Windows cannot load the user's profile but has logged you on with the default profile for the system. This was received on Windows Server 2003 Terminal Server (non-roaming profile) when I logged in this morning.  I *really* grumble when I see these errors. My first thought was NTUSER.dat and NTUSER.dat.LOG files were locked.This server has User Profile Hive Cleanup which is supposed to combat this during a user log off and make sure handles are closed to the files in the Continue reading →

#sysinternals, #tasklist

Cleaning Things Up

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

Excuse all the dust and debris!  I’m in the middle of cleaning things up.