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.
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.
Installing sqlcmd and bcp on a Clean Machine
Installing sqlcmd and bcp on Windows starts with the current Microsoft command line utilities, then PATH and version checks.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.