Author
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