Ryan Adams sent a test email and it never arrived. He explains why Database Mail breaks when TLS 1.0 is disabled and how he tracked down the cause.
SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)
SQL Agent would not start in a cluster and SQLAgent.OUT said SQL Server Agent terminated (normally). Here is what the log showed and how I fixed it.
SQL SERVER to Oracle Numeric Datatype Mapping
An app moved from Oracle to SQL Server slowed down under load. Here is what I learned about Oracle numeric datatype mapping while tracking it down.
SQL SERVER – Maintenance Plan Folder Missing Under Management in SQL Server Management Studio
A reader wanted scheduled backups on SQL Server 2016 but found the Maintenance Plan Folder Missing under Management in SSMS. Here is my answer.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
SQL SERVER – FIX – Linked Server Error 7399 Invalid authorization specification
Creating a linked server with just a server name can fail with Error 7399, Invalid authorization specification. Why the Linked Server test fails and the fix.
Changing a User-Defined Table Type That Procedures Use
You need one more column in a table type, but procedures depend on it. Here is the order of moves that works, with the errors along the way.