Add Foreign Key Constraint between Two Databases
Drop existing FK constraint and create a new constraint. In the new constraint, use a function check. Function Constraint
Author
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