Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses
First published on MSDN on Oct 06, 2017 Authored by Kun ChengReviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh SetlemMost people familiar with Azure SQL DB (aka SQL Database) are aware of the firewall setting requirements of SQL DB, which are very important to lock down connections to SQL DB on Azure.
SQL Server Availability Groups in Azure VM setup with AAD Domain Services
First published on MSDN on Feb 23, 2017 Authored by Rajesh SetlemReviewed by: Steven Schneider, Sanjay Mishra, Mike Weiner, Kun Cheng, Dimitri Furman, Arvind Shyamsundar, Mahesh Unnikrishnan, Luis Carlos Vargas Herring and Nimesh NedungadiDeploying SQL Server Availability Groups in Azure VMs typically involved provisioning two additional VMs to host an Active Directory Domain Controller.Connect to Azure SQL Database V12 via Redirection
First published on MSDN on Sep 08, 2016 Authored by Kun ChengReviewed by: Vince Curley, Saurabh Singh, Joe Ponce-Galindo, Murugan Ayyappan, Dimitri Furman, Denzil Ribeiro, Arvind Shyamsundar, Murshed Zaman, Sanjay Mishra, Mike WeinerIntroductionIn the old days of Azure SQL Database (prior to V12), SQL Database used what is called a gateway to proxy all connections and communications between clients and user databases.Resolving DTC Related Waits and Tuning Scalability of DTC
First published on MSDN on May 11, 2010 Authored by Mike RuthruffAuthor: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May, Kun Cheng During a recent performance lab we encountered a large number of waits related to the use of distributed transactions.
