SQL Server Code,Tips and Tricks, Performance Tuning

So we all know that Clippy hasn't made it to Office 2007 but guess what? Clippy is not dead, it's alive! DR. FrankGNUstein has dug ...

Wal-Mart announced that, on January 1, 2007, it will begin offering customers a new discount item - Wal-Mart's own brand of wine. The w...

So this took me most of my lunch hour to figure out the other day. If you have a gridview and you want to apply formatting to a column then ...

If you have a blog hosted on Blog*Spot (Blogger) and you've upgraded to the new version, there's an easy way to backup your blog. Th...

Let's you inherit a table with a column that can contain blanks, empty strings or NULL values. I am saying inherit because surely you wo...

Bob Beauchemin's SSIS whitepapers are now available on Microsoft's website Connectivity and SQL Server 2005 Integration Services htt...

What Happens When You Let a Three Year Old Use Your Computer For 2 Minutes? This (I Spy a bunch of trouble) Shipping Method: Standard Shipp...

Sahil Malik has posted on his blog 10 Tips To Help Your Virtual PC Performance. If you use Virtual PC a lot to test service pack 2 for SQL S...

I brought in John Carpenter’s The Thing to work only to discover that 80% of my co-workers never heard of this movie. This movie is probabl...

Why would you ever store PDF, Doc or Excel files in the database? What is the point? I don't see any advantages only disadvantages Let...

.NET Rocks has made their latest podcast available, this one deals with SQL Server 2005 high availability Allan Hirt discusses the details o...

Sometimes you have to login to your work PC from home over the VPN and after a while for some reason or another you want to restart your PC....

I decided to get back into some web development again, the last time I did this was in October 2001. I have developed in ASP, JSP and ColdFu...

The ASP.NET AJAX PDF Cheat Sheets have been updated for the ASP.NET AJAX 1.0 final release. There are 6 sheets that you can download in PDF ...

In August of 2005 the United States Congress passed the Energy Policy Act, which changes the dates of both the start and end of daylight sav...

ASP.NET AJAX formerly known as Atlas has been released get it here http://ajax.asp.net/

Microsoft SQL Server Database Publishing Wizard 1.0 SQL Server Database Publishing Wizard enables the deployment of SQL Server databases int...

How do you check if auto update statistics is enabled on your database? It is pretty easy to check that, you can use the DATABASEPROPERTY fu...

I emailed a joke(see below) to some friends and one of them replied: "So what you're saying is that I should take a mistress?"...

Since I have nothing interesting or fascinating to say I decided to put some links up to some posts of people who do have something interest...