EugeneChiang.com

XCOPY

The xcopy command is a Command Prompt command used to copy one or more files and/or folders from one location to another location. The xcopy command, with its many options and ability to copy entire directories, is similar to, but much more powerful than, the traditional copy command. The robocopy command is also similar to the xcopy command but has even more... » read more

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