Thanks! Let me think and see if i find any gap in this setup. Can you think of any?

Thanks again! For reindexing, so decision has to be made based on logical fragmentation percent right? So wanted to make sure i have the %Fragmentation for few tables approx 70,...

Thanks! I have seen some places these maintenance  are run daily and other places once a week. My understanding is the decision should be made based on how bad the...

Also integrity check.

Thanks Jeffery. You're awesome! Lets take below scenario and ignore node 4. That means for FCI between Node1 & Node2 i would need 4 servers and AG would be configured...

So you saying  Failover clustering 2 2 node with AG cannot be configured using traditional AG, so it has to be setup with distributed AG? If you can explain one...

Thanks Frederico. So you agree that CDC is similar to SQL Server transactional replication? Since setting up SQL Server replication also requires all tables to have primary key. You mentioned...

Thanks! The goal is not to have a DR System to take all the functionality. Node1, Node2, Node4  would be on Primary site and Node 3 is the only one...

Thanks! Has anyone has any thoughts on Change Data Capture.  The CDC function is, probably similar to the transactional replication.  It is not the same, but it has this feature...

Thanks! SQL Server replication to Oracle would be a good option but going forward Microsoft claims that this will be no longer supported.Any other options?

Thanks Jeffrey. So you have basically 2 node setup for FCI and the 3rd node is just AG for reporting right? No DR then? In my case i will have...

Thanks you guys are awesome! Another thought came in my mind is building our production High Availability AG pair of servers as 2 2 node cluster instead of single node...

Lot of changes in the security model from Sybase to SQL. I was looking for a strategy for manage our servers and databases going forward after migrating to SQL Server....

Simple recovery model. Approx 15 million rows. Unless bulk-logged is faster than simple?

Thanks! I ran some tests first with clustered index in-place and second with clustered index dropped, load the data and add the  clustered index back . Noticed second one is...