SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Replication Rss

<< Newer    Items 41 to 60 of 288    Older >>
 

Find Transactional Replication Publisher

Finds the publisher, publisher database, and publication that your subscription table is replicated from.  Read more...
By Derik Hammer 2014/06/27 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 442 reads

Find Transactional Replication Source from Destination Table

I wrote this script to help me locate the publisher, publication, published database, and source object for destination tables which might not be named the same or when you are in a large replication topology with dozens of publications.  Read more...
By Derik Hammer 2014/06/25 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 534 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/11/22 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 70,300 reads

Replication

By free mascot 2014/04/04 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,638 reads

Transactional Replication and the Ballooning Log File

A drive on a mission-critical server is reaching capacity, and the new DBA is panicking. How do you approach a ballooning log file that won’t stop growing?  Read more...
By Matthew Pettit 2014/03/27 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 4,493 reads

Replication between SQL Server versions

By Dan Hess 2014/03/19 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,768 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/11/22 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 70,300 reads

Snapshot Agent

By Jagadish Kumar Punnapu 2014/02/17 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,634 reads

Replication

By Steve Jones 2014/01/22 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,572 reads

Understanding Peer-to-Peer Transactional Replication, Part 1

There are times when you need to share tables between servers, where the table may be updated in both places. Peer-to-Peer Transactional Replication gives you the ability to create a solution. I explain the benefits and the downfalls.  Read more...
By John F. Tamburo 2014/01/13 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 4,766 reads

Replication

By free mascot 2014/01/10 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,657 reads

Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works

This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...
By Sebastian Meine 2013/12/18 (first published: 2011/07/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,521 reads

Stairway to SQL Server Replication: Level 4 - Transactional Replication – The Subscriber

The Subscriber is the server where all the changes that are published by replication get delivered to. Every publication needs to have at least one subscriber, but a publication can have many subscribers. This level assumes that you have followed the first three levels and that you have a publication set up, to which you can subscribe.  Read more...
By Sebastian Meine 2013/12/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,332 reads

Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher

The Publisher is the database where all replicated data originates. Each Publisher can have multiple publications defined within it. Each publication contains a set of articles that all need to reside in a single database. Each article corresponds to all or part of a single database object. A single database object can map to an article in more than one publication.  Read more...
By Sebastian Meine 2013/11/20 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,494 reads

Stairway to SQL Server Replication: Level 2 - The Role of the Distributor

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...
By Sebastian Meine 2013/11/13 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,881 reads

Slowly Changing Facts

This article describes a design pattern for storing “effective dated" changes to fact tables.  Read more...
By Mark Murphy 2013/10/18 (first published: 2010/12/22) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 16,890 reads

Replicating A Volume Of Large Data via Transactional Replication

During weekend maintenance, members of the support team executed an UPDATE statement against the database on the OLTP Server. This database was a part of Transactional Replication, and once the UPDATE statement was executed the Replication procedure came to a halt with an error message. Satnam Singh decided to work on this case and try to find an efficient solution to rebuild the procedure without significant downtime.  Read more...
By Additional Articles 2013/10/17 | Source: SQL Server Performance | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,587 reads

Replication: Distribution Agent Monitoring

Learn about the distribution agent and how to identify replication bottlenecks.  Read more...
By Brian Wilson 2013/10/03 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 3,566 reads

The Fundamentals of SQL Server Replication by Sebastian Meine

Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implemen­tation of such a requirement.  Read more...
By Sebastian Meine 2013/09/30 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 6,329 reads
<< Newer    Items 41 to 60 of 288    Older >>
 
Tags
sql server 7 (44)    
miscellaneous (20)    
backup and restore (16)    
maintenance and management (16)    
administration (13)    
sql server 2005 (12)    
t-sql (12)    
stairway series (11)    
configuring (9)    
transactional replication (9)    
blogs (7)    
sql server 2008 (7)    
data warehousing (6)    
programming (6)    
monitoring (5)    
disaster recovery (dr) (4)    
high availability (ha) (4)    
indexing (4)    
lock and connection management (4)    
performance tuning (4)    
strategies (4)    
video (4)    
database mirroring (3)    
peer-to-peer (3)    
security (3)    
sql server 6.5 (3)    
sqlinsider scripts (3)    
visual basic 6 (3)    
ado (2)    
alerts (2)    
availability (2)    
distributed queries (2)    
distribution database (2)    
distributor (2)    
identity property (2)    
mail (2)    
merge replication (2)    
peer to peer replication (2)    
publisher (2)    
replication troubleshooting (2)    
salesforce (2)    
sql server 2012 (2)    
sql server express (2)    
sql-dmo (2)    
transaction log (2)    
64-bit (1)    
agent jobs (1)    
always on (1)    
architecture (1)    
auditing (1)    
backup (1)    
bigint (1)    
books (1)    
checksum (1)    
clustering (1)    
copying (1)    
dbcc (1)    
delete (1)    
development (1)    
distribution (1)    
distribution agent (1)    
distribution clean up distribution (1)    
dts (1)    
ebook (1)    
editions (1)    
editorial (1)    
english query (1)    
error handling (1)    
geo-replication (1)    
install instance (1)    
installation (1)    
integers (1)    
log shipping (1)    
memory optimized tables (1)    
merge replication 2008 (1)    
odbc (1)    
oltp (1)    
openxml (1)    
pal (1)    
partitioned tables (1)    
patrick leblanc (1)    
perfmon (1)    
publication (1)    
recovery model (1)    
remote connection (1)    
rowcount (1)    
scd (1)    
scripting (1)    
scripts (1)    
slowly changing facts (1)    
snapshot (1)    
sql (1)    
sql school (1)    
sql server (1)    
sql server 2000 (1)    
sql server 2008 r2 (1)    
sqlstress (1)    
stored procedures (1)    
subscriptions (1)    
tds (1)    
transparent data encryption (tde) (1)    
triggers (1)    
troubleshooting (1)    
updatable subscriptions (1)    
updategrams (1)    
user defined function (udf) (1)    
windows 2008 (1)    
xml (1)    
xsl (1)