Still stuck on Error 40, could not open a connection to SQL server? Here are more suggestions to fix connection problems, beyond my first two articles.
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
Configure Database Mail in SQL Server 2008 in three steps: create a profile and account, configure email, then send email. Video and screenshots included.
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2
Part 2 on Proper Case in SQL Server: a quick script that makes only the first letter of a sentence upper case, and how to do it for a table column.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.
SQL SERVER – Disable All the Trigger of Current Database
Another way to disable all the trigger objects in the current database: a stored procedure by Manish Kaushik that loops over each table and disables them.
Stable Weekday Numbers Without Changing DATEFIRST
Stable weekday numbers use a fixed Monday anchor and negative-safe modulo. Map Monday to one without changing DATEFIRST or session language.