About

I am Alex Feng, working as a SQL Server DBA in Alibaba Cloud Computing. You can contact me via Email/MSN: alex_feng (at) live (dot) com.

Advertisements

3 Responses to About

  1. hoterran says:

    牛阿,全英文博客~~~~

  2. Aniket says:

    Hello Alex,

    Nice blogs on SQL server administration. I had some questions about Replication

    I have a Source system which is providing Real time production data on the equipments at the Mine. Some tables are unloaded and loaded again, some tables are updated , some table deleted a slot and reloads. I am using T-SQL to bring the data from these tables to a staging area. For such a scenario which replication should I use as I am copying the exact same data of the source to the stage. Currently I employ methods to check latest timestamp record at staging and bring from source only those records which are greater than timestamp. Also for code table I use “truncate insert into ” mechanism.

    Please advise me on this

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s