Browse by Tags

SQL Server 2005 - specific roles for replication agents

Published 22 February 8 2:10 PM | SSQA.net

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...

Filed under: sql server, replication, permissions, best practices, roles, agent, publisher, beginners, distributor, subscriptions

SQL Server replication FAQ and important measures to consider when replication performance is sufferred

Published 7 February 8 9:41 AM | SSQA.net

Here we are going to highlight the majority of tasks you need to perform whenever user complains or you observe about SQL Server Replication performance is affected, adversly. For any performance tuning issues there will be other factors involved including...

Filed under: sql server, performance, replication, snapshot, best practices, agent, publisher, subscriptions, FAQ, schedule

SQL Server Replication - presentation from Scottish Area SQL Server User Group

Published 12 December 7 4:4 PM | SSQA.net

As a part of regular monthly meetings from Scottish Area SQL Server user group [ Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh ] I have given a presentation on SQL Server Replication, type of SQL Server Replication...

Filed under: sql server, microsoft, replication, snapshot, best practices, merge, transactional, beginners, types

MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005

Published 11 December 7 10:11 AM | SSQA.net

Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar...

Filed under: sql server, msdn, technet, replication, best practices, virtual labs, merge, compact edition, mobile, developement