EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

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
SSPI handshake failed

Error SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed Alert SQL Server Log

0
Read
echiang