January 2008 - Posts

5
Comments

Naming Convention for Table Name and Column Name by Kasim.Wirama

Naming Convention for Table Name and Column Name By : Kasim Wirama, MCDBA Naming convention for table and column is necessary to be discussed on this article. You can agree or disagree with what I recommend here, but I have the reason about my recommendation...
Filed under:
0
Comments

Grouping Sets in SQL Server 2008 by Kasim.Wirama

Grouping Sets in SQL Server 2008 By : Kasim Wirama, MCDBA SQL Server 2008 introduces grouping sets features in query construct. What is grouping sets? To answer this question, there is typical example to illustrate this question. Imagine you are requested...
Filed under:
1
Comments

Datetime2, Date, Time, Datetimeoffset data type in SQL Server 2008 by Kasim.Wirama

Datetime2, Date, Time, Datetimeoffset data type in SQL Server 2008 By : Kasim Wirama, MCDBA SQL Server 2008 introduces date and time related data type, separated from datetime data type that exists in previous version of SQL Server 2008. Let’s examine...
Filed under:
0
Comments

I Don’t Care How You Make BuburAyam by Kasim.Wirama

"I Don’t Care How You Make BuburAyam” By : Kasim Wirama, MCDBA Read this sentence carefully and understand this C# code sample after this paragraph. “I don’t care how you create me, what I want is that I get my bubur ayam. All I need to do is to...
Filed under:
0
Comments

Configuring Standard Merge Replication by Kasim.Wirama

Configuring Standard Merge Replication By : Kasim Wirama, MCDBA Another sort of merge replication is bidirectional merge replication. Unlike download only merge replication, bidirectional merge replication synchronize data changes between publisher and...
Filed under:
2
Comments

Merge Replication in SQL Server 2005 by Kasim.Wirama

Merge Replication in SQL Server 2005 By : Kasim Wirama, MCDBA Other type of replication besides snapshot and transactional replication is merge replication. Merge replication is a type of replication that is similar to transactional replication but it...
Filed under:
0
Comments

Peer-to-Peer Transactional Replication by Kasim.Wirama

Peer-to-Peer Transactional Replication By : Kasim Wirama, MCDBA Another kind of transactional replication is peer-to-peer replication. This is new feature of SQL Server 2005. Concept in peer to peer replication is that 2 SQL Server is in equal positions...
Filed under:
0
Comments

Switching Mode between Updateable Transactional Replications by Kasim.Wirama

Switching Mode between Updateable Transactional Replications By : Kasim Wirama, MCDBA In my previous articles, I have discussed about configure standard transactional replication and updatable transactional replication. This article, I would like to share...
Filed under:
0
Comments

Configure Updatable Transactional Replication by Kasim.Wirama

Configure Updatable Transactional Replication By : Kasim Wirama, MCDBA Transactional replication comes with different kinds of choices depending on your business requirement. If your business requirement needs to replication data to subscriber without...
Filed under:
0
Comments

Configure Standard Transactional Replication by Kasim.Wirama

Configure Standard Transactional Replication By : Kasim Wirama, MCDBA Another replication besides snapshot replication is transactional replication. This replication just moves portion of data through transactional log data from publisher to subscriber...
Filed under:
1
Comments

Best Practice Guidance for Data Modelling by Kasim.Wirama

Best Practice Guidance for Data Modelling By : Kasim Wirama, MCDBA Good database design should be come from good data modelling. A DBA should have knowledge for data modelling when he designs database. There are some methodologies regarding to data modelling...
Filed under:
3
Comments

Create Snapshot Publication in SQL Server 2005 by Kasim.Wirama

Create Snapshot Publication in SQL Server 2005 By : Kasim Wirama, MCDBA I have showed you how to set up replication infrastructure by create publisher and distributor in my previous article. By establishing this item, you can create any types of publication...
Filed under:
0
Comments

Configure Publisher and Distributor for Replication in SQL Server 2005 by Kasim.Wirama

Configure Publisher and Distributor for Replication in SQL Server 2005 By : Kasim Wirama, MCDBA In replication architecture, there are publisher, distributor and subscriber. Publisher acts as origins of data, distributor acts as distributes data from...
Filed under:
0
Comments

Replication Agents Role in SQL Server 2005 by Kasim.Wirama

Replication Agents Role in SQL Server 2005 By : Kasim Wirama, MCDBA There are some components working together to replicate data from one SQL Server to another. They are called replication agents. In SQL Server, there are 5 replication agents, some reside...
Filed under:
0
Comments

Difference between Push and Pull Subscription by Kasim.Wirama

Difference between Push and Pull Subscription By : Kasim Wirama, MCDBA From initiator perspective, replication request could come from publisher or subscriber. Replication request that comes from publishers is known as push subscription and the other...
Filed under:
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems