EugeneChiang.com

Check column does not exist before adding column

Check record does not exist before insert.

Create SQL Login Account Script

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

Create Database Script

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

Azure WebJobs

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

Example Visual Studio Project Git .gitignore File

Use .gitignore file to ignore files or folders for Git. Sample file created by Visual Studio.

Example Visual Studio Project Git .gitattributes File

Sample file created by Visual Studio.

Adding Existing VS Project to Git BitBucket using Sourcetree

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

Properly Shutdown Azure VM to Save Money

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

int, bigint, smallint, and tinyint in SQL Server

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