Over some time, SQL Server Management Studio has expanded memory grant information. Memory grant provides memory grant estimate as well as actual runtime memory grant information. In this blog post, I will explain each element of ‘Memory Grant Info’, so we can get a better understanding of what those numbers mean? I am using this […]
Here is a sample output of XML from sys.dm_os_ring_buffers where WHERE ring_buffer_type = N’RING_BUFFER_SCHEDULER_MONITOR’. What do those XML elements mean? In order to monitor CPU usages, you need to understand what each element means so you can use the values. I will explain each one in this blog post. ProcessUtilization Indicates the amount of CPU SQL […]
With the announcement of Powershell support in Azure Functions, it has become easier for data professionals to use functions to manage cloud resources such as Azure SQL Database, Managed Instances. A common challenge when using functions is how to manage the credentials in function code for authenticating databases. Keeping the credentials secure is an important […]
As per the Microsoft documentation, I should be able to set up Azure Monitor Action Group with voice mail. I can easily do that from the portal. I wanted to do the same with PowerShell. The following code works as expected while setting up email and SMS. When I add the code for the voicemail, […]
With the release of SQL Server 2019, CTP 2.1 new features were added to Intelligent Query Processing (QP) feature family. One of those features was Scalar UDF Inlining. You can read about the announcement by Karthik Ramachandra from Microsoft in this blog post. Karthik explained why UDFs are a problem when inlining is not done. Another […]
I will be speaking at @PASSCloudVC in 3 hours.
10 am PST
1 pm EST
17:00 UTC
Azure SQL Database - Where is my SQL ... Agent?
Registration: https://cloud.pass.org/
#sqlpass #MVPBuzz
#SQLFriday is free Microsoft Data Platform training, delivered by top speakers from the Data Platform community every ... Friday lunch (12:00 CEST), to your computer. Join meetup group at https://meetup.com/Sql-Friday and check out the full schedule at https://sqlfriday.net/schedule
Would be equally relevant if #MLK was giving the speech today.
“In the final analysis, a riot is the language of the unheard. And what is it that America has failed to hear?”
Call for Speakers has reopened! In light of #PASSsummit 2020 becoming a virtual event, we want to give you another ... chance to share your #data knowledge with the #sqlpass community, from anywhere in the world!
Apply Today: http://ow.ly/iuiX50zVWQ0
