Get Ancestor and Descendant IDs or info using SQL 2005 Common Table Expressions

Need some recursive processing in TSQL (SQL Server 2005)? Needed some TSQL code again to retrieve descendant and ancestor entries in a self-referencing table. I've done this a couple of times already and although I can write on top of my mind, sometimes you just want to make life easier and have a script you ...

Lost Internet Access due to ZoneAlarm and Microsoft Update KB951748

I ran into this issue a while ago where I lost internet access connection after installing a windows update and turns out to be because of my ZoneAlarm installation. [more] Overview: Microsoft Update KB951748 is known to cause loss of internet access for ZoneAlarm users on Windows XP/2000. Windows Vista users are not affected. Impact ...

LINQ to SQL and Visual C# Developer Express Data Source Connections


Warning: getimagesize(/home/oldsite/public_html/wp-content/uploads/files/C%23+Express+Data+Source.gif): failed to open stream: No such file or directory in /home/oldsite/public_html/wp-content/themes/montezuma/includes/thumb.php on line 115
LINQ to SQL and Visual C# Developer Express Data Source Connections
While I was evaluating a couple of things including LINQ to SQL (or L2S to some) for a small website I tried to look into whether it was possible to have the LINQ to SQL classes on a separate project (eg. DAL) rather than the website itself. [more] Since Visual Web Developer Express Edition (you ...

Investing in a Quality Programming Chair

Been quite busy lately work and off work (research ofcourse primarily in urlrewriting) but I couldn't help but notice and comment on a post from CodingHorror/Jeff Atwood on this topic [more] Read his post on Investing in a Quality Programming Chair I could very much relate to this (not to mention that somehow I'm particular ...

Link: Sandcastle Source Code published in Codeplex

After some issues regarding the license and terms of SandCastle in CodePlex, the project is now again available at CodePlex; this time with source code and not just the executable and documentation. You can read more on this at this SandCastle blog post : Sandcastle Source Code published in Codeplex Or go directly to their ...

Link: Flash can now be indexed by search engines

Flash can now be indexed by search engines…[more] For most people on the Web, if Google or Yahoo cannot find something, it doesn’t exist. That has been one of the biggest drawbacks to creating a Website or application that displays itself as a Flash (SWF) file. Search engines could see the file, but they could ...

FREE MCTS SQL Server 2008 DBA 71-432 and BI 71-448 beta exams

SQL Server 2008 Beta Exams Extended, Open Invitation. [more] All SQL Server developers are invited to take the following beta exam for free. 71-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance – this is the successor of 70-431 (for SQL 2005) use promo code for 71-432 = 943F6 71-448: TS: Microsoft SQL Server 2008, ...

The Microsoft Source Code Analyzer for SQL Injection tool

Microsoft released The Microsoft Source Code Analyzer for SQL Injection tool (for ASP code) is available to find SQL injection vulnerabilities [more] The Microsoft Source Code Analyzer for SQL Injection tool is a static code analysis tool that helps you find SQL injection vulnerabilities in Active Server Pages (ASP) code. This article describes how to ...

Busby SEO Challenge World Cup

There is a "buzz" in the internet about this Busby SEO World Cup Challenge sponsored by Busby Web Solutions based in Australia. The key phrase is "BUSBY SEO CHALLENGE". No I'm not joining, read along [more] I noticed when I was looking at one of local blog directories that this blog is listed in and ...

Free Foundations of Programming Book by Karl Seguin

Came across this Foundations of Programming Book by Karl Seguin (ebook actually) when I looked into CodeBetter.com It contains articles that were previously posted on the site and I had the chance to scan/skim over it and wow, I’d have to say this is a must read for developers at any level (probably even the ...