Browse by Tags

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
15 April 08 10:16 PM | ssqa.net | with no comments

Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...

Filed under: sql server, microsoft, best practices, download, service pack, cumulative update, package, releases

SQL Server Integration Services - think about Transactions and Checkpointing?
07 April 08 07:21 AM | ssqa.net | with no comments

Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...

Filed under: sql server, best practices, ssis, setup, package, checkpoint, bol, commit, rollback, dts, ssis package, transaction