SSMS Memory Grant Info

May 11, 2020

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 […]

Ring Buffer Monitoring CPU – What do those values mean?

February 24, 2020

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 […]

How to Use Managed Identity with Azure Function App?

January 27, 2020

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 […]

New-AzActionGroupReceiver How to Set Up Voice Calls as a New Action Group?

February 6, 2020

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, […]

Did My UDF Inlined?

December 30, 2019

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 […]

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Ready to listen to @SQLPedro talking about intelligent database.
Organized by @NESQLServer .
Hosted by @vivanovich

@BornSQL Randolph certainly is speaking to Edmonton PASS Chapter next Thursday. We had @SqlWorldWide talk to us about ... SSMS and now we get to compare Azure Data Studio to SSMS. Go to http://www.edmapss.pass.org to find out the details and register

by end of today I will be comfortable with Intelligent Query Processing feature.

Listening to @SQLBek for 2 hours ... starting at 11am.
Then hosting @SQLPedro for our UG @NESQLServer on the same topic.

Load More...