There's Something about SQL!

...SQL Server, BI and other Cool Technology... var sc_project=1839145; var sc_invisible=1; var sc_partition=17; var sc_security="180bc290";

July, 2008

  • Full Backups & Transaction Logs Backup

    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...
  • Backup\Restore & Corruption – What is worth to know

    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...
  • SQL Server 2005 SP2 - Recommended Build - Update

    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...
  • Madagascar - We need your Help!

    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...
  • Assess your System (Part 2of3) - SQL BPA

    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...