Browse by Tags

How do I monitor problems with replication?
07 November 09 04:44 PM | ssqa.net | with no comments

When you setup a program or application then you have equal responsibility to monitor the process/problems too. Similar to this monitoring a replication topology is an important aspect of deploying SQL Server replication. As the process is distributed...

Filed under: sql server, replication, bol, monitoring, value, alerts, mode

SQL Server 2008 R2 CTP - BOL : refer to documentation to know what's new!
17 August 09 02:49 PM | ssqa.net | with no comments

In response to the SQL Server 2008 R2 CTP post I have had flurry of emails asking what more they can learn on 'What's New' compared to the existing SQL Server 2008 RTM which has celebrated its first birtday! As a general recommendation I always...

Filed under: sql server, documentaiton, download, msdn, benefits, bol, ctp, best practice, web

Get and test SQL Server 2008 Service Pack 1, check release notes before proceeding!
15 April 09 07:37 PM | ssqa.net | with no comments

In continuation to SQL_Server_2008-ServicePack1_CTP release information it is official that SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition. If you have been involved in SQL 2008...

Filed under: sql server, 2008, microsoft, best practices, download, bol, release notes, slipstream

SQL Server 2008 RTM Books OnLine (BOL), latest and update your local copies
21 August 08 02:23 PM | ssqa.net | with no comments

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as...

Filed under: sql server, microsoft, documentaiton, download, books online, bol

SQL Server 2008 RC0 and 3.5 Compact edition Books Online - download and update your copy
24 June 08 03:22 PM | ssqa.net | with no comments

As in continuation with the latest release of SQL Server 2008 that is Release Candidate , I strongly recommend you update your local copies of SQL Server Books ONline aka BOL. Here is the link to download the latest copy of SQL Server 2008 RC0 BOL - Link_to...

Filed under: sql server, 2008, documentaiton, books online, benefits, bol

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