sp_change_users_login Maps an existing database user to a SQL Server login. Syntax Arguments [ @Action= ] ‘action‘Describes the action to be performed by the procedure. action is varchar(10). action can have one of the following values. Value Description Auto_Fix Links a user entry in the sys.database_principals system catalog view in the current database to a SQL Server login of the... » read more
Example 1 Example 2 Make sure the following folders are created already. C:\MSSQL\MyDatabase01\Data C:\MSSQL\MyDatabase01\Log Result: C:\MSSQL\MyDatabase01\Data\MyDatabase01.mdf C:\MSSQL\MyDatabase01\Data\fgData_01.ndf C:\MSSQL\MyDatabase01\Data\fgIdx_01.ndf C:\MSSQL\MyDatabase01\Log\MyDatabase01Log_01.ldf
You can schedule the execution of Windows application using Azure WebJobs. Steps Copy .exe and supporting files to a directory. Zip up the directory. Go to Azure Portal -> App Services -> UserApp01 -> WebJobs Add Name NameOfYourJob File Upload Zipped up file Type Triggered Scale Single Instance Triggered CRON Expression Expression Frequency 0 0... » read more
Use .gitignore file to ignore files or folders for Git. Sample file created by Visual Studio.
Sample file created by Visual Studio.
Adding an existing Visual Studio project to Git BitBucket using Sourcetree. Create new repository in BitBucket.org. Create new working folder on local computer. Using BitBucket Sourcetree app, create new project by clone. Clone BitBucket repository (https:// account01 @bitbucket.org/account01/project01.git) to local working folder (c:\git\project01). Add .gitattributes and .gitignore files to root of working folder. Add Files... » read more
There are 2 ways to shutdown an Azure VM, and they are certainly not equal! One way you will still get charged for the compute resources, and the other will free you from paying for the compute resources and help you reduce overall cost. The first method to shutdown an Azure VM, that sounds logical... » read more
Data type Range Storage bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) 8 Bytes int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) 4 Bytes smallint -2^15 (-32,768) to 2^15-1 (32,767) 2 Bytes tinyint 0 to 255 1 Byte Sources: https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-2017
Periodically, you should ensure that changes done by others get incorporated in your local working copy. The process of getting changes from the server to your local copy is known as updating. Updating may be done on single files, a set of selected files, or recursively on entire directory hierarchies. To update, select the files... » read more