A general misconception when it comes to transaction log management, is that the transaction log gets automatically TRUNCATED (underlined, as I am not saying SHRINKED!!!) when a full database backup is performed. This is completely untrue , and...

J ust being discussing recently the Backup\Restore best practices (related to corruption) and wanted to share some information. SQL Server Backup\Restore in SQL (when actually done directly from SQL, not from a 3rd party application - I come to...

I've posted a blog entry some time ago about Microsoft recommendation for SQL Server SP2 builds: SQL Server 2005 SP2 - Recommended Build ? Last week Microsoft has released a new SecurityBullettin ( MS08-040 - Vulnerabilities in Microsoft SQL Server...

I don't often blog about our team initiatives, but here's one which is very important and we need the most help with. It's like that famous slogan... " every little helps " ;-) Local Software Engineer to race through tropical rainforest on a...

As a second tool to assess your system configuration, today I am going to post about SQL Server BPA (another acronym!) aka SQL Server Best Practices Analyser (better). We have 2 versions available: - one for SQL Server 2000 ( http://www.microsoft...