Author

SSIS Configuration Settings

SSIS configuration settings can be set in 3 different levels… In the SSIS package itself. In the SSIS package configuration section on the server. In the job step configuration section on the server. Note: The settings configured in the job step will overwrite settings set in the SSIS package configuration section. Sample Database Connection

0
Read
echiang
SSRS report definition is newer than Server

Trying to upload a newer version of SSRS RDL file to a older reporting server… Uploading SSRS 2019 to SSRS 2012 server. Error: The report definition is not valid or supported by this version of Reporting Services. This could be the result of publishing a report definition of a later version of Reporting Services, or... » read more

0
Read
echiang
Look for Deleted records in Log File

Look for deleted records in transaction log file. There is an undocumented function called fn_dblog which enables you to read data from your transaction log which contains very informative data about things that are happening in your database.  The function fn_dblog requires a beginning LSN and ending LSN for a transaction.  NULL is the default for this... » read more

0
Read
echiang
jQuery with Blazor

Example 1 index.html Note: Script tags should not be placed inside components because they cannot be updated dynamically. To fix this, move the script tag to the ‘index.html’ file or another static location. MainLayout.razor or in the MainLayoutBase.cs Example 2 Sources: https://www.syncfusion.com/faq/blazor/general/how-do-i-use-jquery-ui-components-in-a-blazor-application https://www.syncfusion.com/faq/blazor/javascript-interop/is-there-a-way-to-access-dom-in-blazor https://stackoverflow.com/questions/54274629/how-to-use-jquery-ui-from-blazor-component

0
Read
echiang