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.Looking deeper into SQL Server using Minidumps
First published on MSDN on Sep 11, 2009 Authored by Thomas KejserAuthor: Thomas Kejser Reviewers and Contributors: Bob Ward, Michael Thomassy, Juergen Thomas, Hermann Daeubler, Mark Souza, Lubor Kollar, Henk van der Valk (Unisys) and Peter Scharlock For advanced troubleshooting and understanding of SQL Server, you can sometimes benefit from creating a dump file of the sqlservr.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.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.
