Pressing the Red Button

Resetting Your Password in Vista

Sometimes you need to reset your password. Sometimes you’re lazy and forget to make a windows password recovery disk (yes I’m guilty). So here is the easiest way I found to get back into your system: http://home.eunet.no/~pnordahl/ntpasswd/ You need to be able burn a CD image or copy the contents on to a USB and make it [...]

Continue reading...

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 object. Like a table for instance. Instead [...]

Continue reading...