My Simple Talk article on ANTS Profiler and Performance

A couple of weeks back, RedGate/SimpleTalk contacted me for a short article about ANTS Profiler. I've been using it for sometime and has definitely been very useful so I won't think twice about recommending it. Here's the link (below) and please do drop by to read it. Feel free to rate/comment Using a profiler to ...

language translation for this site

To be able to share to a wider audience I have placed Google Translation gadget at the upper left side of these pages. [more] I'm a frustrated linguist and I will try my best to write in a way that will likely to produce correct translation but forgive me if I don't. Hopefully soon I ...

Suspected Trojan or Virus qxty9be.cmd

Suspected Trojan is messing up my PC at this very moment[more] I attached my portable drive to a computer that didn't have antivirus today. The computer was working fine (at least as it seems) but I found a certain "autorun.inf" and "qxty9be.cmd" in that diks afterwards. I scanned the disk and Symantec didn't see anything! ...

GoDaddy IIS7 DotnetNuke Joomla WordPress

UPDATE (2/2/09): GoDaddy even on deluxe/premium/unlimited hosting accounts, applications (eg. .NET application root) is configured as virtual directories. Thus the ApplicationRootPath is still rooted on the ROOT of the hosting disk space. This makes sense I think and so even if domain points to say ROOT/subfolderA, Response.Redirect("~/Page.aspx") will still point to <domain>/subfolderA/Page.aspx and it will ...

BlogEngine.NET migrating to IIS 7

This blog running on BlogEngine.NET (and the its parent/main site) is now running on IIS 7 Integrated Mode and would like to share a little of my experience. There were two major issues with I migrated these blog to IIS 7 [more] 1) Server Error in / Application – Request is not available in this ...

remove malicious script tags from file

Here's a small Windows Forms application that I created to automate removal of malicious SCRIPT tags inserted into some web files. [more] (or in general – even non malicious scripts). Of course, you can always do this manually but if we're talking of hundreds or thousands of files, it will be one heck of a ...

WindowsPrincipal.IsInRole doesn’t reflect changes until restart

WindowsPrincipal.IsInRole doesn't reflect changes until restart
Just an observation sometime ago that if you create a new Windows Role and add a user to it and create a WindowsPrincipal using that user, the IsInRole method doesn't reflect the membership change made until a restart is made. [more] For example, given the code below (Console Application project) using System; using System.Collections.Generic; using ...

Address1 vs Address2

What really is the difference between Address1 and Address2 and is it significant? It depends on the country but generally (e.g. US) * Address1 is expected to have Street Number, Street Name, or maybe PO Box. * Address2 refers to Apartment, Floor, Suite, Bldg # or more specific information within Address1 (or to supplement) NO, ...

caution in dropping a temp table before creating it

Recently I ran into a script instead a stored procedure IF OBJECT_ID(tempdb..#temp1) DROP TABLE #temp1 Basically, the object of this script is to check if #temp1 (regular temporary table) exists. If so drop it. However, I think it can have unintended consequences and maybe safer not to include. [more] Say you have a script that ...

temp table (#), global temp tables (##) and @table variables

I've been working "full-time" on TSQL scripts for the past month (no with .NET windows/web apps) and mostly on optimization. And I feel that I should share with everyone this article about temp tables and table variables and some of my own notes. Go read the article below then you may come back here. Take ...