EugeneChiang.com

Return One Record using LINQ

IN and CONTAIN clause in LINQ

Note: Contains is case sensitive.

Enable Windows Task Scheduler History

Set Task Scheduler History Using Windows GUI Open an elevated Task Scheduler (right-click on the Task Scheduler icon and choose Run as administrator) In the Actions pane (right pane, not the actions tab), click Enable All Tasks History Sources: https://medium.com/techygeekshome/enable-windows-task-scheduler-history-996a601a178c

Send .NET App Email via Gmail

Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. Fix: Step (1): smtp.EnableSsl = true; if not enough: Step (2): “Access for less secure apps” must be enabled for the Gmail account used by the NetworkCredential using google’s settings page:

Reporting Services Project Templates for Visual Studio

For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions. Download the Reporting service project templates from Manage Extensions of Visual Studio. Visual Studio -> Extensions -> Manager Extensions Search for “Reporting” and download “Microsoft Reporting Services Projects”.

Reporting Services in SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) is a Microsoft Visual Studio environment for creating business intelligence solutions. SSDT features the Report Designer authoring environment, where you can open, modify, preview, save, and deploy Reporting Services paginated report definitions, shared data sources, shared datasets, and report parts. SQL Server Data Tools (SSDT) is not included with SQL... » read more

Allow Inbound Port for Azure VM

From portal.azure.com … Go to “Networking” section of VM. Add Inbound port rule … Port: xxxxx Protocol: Any Note: There maybe firewall port that needs to be open as well. For this, go to “Windows Defender Firewall with Advanced Security” to add new inbound rule for port xxxxx.

Allow SQL Server Access for Azure VM

From portal.azure.com … Go to “Networking” section of VM. Add Inbound port rule … Port: 1433 Protocol: Any Check List: SQL Server Properties -> Connections -> “Allow remote connections to this server” is checked SQL Server Network Configuration -> TCP/IP is enabled and set to port 1433 Windows Defender Firewall with Advanced Security -> Inbound... » read more

Enable email notification for SQL Jobs

Note: Make sure email profile and account are setup on the SQL Server first. To enable SQL Server Agent job email notification go to … SQL Server Agent -> Properties -> Alert System -> Mail session -> Enable mail profile

Setup Mail for SQL Server to use Gmail

SQL Server Mail Account Setup Server name: smtp.gmail.com Port number: 587 This server requires a secure connection (SSL): Checked Basic Authentication: enter your username and password Google Email Make sure “Allow less secure apps” is set to ON Note: for Google Admin users go to Gmail -> Security -> Less Secure Apps Run the following... » read more