An indexed collection of technical articles written over the years, covering a range of development and IT topics. These articles provide practical guidance based on real-world experience.
Development Notes
Detailed technical articles on specific development topics. Each article provides working code examples and explains the reasoning behind different approaches.
SQL Injection Attacks: Understanding and Prevention
Comprehensive coverage of SQL injection vulnerabilities, how they work, and proven techniques to prevent them in your applications. Includes examples in T-SQL, .NET, and common frameworks.
Passing Values Between Forms in .NET
Six different approaches for sharing data between Windows Forms, from simple constructor parameters to application-wide settings. Includes comparison table and recommendations.
Spatial Queries in SQL Server
Introduction to geography and geometry data types in SQL Server. Covers creating spatial data, distance calculations, point-in-polygon queries, and spatial indexing.
Troubleshooting Guides
Step-by-step guides for working through common technical challenges. Written for IT professionals, developers, and power users.
Safe Downloads and File Types
How to evaluate file safety before opening downloads, understand risk levels for different file types, and protect yourself from malicious files.
MIME Types and File Extensions
Understanding how MIME types work, their relationship to file extensions, and how to configure them correctly for web servers and applications.
Reference Materials
Quick reference documentation for common tasks and lookups.
File Extensions Reference
Searchable database of file extensions across multiple categories. Each entry includes format details, associated applications, and technical notes.
Legacy Articles
These articles were written for earlier versions of technologies but the core concepts often still apply:
- SQL Injection Prevention – Original article (redirects to updated version)
- Passing Values Between Forms – Original article (redirects to updated version)
- Spatial Queries Introduction – Original article (redirects to updated version)
Article Categories
Browse articles by topic area: