Are you trying to connect to a SQL Server instance and ending up with the error: The certificate chain was issued by an authority that is not trusted You aren’t alone. SQL Server 2005 introduced authentication encryption (by default) in the SQL Native Access Client (SNAC). SQL Server will self-generate a certificate that’s then used... » read more
Child component to parent component communication The parent component assigns a callback method to the child component’s event. In Blazor, to expose an event we use EventCallback. Sources: https://www.pragimtech.com/blog/blazor/pass-data-from-child-to-parent-component-in-blazor/
To pass values from a child to a parent component, see the following. Parent component Child component Sources: https://www.syncfusion.com/faq/blazor/components/how-do-you-pass-values-from-child-to-parent-using-eventcallback-in-blazor https://docs.microsoft.com/en-us/aspnet/core/blazor/components/data-binding?view=aspnetcore-5.0#child-to-parent-binding-with-chained-bind
Availability Groups must retain all transaction log records until they have been distributed to all secondary replicas. Slow synchronization to even a single replica will prevent log truncation. If the log records cannot be truncated your log will likely begin to grow. This becomes a maintenance concern because you either need to continue to expand... » read more
Availability modes There are two availability modes, synchronous commit and asynchronous commit. Selecting a mode is equivalent to selecting whether you want to favor data protection or transaction performance. Both availability modes follow the same work flow, with one small yet critical difference. With synchronous commit mode, the application does not receive confirmation that the... » read more
Example 1 Example 2 Sources:
A partitioned table is one where the data is separated into smaller physical structures based on the value for a specific column (called the partitioning column, which is defined in the partition function). If you want to separate data by year, you might use a column called DateSold as the partitioning column, and all data... » read more
Restore a SQL Server 2008 R2 SP3 (10.50.6560) database to SQL Server 2019 (15.0.2000.5). Note: After restore, the database files are same size as original files.
Convert to JSON object…