×

SSMS Memory Grant Info

May 11, 2020

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

AZ-900 How Did I Prepare?

March 19, 2020

On March 16th, I posted (Twitter|LinkedIn) about achieving my first ever Azure Certification. AZ-900 Azure Fundamentals. I understand it is basics, and that is why it is called fundamentals. I had a few people asked me how I prepared as they want to do the same. Here are a few resources I used to prepare: […]

Ring Buffer Monitoring CPU – What do those values mean?

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

Speaking at SQLSaturday Rochester

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

T-SQL Tuesday #123: SSMS tips to make your day easier

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


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

Do you have correct mindset and knowledge to secure #AzureSQL Database?
Join @Surbhi_Pokharna to hear about 'Applying a... Security Mindset to Lock Down Azure SQL DB'
Thursday, August 5, 2021
6:00 PM to 8:00 PM EDT

https://www.meetup.com/North-Boston-Azure-Cloud-User-Group/events/279719873/?refund_policy=true&rv=ea1_v2&_xtd=gatlbWFpbF9jbGlja9oAJGNlNTY0MmUyLWQyM2MtNGFmMi1iNzZlLTY0NTdlMmI1MTc1Yg&utm_campaign=event-announce&_af=event&_af_eid=279719873&utm_medium=email&response=3&action=rsvp&utm_source=promo

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */