jnPiyush
Publisher on askill
Develop SQL Server databases with T-SQL, stored procedures, indexing, and performance optimization. Use when writing T-SQL queries, creating stored procedures/functions, designing index strategies, op...
Implement production security practices covering OWASP Top 10, input validation, injection prevention, and secrets management. Use when hardening applications against vulnerabilities, implementing aut...
Write effective documentation including inline docs, README structure, API documentation, and code comments. Use when writing README files, documenting APIs, creating architecture decision records, ad...
Build frontend UIs with HTML5, CSS3, and Tailwind CSS following accessibility and performance best practices. Use when creating responsive layouts, styling with Tailwind CSS, implementing accessible f...
Production testing strategies including test pyramid (70% unit, 20% integration, 10% e2e), xUnit, FluentAssertions, Moq patterns, and 80%+ coverage requirements.
Design scalable systems with horizontal scaling, load balancing, caching, message queues, and stateless service architecture.
Effective Git workflows including commit conventions, branching strategies, pull request best practices, and merge conflict resolution.
Manage project dependencies securely with lock files, version pinning, security audits, and update strategies for NuGet, npm, and pip.