Introduction A common and useful feature in SQL is the ability to use a "SELECT FROM a SELECT" query, often referred to as a subquery or inner query. This post…
Understanding the SQL “SELECT FROM a SELECT” Query
The SQL Like Command
Introduction The SQL LIKE command is used in a WHERE clause to search for a specified pattern in a column. It's commonly used in string comparison to find matches in…
Testing Date Pickers with Playwright and TypeScript
Introduction Date pickers are essential in web applications for easy date selection. They vary in how they work across different browsers, devices, and new versions. Also, each development environment and…
Automating Dropdown, Textbox, and Checkbox Interactions in TypeScript
Introduction In web development, comprehensive automated testing plays a crucial role in ensuring the quality and reliability of applications. Playwright, a versatile end-to-end testing framework, empowers developers to automate web…
SonarLint for C# Developers: Enhancing Code Quality and Productivity
Introduction To ensure the robustness and reliability of C# applications, developers employ various tools to identify and address potential issues early in the development cycle. Among these tools, SonarLint has…
K6 – The Modern Load Testing Tool for Agile Development
Introduction In software development, performance testing plays a crucial role in ensuring the stability and reliability of applications. Among the various tools available for performance testing, k6 stands out as…
Keeping Your Git Repository Tidy: The git clean Command
While Git excels at tracking code modifications, it's crucial to maintain a clean and organised repository to ensure efficient workflows and avoid potential conflicts. This is where the git clean…
Demystifying the SqlPackage.exe Command
Introduction As a SQL Server professional, you're likely familiar with the concept of database deployment and the tools that facilitate it. Among these tools, SqlPackage.exe is a versatile command-line utility…
Resharper
Introduction I have used Resharper, a Visual Studio plugin, for over ten years. ReSharper is a powerful and versatile tool that enhances the development of C# and ASP.NET applications. It…
Visual Studio Macros
Introduction Macros, once a staple feature of Visual Studio, were deprecated in Visual Studio 2017 due to security concerns. However, the need for automation remains, especially for repetitive tasks that…