ROW_NUMBER() and PARTITION BY in SQL Server 2000
6 Jan 2012 6:13pm GMT Here is the below SQL for SQL Server 2000 to select the latest version of a record grouping by a single column. SELECT * FROM ( SELECT *, ( SELECT COUNT(*) FROM MyTable AS counter WHERE counter.PartitionByColumn = MyTable.PartitionByColumn AND counter.OrderByColumn >= MyTable.OrderByColumn ) AS rowNumber FROM MyTable ) AS r1 WHERE r1.rowNumber = 1 [...]
Mounting a partition from a Whole Disk backup
5 Mar 2011 12:00pm GMT While backing up a family members hard drive (due to virus infestation), I realized I had backed up the entire drive instead of the partition containing their files. Instead of going through the backup routine again, I thought it would be useful to describe how I was able to mount the partition I wanted to [...]
Kubuntu 9.04, KDE 4.3 and Quanta Plus 3.5
5 Sep 2009 12:30pm GMT After upgrading to Kubuntu 9.04 and KDE 4.3, Quanta Plus was removed due to file dependencies not being met. To resolve the issue, perform the following steps (any 32 bit versions will need to find these packages built for 32 bit systems). wget http://launchpadlibrarian.net/17069296/kxsldbg_3.5.10-0ubuntu1_amd64.deb wget http://launchpadlibrarian.net/17069294/kommander_3.5.10-0ubuntu1_amd64.deb wget http://launchpadlibrarian.net/17069293/klinkstatus_3.5.10-0ubuntu1_amd64.deb wget...
Wilkin Baby Email Announcement
6 Jun 2009 11:06pm GMT Here is a copy of the email we sent out as an announcement to all friends and family members. Read First, open the Attachment second No peeking! We mean it! We recently received news that is going to not only change our lives but likely everyone who is included in this email. Due to it [...]
Local Printer Support via RDP (Remote Desktop)
28 Jan 2009 12:39am GMT For those wanting to support a local printer connected to their Linux system via RDP (Remote Desktop) connecting to a Windows server, here is a quick how-to. First look up the Printer Name on your Linux box, it is best if it is a single word and under 20 characters. You can typically find this [...]