Event handling is a crucial aspect of any robust application. But when it comes to ASP.NET Web API, confusion often arises regarding the use of event handlers within controllers. Yes, it is possible to use event handlers in ASP.NET Web API controllers. This can be achieved through techniques like Dependency Injection (DI), static classes, or…
When dealing with date information arriving in string format, the date conversion data types become essential. In SQL, date conversion from string to date can be done using functions like CAST or CONVERT (e.g., SELECT CAST(‘2023-12-27’ AS DATE) AS ConvertedDate;). Some databases offer alternatives like PARSE or TO_DATE for converting string dates with specific formats,…
Implementing the Authorization Code Flow with OWIN (Open Web Interface for . NET) is a crucial step in ensuring secure authentication and authorization within web applications. This flow is widely used to grant permissions and access tokens to users and applications securely. By following a few key steps, developers can integrate this flow seamlessly into…
Ensuring smooth database schema changes involves various strategies. Planned maintenance with downtime allows coordinated changes but brings significant downtime and potential disruptions. Blue/Green deployments minimize downtime but pose challenges for evolving schemas. Feature flags decouple functionality deployment, supporting a seamless transition. Canary releases test changes on a subset of clients to detect issues early. The…
Comparing dates without times is a common need when working with SQL databases. Luckily there are several methods and built-in functions to compare dates in SQL without factoring in the time portion But sometimes you just want to focus on the date component for your queries and analysis. This guide will talk about various techniques…
Terraforming allows you to alter the biosphere and atmosphere of planets and transform planets in Stellaris 2.2, unleashing new frontiers and possibilities for your galactic empire. However, terraforming requires care and planning. This comprehensive guide will provide a deep dive into mastering the intricate art of terraforming. Terraforming in Stellaris 2.2 The following is all…
Whether you’re aiming to improve consistency, enable automation, or simplify managing container workloads on AWS, creating Amazon ECS clusters manually can be complex and error-prone. This is where Terraform comes in – offering an automated way to standardise and streamline ECS cluster setup. Here on we will be provisioning a production-grade ECS cluster environment using…
Strings in SQL database can be a mix of Numbers, symbols, and maybe even hidden letters. CHARINDEX(), PATINDEX(), and LIKE operators are used to uncover alphabetic characters within strings. This article will provide a comprehensive guide on different methods to check if a string contains letters in SQL Server. Why and How to Check for…
When it comes to managing your code changes in Azure DevOps, there are various scenarios where you might need to abandon a pull request without merging. Whether you’re working through a web browser, utilizing Visual Studio, or prefer command-line operations through Azure DevOps CLI, we’ve got you covered. In this article, we’ll walk you through…
When working with numbers in SQL Server, there are times when you need values to be rounded down to the nearest whole number. The FLOOR function comes in handy for this task. It’s a tool within SQL Server that takes any number you give it and chops off the decimal part, always returning the largest…