Lesson Learned #508: Monitoring Wait Stats and Handling Large Data Set
Sometimes, we get asked how much data the client application is receiving from Azure SQL Database, along with the time spent and the number of rows returned. I would like to share a simple example that allows us to approximate these details. I hope that you could find useful.Lesson Learned #385: Failed to validate the server name in a certificate during Secure Sockets Layer
The error message "Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization" indicates that there was a failure in validating the server name in a certificate during the initialization of the Secure Sockets Layer (SSL) protocol. SSL is a security protocol used to establish secure and encrypted connections between a client and a server.Lesson Learned #240: Checking connection and execution latency in Azure SQL DB and Managed Instance
Today, I worked on a service request that our customer asks about: How to know the connection time invested to connect to the database in Azure SQL Database and Azure SQL Managed Instance. How to know the time invested running a real queries to know the latency of the network, roundtrips and execution time. Following, I would like to share a small PowerShell Script that giving some parameters your could know by your own these numbers. All this information is based on this article
