February 29, 2020
View Event: Extended Events – How to collect the first 10 or every 4th event Fast-paced 15-minutes-or-less talks, followed by a chance to have some Q&A with the speaker. Extended Events offers a rich filtering mechanism, called predicates. Have you ever thought of collecting only the 4th event, first 10 occurrences of an event, capture […]
February 29, 2020
View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan. Do you know that you can now see how many pages are spilled to disk for a sort, […]
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 […]
February 18, 2020
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. […]
February 11, 2020
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 […]