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