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 […]
Got stack dumps? Check out the latest version of the SQLCallstackResolver from @arvisam ! ... https://github.com/arvindshmicrosoft/SQLCallStackResolver/releases/tag/2.0.1
Looking forward to moderate this session by @SQLGoddess .
We have 142 data professionals signed up. We can accommodate ... few more.
Looking forward to hosting @SQLGoddess tomorrow night, talking about "TempDB: The Good, the Bad, and the Ugly". There's still time to sign up: https://www.meetup.com/NESQLUG/events/271358709/
"See" you there!
What an honor and privilege to be speaking at @ROCSqlUG
Thursday, August 13, 2020
19:00 - 21:00 EDT
The Magnificent ... Seven - Intelligent Query Processing in SQL Server
Registration details:
https://rochesterpass.pass.org/
#sqlpass #sqlserver #sqlserver2019
#mvpbuzz
@timweigel @SqlWorldWide @sqlpass The game changer that I found for SQL Saturday Iowa 2020 was to fully embrace the ... online event and stop thinking of it as an "in person" event presented online. We found innovative ways around many of the online event challenges.
The great staff we have didn't hurt either!
@timweigel @SqlWorldWide @sqlpass In person is great for a rock solid paywall.
In person events allow me to see people ... who I love to talk to but who live in places I rarely get to visit... @SQLInTheWild, @rob_farley, and @jesus_gilv jump right to mind, among a full on hoard of European friends.
