Category: How-to
SQL Server Best Practices
For archival purposes, here’s the location of a ton of white papers for best practices or SQL Server on the TechNet site. Best Practice is a management idea which asserts that there is a technique, method, process, activity, incentive or reward that is more effective at delivering a particular outcome than any other technique, method,…
SQL Injection-proof your integrated SQL search in ASP.NET 2.0
I had forgotten to add SQL Injection prevention logic when I integrated and implemented a SQL search function for my employer’s internal ASP.NET app. So in this post, I’m adding it for archival and sharing purposes. SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of…
The complete guide to Mac/Windows Interoperability
Here’s an excellent post from Lifehacker, the Geek To Live site, that shows you how to make Mac OS and Windows work together in harmony. It covers file sharing, file and application compatibility, file sync and system files, printer and fax sharing, running Windows on your Mac, remote server access, and finally iTunes and your…
Print Screen in Mac OS X under Parallels
If you’re a Mac convert using Parallels to run Windows, you’re probably wondering where the Print Screen (used for screen captures in Windows) OS X is. Well, unfortunately, there’s no exact keyboard stroke for it; however equivalent; however, you can either use a third-party app like SnagIT, or go the smarter route by using the Windows built-in…
Easiest way to install IIS 7 on Vista
By default, IIS 7.0 is not installed on Windows Vista Business or Windows Vista Ultimate, but installing is pretty simple. You can do it via Windows Features in Advanced Options under Programs in Control Panel. However, there is an easier way: Step #1: Run the following command Open up the command prompt and paste the…
Various SQL JOIN reference
One of the trickiest things about learning SQL is mastering how various JOIN statements differ in the ways they combine data from multiple data tables. There are three types of joins: inner, outer, and cross. In addition, there are three types of outer joins: left, right, and full. It can be frustrating trying to keep them…