Writing
Resetting Primary Key counter in SQL Server
To reseed/reset the IDENTITY column of an SQL Server table, run the following in Query Analyzer or SQL Server Management Studio: DBCC CHECKIDENT (Table_Name, RESEED, 1) Peace!
VI global search and replace
In case you need to search and replace text globally within vi, here’s the command to do so: :1,$s/old/new vi is a free software screen-oriented text editor computer program written by Bill Joy in 1976 for an early BSD release. Peace! \m/
Outlook 2007 IMAP auto purge option
Just in case you encounter problems permanently deleting e-mails in Outlook 2007 on an IMAP server, make sure you have the Purge items when switching folders while online option checked (see screenshot below). What happened was when I tried deleting e-mails, the e-mails would just have a strikethrough line, but would still be present in…
Top 10 Development Mistakes
I found this list in the Redmond Developer News newsletter, and believe it’s worth mentioning/posting here…because as we all know, there are far too many software development projects that end in abject failure (whether a simple internal app or a massive commercial system). Here are the top 10 that made the list: 1. Never committing…
Bind an XMLDataSource to a GridView control
On one of my ASP.NET 2.0 projects, I had to use an XML file as the data source for a GridView control. The problem was that I had never used this method before. But after doing some research, I found it to be very similar (and straightforward) to binding to a database – with the…