Posted by SQL Enthusiast
Article by our editor
This article outlines how to check whether connections to a SQL Server instance are encrypted. Ideally for data security all connections should be encrypted but sometimes this isn’t possible or hasn’t been set up. This article outlines some queries that can be run to check which current connections are encrypted.
Comments (5) • Read full article »
SQL Server agent keeps a log of events in a table, this is used for the ‘View History’ which displays events for a job in the Log File Viewer. This script will delete selected rows from the history table, such as failed job runs.
Comments (2) • Read full article »
More SQL questions »