I want to thank all of the participants of T-SQL Tuesday #132. If I missed your post, it was not intentional. Please let me know, and I will add it here. I am proud of this community and feel lucky to be a small part of it. I admire everyone who joined the blog party […]
Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]
I thank Elizabeth Noble (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Automate Your Stress Away. 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 this program. If you […]
I am writing this blog post for my own reference for future. Hopefully someone will be benefited in the process. Recently I was working on upgrading System Center Operations Manager and configuring alert for high CPU. I wanted the alert to trigger if CPU was above a certain percent for x consecutive polls. While simulating […]
As a member of the leadership team of the New England SQL Server User Group (NESQL), my primary responsibility is to schedule speakers ahead of time. With the current pandemic, I am struggling to formulate my email to potential speakers for the year 2020-21. Do I ask them to commit to in-person, virtual, or for […]
