SQL 2008 shrink log file size with no_log alternative

Microsoft SQL Server 2008 no longer allows you to truncate the transaction log using the no_log syntax. Essentially, Microsoft decided (arguably correctly) that too many people were “abusing” the statement and doing harm to themselves. [ Read more » ]

SQL Logical Name Change by ALTER DATABASE

Use the following code snippits to identify and rename logical file names in Microsoft SQL Server. [ Read more » ]

Sql Server 2005 “Login name” is blank after restoring from backup

After restoring a database from a remote server backup, the “Login name” is often disassociated. [ Read more » ]

Preserving Whitespace FOR OPENXML

Using Microsoft SQL Server 2005, when you read xml data using FOR OPENXML, whitespace characters are replaced with a single space. After digging through the internet for half an hour, I found a couple options. [ Read more » ]