Development Notes
Technical articles on .NET, SQL Server, security, and software engineering practices for professional developers.
About These Articles
These development notes cover specific technical topics encountered in real-world software development. Each article focuses on a particular problem or technique and provides practical solutions with working code examples.
Topics span .NET development (particularly Windows Forms and data access), SQL Server database programming, and application security. The emphasis is on understanding why approaches work, not just copying code.
Articles
SQL Injection Attacks
Understanding SQL injection vulnerabilities, how they work, and proven techniques to prevent them in your applications.
→ .NETPassing Values Between Forms in .NET
Techniques for sharing data between Windows Forms in .NET applications using constructors, properties, events, and more.
→ SQL ServerSpatial Queries in SQL Server
Working with geography and geometry data types in SQL Server for location-based queries and spatial analysis.
→ JSONData Formats: JSON vs XML vs YAML in 2026
Comparing JSON, XML, and YAML for configuration, APIs, and data exchange: syntax, tooling, performance, and best use cases.
→ HTMLHTML vs HTML5: The Evolution of Web Page Extensions
What changed from HTML to HTML5, how .html and .htm files relate, and what developers should know in 2026.
→ MIME TypesUnderstanding MIME Types: How File Extensions Map to the Web
How MIME types work, why they matter for web servers and browsers, and common pitfalls developers encounter.
→ FontsWeb Font Formats: TTF, OTF, WOFF, and WOFF2 Explained
A developer-focused guide to web font file formats: when to use TTF, OTF, WOFF, or WOFF2, and how browsers handle them.
→ CompressionBrotli vs Gzip: Modern Web Compression Methods
Comparing Brotli and Gzip for HTTP compression: speed, ratio, browser support, and server configuration.
→Topics Covered
.NET Development
Windows Forms techniques, data binding, application architecture, and framework-specific patterns.
SQL Server
Query optimisation, spatial data, stored procedures, and database design considerations.
Security
Common vulnerabilities, secure coding practices, and authentication/authorisation patterns.