SQL Server: What I have Learned in April 2011

Dedicated to Unbeaten Hero of SQL Server Community Jacob Sebastian

TSQL Tips & Tricks

SQL Server: Float to Varchar Conversion

SQL Server: Working With Date but With Format of Your Own Choice

SQL Server: Sorting Data in Ascending Order but NULL at the End

SQL Server Basics: TO_DATE() Function in SQL Server

SQL Server: LEN() or DATALENGTH()

SQL Server: Two Misconceptions about CHAR Data type

SQL Server Management:

SQL Server: How to Manage Error Log File on Production Server

SQL Server: How to Read Trace File to Detect Database Detachment

SQL Server: Script to Create Replica of Existing Database User

SQL Server: NULL As Nothing vs NULL As String Value in SSMS

Performance Tuning:

SQL Server: How to Analyze Ad Hoc Queries Workload

SQL Server: High Logical Reads for Strange Worktable

SQL Server Community:

SQL Server: A Query Slow in Application but Fast in SSMS

SSIS: Opportunity to Learn SQL Server Integration