Pressing the Red Button

SQL Server Synonyms and Linked Servers

Here is how you can create a synonym to a linked server in SQL Server 2005/2008: CREATE SYNONYM LinkedTableA FOR ServerName.DBName.dbo.TableA SELECT * FROM LinkedTableA Some Background: What are Synonyms? They are a minor feature added in SQL Server 2005. They are used to create an alias (or easy to remember name) for a server […]

Continue reading...

ATM running Internet Explorer

Who would of thought there were ATMs out there running IE? I couldn’t not post this. I swing by this bank on the weekends because it is convenient but their ATMs are always broken. So when they recently replaced the old ATMs with these nice shiny new ones I thought I was set. They worked […]

Continue reading...

Reviving Metabuilder’s DualList

Update: Metabuilders.com updated their controls for Net 2.0! Metabuilders had a free ASP.Net web control (with source) called DualList (or DynamicListBox) that worked really well in ASP.Net 1.1. I wanted to use it in 2.0 but there are some minor fixes needed in the code. Here is summary of the fixes I found here and […]

Continue reading...

Laptop Cooling – A Worst Case Scenario

After experiencing frequent cpu slow downs on my Dell Inspiron 9100 Laptop, I went frantically searching for fixes. The fix: the fan exhaust vents were severely clogged. Included are some pictures to show just how extreme a case it was. I half-jokingly wonder if this would have caused my laptop battery to explode. The Inspiron […]

Continue reading...

SQL Hacks: Sequentially Numbering Records

It is a simple concept, I want each record of a SQL result set to be numbered 1 through X. Well SQL wasn't really designed to do this so here come some the ugliest hacks you'll every see to "just get it done". Here is some more background. I got contracted to write some fixes […]

Continue reading...