Friday, November 21, 2008

SQL Server 2008 Full-Text Search

Here is an article from TechNet on SQL Server 2008's Full-Text Search capability.

SQL Performace Tuning

Here is an article at SQLServerCentral (free registration required) on SQL Server performance tuning for beginners.

Microsoft Patterns and Practices

Here is a MSDN portal for Microsoft's Patterns and Practices.

Agile Development

Agile Development seems to be a hot topic these days. Here's a pdf on how Microsoft does Agile Development and here is an MSDN portal on Agile Development.

Keeping Your PC Safe on the Internet

In the battle of keeping your PCs safe on the wild and wacky Internet, here are some things that may be of use. SnoopFree Privacy Shield monitors for installed keyloggers. HijackThis scans specific areas of the registry and file system looking for problems. Of course, there are personal firewalls as well. Here are tests and more tests of various personal firewalls. Outpost and Jetico seem particularly worth looking at. Virus Bulletin (free registration required) offers information about viruses, as well as performing comparative reviews of virus scanners. TopTenReviews has a current compative review of anti-virus/anti-malware products in which BitDefender came out on top. F-Secure has had good 'all-in-one's suites covering anti-virus, anti-syware and firewall functionality. Last, see previous posts here and here about safe browsing with Firefox and NoScript.

Wednesday, November 19, 2008

More on Clickjacking

Here is more on Clickjacking, Noscript and safe browsing.

Friday, November 14, 2008

Calling Stored Procedures with one line of .NET Code

This article discusses a method/tool for simplifying your managed code by calling stored procedures with just one line of code many lines of code.

Testing Your DB Code

Here is an article that discusses using the DbFit tool to test your db code--stored procedures and the like.

Clickjacking and Cross Site Scripting Attacks

You may have heard about clickjacking and cross site scripting attacks (XSS). Here is some information on clickjacking, and here is Wikipedia's entry on XSS attacks. Additionally, this talks about Adobe Flash being used to launch attacks. You can use NoScript and Firefox to at least partially mitigate the problem. Note for maximum protection you must enable NoScript's “Plugins|Forbid <iframe>” option.