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.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.
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.
Generating Backup Commands for Every Database With STRING_AGG
Use STRING_AGG for generating backup commands with copy-only backups, checksums, safe database names, and dated files for careful review.







