EugeneChiang.com

Drop Constraint

Azure Function Trigger Expression

Expression Description {rand-guid}.txt GUID string {DateTime}.txt DateTime string

Copy Data from PROD to DEV

PROD DB -> Localhost DB -> DEV DB Create database on Localhost On Localhost, create Linked Server to PROD DB Copy data from PROD DB to Localhost DB Once the data is in Localhost, create a SQL backup of the Localhost database Copy the backup file to DEV DB and restore the database to DEV... » read more

Windows Check Disk Space Usage

Settings -> System -> Storage -> Select a Drive Storage Usage will tell you how much space you are using broken up by category. You can also enable “Storage Sense” to automatically free up space by getting rid of files you don’t need, like temporary files and content in your recycle bin.

Syncfusion Form Field Mask

https://blazor.syncfusion.com/documentation/input-mask/getting-started/ Original Text Field Phone Number

Syncfusion Theme Studio for Essential JS 2

https://ej2.syncfusion.com/themestudio/?theme=bootstrap4 Generated Files: bootstrap4.css bootstrap4.min.css bootstrap4.scss settings.json Examples:

Form Field Alignment using CSS

Using Bootstrap4.css

Run CMD Shell with TSQL

Note: By default XP_CMDSHELL is turned off, to enable XP_CMDSHELL run the following on the database server…

Visual Studio All Packages Yellow Triangle Warning

Issues: All Packages show the Yellow Warning icon. Fix: Got to Package Manager Settings and click on "Clear All NuGet Cache(s)" Go to Package Manager Console… Sources: http://pratikvasani.github.io/archive/2016/02/24/Nuget-package-reference-issues/ https://stackoverflow.com/questions/46833402/what-do-yellow-warning-triangles-mean-on-dependencies-in-visual-studio-2017

Custom Grid Command Button

Example Icons https://blazor.syncfusion.com/documentation/appearance/icons/