EugeneChiang.com

AnyConnect: Saving VPN Entries

Go to … C:\ProgramData\Cisco\Cisco AnyConnect Secure Mobility Client\Profile Create or edit xml file xxxxxx.xml Make sure to restart the AnyConnect application for the changes to go into effect.

Windows Performance Monitor

Setup Monitor Data Collector Sets -> New Be sure to “Start” to start recording. Note: Data file will be updated and accessible once the job has been stopped.

Azure Data Factory: SSIS in the Cloud

Today’s landscape for data warehousing is a rapidly evolving space and most of that evolution is happening in the cloud. The cloud has long offered ways to scale analytic workloads for data warehousing with services like Azure SQL Data Warehouse. However, this only solves one part of the data warehousing workload and as the complexity... » read more

SQL Server: Enable Send Mail

Error when using msdb.dbo.sp_send_dbmail: SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for... » read more

WinSCP Error: Error setting the permission and/or timestamp.

Error: Upload of file ‘test.txt’ was successful, but error occurred while setting the permissions and/or timestamp. Resolution: Turn off preserve timestamp setting. Sources: https://winscp.net/eng/docs/message_preserve_time_perm

Error Character ‘%’, hexadecimal value 0x25 is illegal in an XML name

Error: XML configuration file contains illegal characters in xml. Resolution: Escapes or unescapes an XML file removing traces of offending characters that could be wrongfully interpreted as markup. The following characters are reserved in XML and must be replaced with their corresponding XML entities: ‘ is replaced with ' “ is replaced with " & is replaced with & < is replaced... » read more

XML Escape

Escapes or unescapes an XML file removing traces of offending characters that could be wrongfully interpreted as markup. The following characters are reserved in XML and must be replaced with their corresponding XML entities: ‘ is replaced with ' “ is replaced with " & is replaced with & < is replaced with < > is replaced with > https://www.freeformatter.com/xml-escape.html

Create SSIS Catalog Database Error

Resolution: SSIS feature not installed on the database server. Install SSIS to fix the problem.

Example of AlwaysOn High Availability Setup

Setup Availability Replicas – Select Server Availability Databases – Select Database Availability Group Listeners – Select Listeners (optional) Note Two servers setup in Availability Group. One Primary and one Secondary. (Can have multiple Secondary) Secondary setup as read-only. Listener setup as the pointer. Connection string should point to listener. (Optional) On Primary Server, will display... » read more

Read Only Access to Stored Procedure Content