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.
→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.