by Contributed | Dec 11, 2020 | Technology
This article is contributed. See the original author and article here.
Connection pooling is one of the best practices that we could implement in our code due to improvement in the time spent establishing the connection. However, if we are not aware about it, we may have connectivity issues that may not be related with database service and may be related how our application closes the connection in case of any error, error handling or server client infraestructure level.
In this YouTube session we reviewed three important points when the connection pooling is enabled:
- The impact establishing the connection time spent to our Azure SQL database/server.
- What is the reason about a typical error when we reached the maximum limit of the connection pooling – Timeout period elapsed prior to obtaining a connection from the pool.
- How to obtain connectivity pooling metrics to know how many connections, many connections pool, etc..
Enjoy!
by Contributed | Dec 11, 2020 | Technology
This article is contributed. See the original author and article here.
Connection pooling is one of the best practices that we could implement in our code due to improvement in the time spent establishing the connection. However, if we are not aware about it, we may have connectivity issues that may not be related with database service and may be related how our application closes the connection in case of any error, error handling or server client infraestructure level.
In this YouTube session we reviewed three important points when the connection pooling is enabled:
- The impact establishing the connection time spent to our Azure SQL database/server.
- What is the reason about a typical error when we reached the maximum limit of the connection pooling – Timeout period period elapsed prior to obtaining a connection from the pool.
- How to obtain connectivity pooling metrics to know how many connections, many connections pool, etc..
Enjoy!
by Contributed | Dec 11, 2020 | Technology
This article is contributed. See the original author and article here.
News this week includes:
Holiday parties & background fun with Microsoft Teams
Get started with PowerShell on Microsoft Learn!
Holiday Shopping with Microsoft Bing and Microsoft Edge
adversi is our member of the week, an excellent contributor in the Excel community.
View the Weekly Roundup for Dec 7-11th in Sway and attached PDF document.
https://sway.office.com/s/qjuwFrVqSqZEyuwA/embed
by Contributed | Dec 11, 2020 | Technology
This article is contributed. See the original author and article here.
To connect to Azure SQL Database we could use multiple tools or coding languages like C#, PHP, Java, etc.. In some situations, we need to test our application, for example, how much time take a single connection, review my retry-logic, review the connection, etc..
In this URL you could find an example about several operations that you could use using JAVA.
This application has been designed with a main idea: how to obtain information about the elapsed time in the connectivity process and the query execution to a database of Azure SQL Database using JAVA (Microsoft JDBC Driver for SQL Server). This JAVA console script runs in Windows and Linux.
This JAVA console script has the main features:
- Connect using Microsoft JDBC Driver for SQL Server measuring the time spent.
- Once you have established the connection runs multiple times the query SELECT 1 measuring the time spent.
You could find the instrucctions in readme file.
As always, all feedback and contributions are very welcome.
Enjoy!
by Contributed | Dec 11, 2020 | Technology
This article is contributed. See the original author and article here.
BizTalk Server 2020 provide the new feature of automatic deployment using Azure DevOps, one heavy step for setting up the pipelines is setup build agent pool – Configure automatic deployment with Visual Studio Team Services – BizTalk Server | Microsoft Docs, which now can be simplified to use “Azure Pipelines” as Agent pool and “windows-2019” agents.
Check virtual-environments/Windows2019-Readme.md at main · actions/virtual-environments · GitHub for more information about all the tools installed on this agent specification.
Recent Comments