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 » ]

• Recently Written

  • JohnnyA WordPress malware on MediaTemple
  • Less than percent colon – code render blocks in ASP.NET
  • Essential Freeware
  • Generic List<T> to DataTable using Reflection
  • C# Serialization
  • VirtualBox 3.1 – Install Windows XP Guest on Ubuntu 9.04 Host
  • bubbletip! A jQuery Coda-style bubble tooltip plugin
  • VirtualBox BSOD p3.sys
  • Install Windows XP Guest on Ubuntu 9.04 Host
  • Limiting network file transfer throughput with rsync

• Categories

  • Code Snippits
  • Database
  • Helpful Applications
  • Installs and Configs
  • Malware
  • Scripting

• Monthly Archives

  • July 2010
  • May 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • May 2009
  • February 2009
  • November 2008
  • August 2008