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.
SQLAuthority News – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005
The SQL Server Management Pack for Microsoft Operations Manager 2005 monitors SQL Server 2008, 2005 and 2000 for availability, configuration and performance.
SQLAuthority News – Find Your IP Address – What Is My IP Address
My developers often need to know their live IP address as seen from outside. I added a simple page to my site that shows your outgoing IP address.
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.
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.
SQL SERVER – 2005 – Best Practices Analyzer (August 2008)
The August 2008 release of SQL Server 2005 Best Practices Analyzer (BPA) checks your Windows and SQL Server settings against Microsoft best practices.
SQL SERVER – XML – Split a Delimited String – Generate a Delimited String
Two XML articles by my friend Jacob Sebastian show how to split a Delimited String and build one with FOR XML PATH, which can do more than COALESCE.
SQLAuthority News – Tip of the Minute
My personal website has a new Tip of the Minute section that shows a fresh SQL Server tip on every refresh. A few sample tips and a small challenge inside.