Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...

At first glance, I was a bit critical of the latest version of the Upgrade Advisor. Well, after going through that painful process, I proceeded onto my upgrade from SQL Server 2005 to 2008 using the ...

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

SQL Server performance is slow. Users are complaining. Your boss wants to know what's going on and what you can do to improve SQL Server performance. Where do you start? Which SQL Server query should ...