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 […]
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: […]
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 […]
Born when world population was just 3.5B, Winston Churchill and Malcolm X were alive, I still find it amazing that I can... sit in W. Europe participate in a Central America tech conference, with speakers from Bangalore, & Boston
@DataSaturdays (Guatemala), @A_Bansal, @sqlworldwide
Thank you to those attending my session this morning at #DataSaturday #Guatemala .
Slides and code is available at: ... https://github.com/sqlworldwide/Presentations/tree/master/The%20magnificent%20seven%20-%20Intelligent%20Query%20processing%20in%20SQL%20Server
Speaking for the First Ever Data Saturday event today 😇 at 11am EST
Please register here for Data Saturday Guatemala:...
https://datasaturdays.com/events/datasaturday0002.html