Encrypting connections to SQL Server requires a trusted certificate, careful Force Encryption rollout, and tests with real drivers.
SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
Login failed, not associated with a trusted SQL Server connection? I hit it between SQL Server 2008 and 2005 and fixed it with a matching Windows user.
SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan
Here is what I found about WITH ENCRYPTION and execution plan: an encrypted SP hides its actual execution plan too. Two sample SPs show it.
SQL SERVER – DECLARE Multiple Variables in One Statement
Yes, you can DECLARE multiple variables in one statement in SQL Server. Compare both methods side by side: one statement per variable, or all in one line.
Tracking Job Failures Across Servers
Tracking job failures across servers takes a daily msdb report, a central instance list, and notifications that reach someone who can act.
Slipstreaming Updates Into a New Install
Slipstreaming Updates lets SQL Server Setup apply a selected CU during installation with UpdateSource and avoids a separate patch pass.
Splitting Full Names Into First, Middle and Last in T-SQL
Try splitting full names with T-SQL string functions, preserve token order, and flag suffixes or compound surnames for review.