Software and Support
I have been in the process of working on my website and organizing content to make it a little easier to find things. Most recently I've added a…
Author
Rich
Just another IT guy.
Internet Explorer 10 Now Available for Windows 7
Microsoft has released Internet Explorer 10 for Windows 7 and it is now available for download immediately or you can wait for it to be delivered by Windows…
Cisco 7960 How to Create Conference Call
How to create a conference, or "3-way" call on Cisco 7960 phone... Begin with one caller already on the line (It does not matter who initiates the first…
Harlem Shake – Facebook or Google+ Style
This is pretty awesome. I saw a cute JavaScript code that will do the Harlem Shake for the page you've loaded. Navigate to the site you want; facebook, google+,…
Tool: bitcalc – A Bit Calculator in .NET
Convert between bits/bytes/kilobits/kilobytes/megabits/megabytes/gigabits/gigabytes What is it? This is completely based on Matisse.net's online bitcalc tool: http://www.matisse.net/bitcalc/ Enter in an amount of units and click calculate. For example, in the…
MySQL Check For Fragmentation
I was working with a mail archive MySQL database today and was twiddling my thumbs waiting for simple queries to complete. The database has about 12 million rows…
LogParser Failed Remote Desktop Logons
rdp_audit_failed_logons.cmd @echo off REM Rich Kreider set LOGPARSER=logparser.exe set TARGET=%1 set TEMPPATH=%SystemRoot%\Temp @cls IF NOT EXIST "%SystemRoot%\Temp" set TEMPPATH=%TEMP% IF "%1"=="" ( set TARGET=%COMPUTERNAME% @echo Note: You can…
LogParser Error: column is not an integer nor a real
This error is caused by LogParser output format CHART having an invalid X-axis. In a SELECT * statement, all subsequent fields are value series after the first column.
Download Office Web Components (OWC) (Office 2007)
You need Office Web Components if you get the error when using -o:chart in LogParser: Error creating output format "chart": This output format requires a licensed Microsoft Office Chart…
Use LogParser to Audit Remote Desktop Access
I've been working with LogParser for a few days and really find it useful. There are some minor annoyances (lack of JOIN) with it but for the most…
Upgrade Windows 2008 R2 Standard to Enterprise or DataCenter
I had a virtual 2008 R2 Standard server that I upgraded memory on to 64GB and realized (forgot) that it only supported up to 32GB RAM. Here's what…
SQL Server Min and Max in Virtualization
Scenario: Guest VM Total Memory: 64GB SQL Server Max Memory: 58GB (Leaving 10%, or 6.4GB roughly for Windows + Apps) Guest VM Reservation: 48GB (75% of Guest…
Audit RDP Access using LogParser
Over time I will revise this; for now, I'm just dumping this here so I don't lose it. This pertains to Windows Vista, 7, 2008+ Event Logs simply…
Monitor SQL Performance
Here is a list of Windows' performance counters to use in monitoring performance of an SQL server. Create Performance Collection rules targeted to a SQL Server computer group…
SQL Server: Find Highest Wait on Server
From Paul Randal's survey of highest wait on server TSQL. WITH Waits AS (SELECT wait_type, wait_time_ms / 1000.0 AS WaitS, (wait_time_ms - signal_wait_time_ms) / 1000.0 AS ResourceS,…