EugeneChiang.com

Working with Spaces in Directory in Command Line

In Command Line, use quotes to deal with spaces in directory.

NOLOCK

The default behavior in SQL Server is for every query to acquire its own shared lock prior to reading data from a given table. This behavior ensures that you are only reading committed data. However, the NOLOCK table hint allows you to instruct the query optimizer to read a given table without obtaining an exclusive... » read more

SQL Data Type Check

Disable Job From Script

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.