.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Always On Manual Failover Using Failover Wizard
Right click on the Availability Group, select “Failover…” Select the new primary replica Synchronous commit = No data lost Asynchronous commit = Possible data lost Results Validating failover settings for secondary replica Performing manual failover to secondary replica Completing the role change for secondary replica Validating WSFC quorum vote configuration Note: Run the following on... » read more
Always On Manual Failover Without Data Loss
Manual failover without data loss Use this method when the primary replica is available, but you need to temporarily or permanently change which instance hosts the primary replica. To avoid potential data loss, before you issue the manual failover, ensure that the target secondary replica is up to date. To manually fail over without data... » read more
Always On Configuration for Automatic Failover
2 Server Setup Server Role Availability Mode Failover Mode Connections in Primary Role Readable Secondary Seeding Mode Session Timeout Endpoint URL DB01 Primary Synchronous commit Automatic Allow all connections No Manual 180 TCP://<servername>:5022 DB02 Secondary Synchronous commit Automatic Allow all connections No Manual 180 TCP://<servername>:5022 3 Server Setup Server Role Availability Mode Failover Mode Connections... » read more
View Stored Procedure Permission
If we want to provide view object definition rights to a specific user with the public role on all databases, execute the following query If we want to provide view object definition rights to a specific user with a public role on a specific database, execute the following query To grant View Definition rights to... » read more
Syncfusion Grid – show/hide GridCommandColumn base on the row data
Example 1 Example 2 Sources: https://www.syncfusion.com/forums/155584/i-would-like-to-show-hide-gridcommandcolumn-base-on-the-row-data
Azure Function Add Assembly
The following assemblies are automatically added by the Azure Functions hosting environment: mscorlibSystemSystem.CoreSystem.XmlSystem.Net.HttpMicrosoft.Azure.WebJobsMicrosoft.Azure.WebJobs.HostMicrosoft.Azure.WebJobs.ExtensionsSystem.Web.HttpSystem.Net.Http.Formatting The following assemblies may be referenced by simple-name (for example, #r “AssemblyName”): Newtonsoft.JsonMicrosoft.WindowsAzure.StorageMicrosoft.ServiceBusMicrosoft.AspNet.WebHooks.ReceiversMicrosoft.AspNet.WebHooks.CommonMicrosoft.Azure.NotificationHubs Sources: https://docs.microsoft.com/en-us/answers/questions/107470/how-to-add-reference-to-directives-in-azure-functi.html
Cron Expression
https://en.wikipedia.org/wiki/Cron#CRON_expression Each line of a crontab file represents a job, and looks like this: Example Expression Schedule 0 0 1 1 * Run once a year at midnight of 1 January 0 0 1 * * Run once a month at midnight of the first day of the month 0 0 * * 0 Run... » read more
Azure Function Timer Trigger
run.csx function.json Schedule to run every 5 minutes. CRON Expression https://en.wikipedia.org/wiki/Cron#CRON_expression