I believe I have a pretty high tolerance for inconveniences but I just couldn't take it: running Windows Server 2003 as a primary OS on Macbook blows.

As a fan of Unix, Windows and beautiful UIs, I promised myself I would put down any amount of money for a small Macbook the day it came out and I did just that. Then I …

As a compliment to my MaxMind GeoIP Locator scripts and the parse top-level domain from URL function, I've created another function to parse the search term from an URL.

I've heard that T-SQL is a bit slow with parsing strings and wanted to test this myself so I created this in both C# and T-SQL. The difference is very …

I found this useful security tip on Microsoft.com.

SAFE is the recommended permission setting for assemblies that perform computation and data management tasks without accessing resources outside an instance of SQL Server.

We recommend using EXTERNAL_ACCESS for assemblies that access resources outside of an instance …

Here's some code that I'm posting mainly for my future reference. I do not recommend running this anywhere near a production machine.

DECLARE @SQL varchar(8000) -- if you use nvarchar for whack table names, change this to 4000 SET @SQL = '' SELECT @SQL = @SQL + 'ALTER DATABASE ' + NAME + ' SET RECOVERY SIMPLE; ALTER …