Answer / Mayank Tripathi

TDS Gateway is a component provided by Microsoft for connecting clients to SQL Server databases that are hosted on various platforms, including Azure. It uses the Tabular Data Stream (TDS) protocol to communicate with SQL Server and allows data access using standard tools such as SSMS (SQL Server Management Studio).

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

1 Answers  

---

Explain differences between web edition and business edition?

1 Answers  

---

How many replicas are maintained for each SQL Azure database?

1 Answers  

---

How can we migrate from SQL server to SQL Azure?

1 Answers  

---

How do you migrate data from mssql server to azure?

1 Answers  

---

Explain four layers of abstraction microsoft architectured?

1 Answers  

---

What is function of master database?

1 Answers  

---

What is Federation and Federation Member?

1 Answers  

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

1 Answers  

---

Tell me something about security and sql azure?

1 Answers  

---

When does a workload on SQL Azure get throttled?

1 Answers  

---

How to scale out a federation by Sql statement?

1 Answers  

---