Write-through Caching in ASP.NET Core Simplified
Cache refers to a high-speed memory section which is dedicated for storing and accessing less frequently updated but read data.
How to Lazy Loading Cache in ASP.NET Core
In-Memory Cache refers to a high-speed memory section which is dedicated for storing and accessing less frequently updated but read data.
Docker for Beginners – Docker Container Restart Policies
In a previous article, we have spoken in length about what a docker compose is, and how it can help us in creating customized image builds. let's talk about how we can also further specify how the images when containerized should behave when struck with a termination, aka their "restart" behavior expectations.
Social Authentication in ASP.NET Core – Handling Multiple Login Providers
So far we have seen in details about how we can provide Google and Facebook authentication for a user with each provider having its own configuration and middleware invoked. In general scenarios, one would prefer providing multiple options for user to signin as it can open up multiple sections of audience
Docker for Beginners – Getting Started with Docker Compose
a docker-compose is a command which comes out of the box along with the docker installation, that helps in keeping instructions to run a container out of an image simple without missing out on any instruction which needs to be passed on while creating a container.
What are DQL commands?
DQL or Data Query Language commands are used for querying data from database objects. This is only a single command which can result in records from dbo such as tables, views etc and can be subject to projection.
SELECT [ DISTINCT column_1, column_2 .. | * ]
FROM <table_name>
WHERE <query_condition>
GROUP BY <columns_list>
HAVING <condition>
ORDER BY <columns_list> [ ASC | DESC ]
What are TCL commands?
TCL or Transaction Control Language commands are used to enforce control on transactions within a database object which might result in a change in the state of data within the dbo.
These are:
- COMMIT
- ROLLBACK [ TO save_point_name ]
- SAVEPOINT save_point_name
What are DCL commands?
DCL or Data Control Language commands are used enforce access control to data within the database or database objects.
These are:
- GRANT <previlige_name> ON <object_name> TO <user_name>
- REVOKE <previlige_name> ON <object_name> FROM <user_name>