You can create the user in Microsoft ...
By default ASP.NET Core Identity system has string data type for primary key. We are often use to with int data type as primary key.
Here is the very good article from Microsoft documentation team on this topic.
Please click here to read the article
Sometime we need to do undo checkout from other user’s workspace in Team Foundation Server (TFS). Here is the procedure to do it using Visual Studio’s Command Prompt.
Open the Visual Studio Command Prompt and type the following command:
tf undo /workspace:"WorkspaceName;WorkspaceOwnerName" $/Project/SomeFile.aspx
Replace the workspace and workspace owner’s name and also path of the file to undo checkout.
You must have “Undo other users’ changes” permission to perform this. When you will execute this command it might prompt for your TFS credentials (if those were not saved/remembered).
Tip: You can use the above command to undo checkout a file from your own workspace.
Tip: To get the workspace and owner names and file path, try to check out the same file in Visual Studio it will provide this information in output window, copy from there and replace in the above command and execute it.
Tip: You can undo check out all the files in project or specific directory by add /recursive parameter in the command, please see the example below:
tf undo /workspace:"WorkspaceName;WorkspaceOwnerName" $/Project /recursive
tf undo /workspace:"WorkspaceName;WorkspaceOwnerName"...
Recently we were in a situation where we need to merge data from our offline version of application with online database.
We planned to use uniqueidentifier as data type for ID columns instead of int (auto identity).
But when we looked at reviews a lot ...
Hosting providers unload your application after certain amount of time if the application is idle. Microsoft Azure provide Always ON option (with some extra cost) to keep the application always running. You can enable these settings from Azure Portal as ...
DateTime.Now returns the time by taking into account server’s time zone on which application is hosted. As Azure web apps has time zone set to UTC even its location is somewhere else say in central US.
When we try to access the server’s time ...
In this article we will see how to take Microsoft SQL Server database backup to Azure storage. At high level, we have to do the following to achieve this:
- Create storage account in Microsoft Azure
- Create container in Azure storage account
- Create SQL Server credential using information from Microsoft Azure storage account
- Taking backup using Microsoft SQL Server Management Studio
- Taking backup using SQL code
1. Create storage account in Microsoft Azure
Login to Azure Portal. Create a storage account. To add a storage account, click on the Storage accounts on left and then click on +Add option on top.
It will show the following options, fill in all the details but remember to select General purpose under Account kind, it is circled in the image, otherwise it will give error while taking backup.
2. Create container in Azure storage account
Once storage account is created, we need to create a Container which will keep the database backup files. To add a container, click on Storage accounts, all the storage accounts in your Azure account will be shown. Click on the newly created storage account to open its properties. Click on Containers then on +Container, give the name and click OK as shown in the image below:
3. Create SQL Server credential using information from Microsoft Azure storage account
Use the following SQL code to create credential to use while taking backup.
use master; CREATE CREDENTIAL AzureBlobStorageCredential WITH IDENTITY = 'storageaccountname' , SECRET = 'storage account access key';
AzureBlobStorageCredential: Name of this credential, you can name it any.
IDENTITY: It is the Azure storage account’s name as shown in the image below.
SECRET: It is the storage account’s access key as shown in the image below.
4. Taking backup using Microsoft SQL Server Management Studio
Right click on the desired database, click on Tasks and the click on Back Up…
Make the selections/changes on Back Up Database dialog as shown below:
5. Taking backup using SQL code
Use the following SQL code to take database back up to Azure Storage
Declare @BackupUrl AS NVARCHAR(max) = N'https://stoarageaccountname.blob.core.windows.net/containername/backupfilename.bak';...