I came across this video on Steelso’s blog. Totally amazing although possibly a bit cruel having species that are used to migrating thousands of miles stuck in a giant fish tank.

After thinking my website worked perfect on all browsers, IE8 came along and ruined it!! I can't wait for the day that Microsoft are banned from developing web browsers. The common CSS for centering a DIV on IE8 as shown below doesn't work:

#container{
margin:0 auto;}

To solve this you need the following CSS:

body{
text-align: center;}

#container{
margin:0 auto;
text-align:left;
}

Using text-align: center; centers the DIV for IE, and the text-align: left; margin: 0 auto; will align the text to the left, and center the DIV for other browsers.

Hopefully this little tip will prevent some page builders from having a nervous breakdown

I wanted to use code snippets today to avoid writting code over and over again. I have found that the documentation on where to find the Code Snippets Manager directs you at Tools > Code Snippets Manager. If you can’t find it here like I found, heres how you add it to the menu:

• Go to the Tools menu and click Customize.
• Select the Commands tab.
• In the Categories section scroll down until you find Tools and select Tools.
• Search for Code Snippets Manager in the Commands section.
• Drag the Code Snippets Manager icon and drop it onto the Tools menu and close the Customize window.

When working with databases there are certain tasks that you will find you need to perform regularly. One such task that I find I often need to perform is to delete duplicate records from a database. The following code requires that your table has an identity column, that will be used to identify the duplicate records.

DELETE FROM YourTable
WHERE ID NOT IN (SELECT MAX(ID ) FROM YourTable GROUP BY Column1, Column2, Column3)

The ID column in this example is the identity column and Column1, Column2 and Column3 contain the duplicate data that you want to identify.