Install SSRS Report Template in Visual Studio 2019
Install Microsoft Reporting Services Projects https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPPBIProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
XACT_ABORT and Transaction
Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error. The THROW statement honors SET XACT_ABORT. RAISERROR does not. New applications should use THROW instead of RAISERROR. When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled... » read more
Begin Tran with Error
Transactions are intended to run completely or not at all. The only way to complete a transaction is to commit, any other way will result in a rollback. Therefore, if you begin and then not commit, it will be rolled back on connection close (as the transaction was broken off without marking as complete). As... » read more
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
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: