×

How to Persist Information from Lightweight Query Profiling?

September 14, 2020

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

T-SQL Tuesday #130: Automate Trace Flag Consistency

September 8, 2020

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

Stress Test Using sqlcmd Utility

August 17, 2020

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

User Group Meetings and COVID-19

June 1, 2020

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

Sensitivity Rank in Data Classification

May 27, 2020

Data Discovery & Classification is supported for SQL Server 2012 and later, and can be used with SQL Server Management Studio (SSMS) 17.5 or later. Starting SSMS 18.5, a new feature called ‘sensitivity rank’ was added in Data Classification. I will show details about the sensitivity rank in this blog post. I want to thank David Trigano, Program […]



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