Development Resources | Colin Mackay

Comprehensive development resources covering .NET frameworks, SQL Server, and modern web technologies.

Last updated: January 2026

A curated collection of development resources, guides, and reference materials built from years of professional software development experience. These resources focus on practical, real-world applications of .NET technologies, SQL Server, and web development.

Developer Notes

In-depth technical articles covering common development challenges and proven solutions. Each article draws from real project experience and provides practical code examples.

Troubleshooting Guides

Step-by-step guides for diagnosing and resolving common technical issues. These guides help IT professionals and developers work through problems systematically.

File Extension Reference

A comprehensive reference for file extensions across multiple categories. Each entry explains the file format, common applications, and technical details.

Topics Covered

These resources cover a range of development topics including:

  • .NET Framework and .NET Core – Windows Forms, web applications, and cross-platform development
  • SQL Server – T-SQL programming, spatial data, performance optimisation, and security
  • Web Security – Input validation, SQL injection prevention, and secure coding practices
  • File Formats – Understanding file types, MIME types, and content handling
  • Development Best Practices – Code organisation, maintainability, and professional standards

About These Resources

This site was originally built using DotNetNuke (DNN) in the mid-2000s and has been updated over the years to reflect current technologies and best practices. The content represents accumulated knowledge from professional development work across various industries.

While some technologies have evolved since articles were first written, the fundamental concepts and approaches remain relevant. Where appropriate, articles have been updated with modern alternatives and current recommendations.

For suggestions, corrections, or technical questions, please use the contact page.