Home
%3CLINGO-SUB%20id%3D%22lingo-sub-369181%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2368%3A%20Azure%20Database%20-%20SQL%20Connectivity%20Checker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369181%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jan%2025%2C%202019%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Hello%2C%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Yesterday%2C%20I%20worked%20in%20a%20support%20case%20that%20our%20customer%20needs%20to%20review%20the%20connection%20and%20if%20possible%20the%20execution%20time%20spent%20for%20%3CSTRONG%3E%20Azure%20Database%20for%20PostgreSQL%20%3C%2FSTRONG%3E%20using%20%3CA%20href%3D%22https%3A%2F%2Fpgbouncer.github.io%2Finstall.html%23building-from-git%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20PGBouncer%20%3C%2FA%3E%20and%20not.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20I%20developed%20and%20upload%20a%20new%20option%20in%20our%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FJMNetwalker%2FAzureSQLConnectivityChecker%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20AzureSQLConnectivityChecker%20%3C%2FA%3E%20for%20PostgreSQL%20in%20our%20GitHub%20project%2C%26nbsp%3Bin%20order%20to%20review%20this%20connection%20time%20spent%20for%20the%20application.%20You%20need%20to%20install%20%3CA%20href%3D%22https%3A%2F%2Fwww.postgresql.org%2Fftp%2Fodbc%2Fversions%2Fmsi%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20ODBC%20%3C%2FA%3E%20and%20create%20the%20DSN%20first.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20In%20this%20same%20resource%20our%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FJMNetwalker%2FAzureSQLConnectivityChecker%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20AzureSQLConnectivityChecker%20%3C%2FA%3E%20you%20could%20find%20the%20same%20connection%20checker%20for%20%3CSTRONG%3E%20Azure%20Database%20for%20MySQL%2C%20Azure%20Database%20for%20PostGreSQL%2C%20Azure%20SQL%20Database%2C%20Azure%20SQL%20Managed%20Instance%20%3C%2FSTRONG%3E%20and%20%3CSTRONG%3E%20SQL%20Server%20OnPremise%20%3C%2FSTRONG%3E%20.%20I%20have%20done%20all%20these%20tests%20working%20with%20customer%20cases%20with%26nbsp%3Bvery%20good%20results.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20I%20will%20be%20more%20than%20happy%20if%20you%20could%20collaborate%20adding%20more%20options%20in%20these%20PowerShell%20scripts.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Enjoy!!!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-369181%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jan%2025%2C%202019%20Hello%2CYesterday%2C%20I%20worked%20in%20a%20support%20case%20that%20our%20customer%20needs%20to%20review%20the%20connection%20and%20if%20possible%20the%20execution%20time%20spent%20for%20Azure%20Database%20for%20PostgreSQL%26nbsp%3Busing%20PGBouncer%20and%20not.%3C%2FLINGO-TEASER%3E
First published on MSDN on Jan 25, 2019
Hello,

Yesterday, I worked in a support case that our customer needs to review the connection and if possible the execution time spent for Azure Database for PostgreSQL using PGBouncer and not.

I developed and upload a new option in our AzureSQLConnectivityChecker for PostgreSQL in our GitHub project, in order to review this connection time spent for the application. You need to install ODBC and create the DSN first.

In this same resource our AzureSQLConnectivityChecker you could find the same connection checker for Azure Database for MySQL, Azure Database for PostGreSQL, Azure SQL Database, Azure SQL Managed Instance and SQL Server OnPremise . I have done all these tests working with customer cases with very good results.

I will be more than happy if you could collaborate adding more options in these PowerShell scripts.

Enjoy!!!