Follow the instructions in the link below for blocking specific IP addresses through IIS

http://blog.lowtek.com/2006/09/how-to-block-ip-address-on-windows.html

You may have noticed in ASP.NET when you do a postback on the page it loses the URL rewriting so something like www.mysite.com/news-article-1 becomes www.mysites.com/news.aspx?id=1

I found a solution to this here http://stackoverflow.com/questions/5191612/asp-net-postbacks-creates-problem-in-url-rewriting

In the Master Page page load event place the following code:

form1.Action = Request.RawUrl;

form1 being the id of your form tag.

Useful MIME types for Microsoft Office documents:

You upload a file to your CMS via your rich text box but you get a 404 error.

The solution to this is Internet Information Services (IIS)


Out of the box, IIS6 only accepts requests for known MIME types. Since Office 2007 was released after Windows Server 2003 and IIS6, IIS6 knows nothing about the new MIME types. So you need to manually add them:

    Open Computer Management. (Right-click My Computer… Manage…)
    Right-click Internet Information Services (IIS) Management… Properties…
    Click MIME Types…
    Click New… and add the following:

Total database size script

SELECT

[SpaceUsed(KB)] = SUM(alloc.used_pages)*8

FROM sys.objects obj

JOIN sys.indexes idx on obj.object_id = idx.object_id

JOIN sys.partitions prt on obj.object_id = prt.object_id

JOIN sys.allocation_units alloc on alloc.container_id = prt.partition_id

WHERE

obj.type = 'U' AND idx.index_id IN (0, 1)

I had a problem with PrettyPhoto not working within an Update Panel.  I found this solution which seems to do the trick:

http://forums.asp.net/p/1468161/3723242.aspx

<script type="text/javascript">
  function pageLoad() {
    $("a[rel^='prettyPhoto']").prettyPhoto();
  }
</script>

Just a method of doing a 301 redirect from non-www to www I came across rather than doing it through IIS
http://www.barrywise.com/2008/10/seo-canonical-urls-and-301-redirects-in-windows-iis-6-iis-7/

        Try
            Dim requestedDomain As String = HttpContext.Current.Request.Url.ToString().ToLower()

            If InStr(requestedDomain, "http://thewebbureau.com") Then

                requestedDomain = requestedDomain.Replace("http://thewebbureau.com", "http://www.thewebbureau.com")

                Response.Clear()
                Response.Status = "301 Moved Permanently"
                Response.AddHeader("Location", requestedDomain)
                Response.End()

            End If

        Catch ex As Exception
            Response.Write("Error in Global.asax :" & ex.Message)
        End Try

Found this script which allows you to order by table size http://www.sqlservercurry.com/2011/02/sql-server-count-rows-in-tables-and-its.html

-- Count All Rows and Size of Table by SQLServerCurry.com

SELECT

TableName = obj.name,

TotalRows = prt.rows,

[SpaceUsed(KB)] = SUM(alloc.used_pages)*8

FROM sys.objects obj

JOIN sys.indexes idx on obj.object_id = idx.object_id

JOIN sys.partitions prt on obj.object_id = prt.object_id

JOIN sys.allocation_units alloc on alloc.container_id = prt.partition_id

WHERE

obj.type = 'U' AND idx.index_id IN (0, 1)

GROUP BY obj.name, prt.rows

ORDER BY [SpaceUsed(KB)] desc 

In a class you need to declare a session slightly differently:

HttpContext.Current.Session("SessionName")

This error message will occur when there is an invalid email address in the App_Data\Newsletter.xml file.  This XML file contains email addresses of people who have signed up for the Newsletter (via the Newsletter widget).  When you save a post, all the people in that file are sent an email.  If an invalid email address exists, it will throw this error message.

If you remove any invalid email addresses from this XML file you may need to restart the blog for your changes to be detected.  To restart the blog, simply modify the web.config file (e.g. add a space).

SQL Server has a system stored procedure you can run called sp_who that will provide you with information on the current SQL Server userse and processes.  This can be filtered to return processes that are not idle.