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 […]
PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. SQLSaturday Rochester will be held on Feb 29, 2020, at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623, United States. […]
I thank Jes Pomfret (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Life hacks to make your day easier. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating […]
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, […]
Check out this awesome lineup of #speakers for #COVID19 fundraiser Lightup Virtual Conference! Register now: ... https://2020twenty.net/lightup/ cc @thetechplatform @mitul_rana @jpomfret @SQLStad @SqlWorldWide @yashkamdar391 @PabloJavier911 @darkicebeam @PabloDiLoreto
Folks, I'm excited to speak at the #LightUp conference next week, it's 24 hours of fun. You can catch my dbatools ... session on Wednesday morning (4am EDT, 9am BST)
I'm super thrilled & honored that my "Notebooks 101 for SQL People session" has been selected as part of UNICEF ... #COVID19 #Lightup fundraising event. Tune in on July 14 at 9PM EDT. Register & donate: https://events.unicefusa.org/event/lightup2020 🙏
Check out the schedule here:
https://www.2020twenty.net/lightup/
BREAKING: This chart. Devastating.
Do everything you can to prevent the spread.
From @nytimes who sued @cdc to ... get this data.
58 miles, two weeks in a row.
#selfcare
#sqlrun
