If you need to automatically redirect HTTP to HTTPS in IIS. You can use the help of the URL Rewriter plugin in IIS.

If you need to truncate a table content in TSQL. You can use the built-in function called TRUNCATE.

If you need to apply a sign out link in ASP.Net Core page. You can utilizie the built-in method under HttpContext.

If you need to get the webroot path in Web API in ASP.Net Core. You can utilize the IWebHostEnviroment interface by inheriting it in your Web API class controller.

If you need to generate a thumbnail image from a stream source. You can use a library called DotCommon.ImageUtility.

In the previous article, we have already provided a quick method on how to generate a thumbnail from an image. In this article, we are going to provide a method to perform an image resize.

If you need to convert string to char array you can use the built-in function in the string library called ToCharArray.

If you need to convert a char array to string in C#. You can use declare a new string and pass the char array in the string constructor.

If you have a group of radio buttons and want to bind and set a radio button to be checked. You can perform a condition against the checked property value of the radio button.

If you have a database backup .bak file extension and want to restore it using SQL query. You can use the built-in 'RESTORE DATABASE' function. Remember in order to be able to restore a database successfully. You need to be a database owner which has the role of db_owner. You also need to ensure that there is no open session use the database.

If you need to back up a database using SQL query in SQL Server. You can use the built-in function called 'BACKUP DATABASE'.

In this article, we going to learn how to update a table with join another table in SQL Server.

In this tutorial, you will learn how to set the default value of a select combo box in VueJS. We are going to populate a dataset of a dropdown select by creating an array of objects. In this example, we going to populate a fruit object contains the property of an Id and Name.

We are going to create a really simple VueJS application to showcase a button click event handling in VueJS.

To get the information about how much space or size used by tables. You can retrieve the size information by linking multiple tables in sys tables. There are two tables that hold this information. The first one is the sys.partitions table. You can get the no of rows created of a table. The second will be the sys.allocation_units table which will return the information of used_pages info.

If you need to get all user-created tables in SQL server. You can use it by retrieving the table information under sys.Tables.

If you need to rename a column of a table in TSQL. You have to use the built-in function 'sp_RENAME'.

If you need to add a new column in TSQL. You need to use the keyword function 'ALTER TABLE'. It is recommended you perform a check if the proposed column you want to add is not already existed in the database table otherwise you will receive an error message.

GUID stands for Globally Unique Identifier. It is a universally unique id using a pseudo-random 128 bit number. GUIDs are mostly used to replace as another alternative or replacement of integer value. It is preferable to compare with numbers because it is unique across tables, databases, and servers. The drawback is it contains 4 times larger than the traditional 4-byte index value.

If you need to find out which tables have been recently modified. You can check this by querying the sys.tables in TSQL based on the modify_date column.

If you want to retrieve the latest modified stored procedure in TSQL. You can query the latest changes by looking into the sys.objects table with column type equals to 'P'.

Inside the INFORMATION_SCHEMA table, there is a table called TABLE_CONSTRAINTS which hold and store all the Foreign Key constraint.

If you need to delete or drop a stored procedure in TSQL. You can use a built-in function called DROP. It is recommended that you perform a check to see if the stored procedure you want to delete does exist in the sysobjects table.

If you want to have a sequential number against a row in SQL Server record. You can use the number function called ROW_NUMBER.

To delete If you need to delete all non-system functions in TSQL. We need to look against the sysobjects and looking for the type value under 'FN', 'IF', 'TF', 'FS', and 'FT'.

A Guid is a 16-byte binary data type TSQL. This data type can be used as another alternative unique identifier for a record. Usually, we use numbers for the primary key. But on some occasions, if we want to make it harder for users to guess the primary key we can use this Guid type alternative. For example: If we have a user table with a primary key integer. If we want to do a query against it we can easily pass any integer number. But with Guid type, it will be a bit hard to guess. So this can be a good choice if you want to build a better application.

If you need to get the returned GUID uniqueidentifier after inserting a record. You cannot use the method  SCOPE_IDENTITY() to retrieve the value. What you can do is by creating a temporary table in TSQL as a variable table and then perform output to insert the column Guid into the table variable.

In this tutorial, we are going to learn how to populate the content using the VueJs template. We will use a for loop method to read the array of a product list and bind it to the UL LI HTML list.

Learn how you can delete a column of a table in TSQL. Before deleting a column, it is always recommended to check if a column does exists in a table. This is to ensure the process of deleting is working fine.

If you do not want to use the IF condition in TSQL. You can use the Switch Case which is more structured organized.