tutorial

How to check if an email address exists an is reachable

This is a common occurrence where you receive at least one rejection email with the following Message Delivery Status (or Subsystem), as a result of sending it to a problematic or non-existing address.   So to check if an address actually exists or  ‘receives’ mail you could simply send an email to that address (with the ‘delivery notification’ flag active) …

How to check if an email address exists an is reachable Read More »

How to verify disc health with a smart control (HDD-SSD)

There are many tools to check the health of hard drives, which detect S.M.A.R.T. diagnostic data and report if there are any deterioration or other problems.    SMART stands for “Self Monitoring Analysis and Reporting Technology” and works only if supported/enabled by BIOS/UEFI.   Many times this data has to be taken with precaution, since a ‘passed’ test does not …

How to verify disc health with a smart control (HDD-SSD) Read More »

Connection strings for databases, a practical list with categories

A practical list with the most used connection strings divided into categories:    Microsoft SQL Server 20xx  STANDARD SECURITY  Server=myServerAddress;Database=myDataBase;User Id=myUsername;  Password=myPassword;  TRUSTED CONNECTION  Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;  CONNECTION TO AN INSTANCE  Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername; Password=myPassword;  CONNECTION VIA IP ADDRESS  Data Source=190.190.200.100,1433;Network Library=DBMSSOCN; Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;  ASYNCHRONOUS PROCESSING  Server=myServerAddress;Database=myDataBase;Integrated Security=True; Asynchronous Processing=True;  WITH MARS (Multiple Access Result Set)  Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; MultipleActiveResultSets=true; Access  STANDARD SECURITY  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; …

Connection strings for databases, a practical list with categories Read More »

Share on Social Media
Scroll to Top