Author

Deploy SSIS to SQL Server

Copy Deployment File to SQL Server File Type Note MyPackage.dtsx Integration Services Package MyPackage.SSISDeploymentManifest Integration Services Deployment Manifest Double click to launch Package Installation Wizard MyPackageInterfaceConfig.xml XML Configuration Document Select “SQL Server deployment” and check “Validate packages after installation” Enter “Server name”, Use Windows Authentication, and “Package path”, check “Rely on server storage for encryption”.... » read more

0
Read
echiang
Error 1069: The service did not start due to a logon failure

Error: Could not start the <service name> service on Local Computer. Error 1069: The service did not start due to a logon failure. Resolution: Service account might be disabled. Try using another service account. Sources: https://www.codetwo.com/kb/troubleshooting-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sent-items-update/

0
Read
echiang
Install SSIS for Visual Studio 2019

https://www.mssqltips.com/sqlservertip/6481/install-sql-server-integration-services-in-visual-studio-2019/ Adding the SSIS Projects extension to the Visual Studio 2019 When Visual Studio is opened, we click on “Continue without code” to add the necessary extension: In this window, we click on “Extensions” > “Manage Extensions”: In the search bar of the opened window, we type “Integration Services” to easily locate the extension. From the appeared list we choose “SQL... » read more

0
Read
echiang
Always On Database Stuck in Restoring State

Issue: Always On database stuck in “Restoring” state after setting up Always On Fix: Go to Always On High Availability -> Database -> “Join to Availability Group” Sources: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/

0
Read
echiang
SendGrid via Web API

CURL: HTTP POST: https://api.sendgrid.com/v3/mail/send Header Header Name Header Value Authorization Bearer <YOUR_API_KEY> Body Example: SendGridEmail.cs Sources: https://docs.sendgrid.com/for-developers/sending-email/api-getting-started

0
Read
echiang
IP Address Lookup API

IPStack https://ipstack.com/ IPAPI.co https://ipapi.co/ Sources: https://www.learmoreseekmore.com/2020/12/users-ip-geolocation-blazorwebasm.html

0
Read
echiang
Blazor WebAssembly Get IP Address

You can use a third party API, such as Ipify, to get the IP address of the current request in Blazor. The script api.ipify will return the IP address in JSON format. But this is a workaround. As of now, there is no way to achieve this. In the following code snippet, the IP address... » read more

0
Read
echiang
SonicWall VPN Clients NetExtender

https://www.sonicwall.com/products/remote-access/vpn-clients/ SonicWall’s SSL VPN NetExtender allows you to provide easy and secure access to Windows and Linux users. This transparent software enables remote users to securely connect and run any application on  the company network. Users can upload and download files, mount network drives, and access resources as if they were on the local network.

0
Read
echiang
TEXTIMAGE_ON

Indicates that the text, ntext, image, xml, varchar(max), nvarchar(max), varbinary(max), and CLR user-defined type columns (including geometry and geography) are stored on the specified filegroup. TEXTIMAGE_ON is not allowed if there are no large value columns in the table. TEXTIMAGE_ON cannot be specified if <partition_scheme> is specified. If “default” is specified, or if TEXTIMAGE_ON is not specified... » read more

0
Read
echiang