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 […]
Happy Friday! Anyone else feel like June is flying by? Just us? But that's OK because it means we're that much closer to... next week when @SQLvariant will be presenting "Why Jupyter Notebooks are Changing Everything". Remember to RSVP and join us! https://www.meetup.com/NESQLUG/events/277115798/
Happy Friday!
Do not forget to sign up for a talk by @AnalyticAnna
"Don't miss the bus: Functions, Azure SQL, ... Geospatial, JSON"
Registration details:
https://www.meetup.com/dbavug/events/276911440/
Wednesday, June 23rd, 2021
2:00 PM EDT
1800 GMT
#Azure #AzureSQL
New Job Postings at @TheGoodrCo coming next week.
#Partnerships and #CustomerSuccess
There’s still time to submit your last-minute PASS Data Community SUMMIT abstract – CFS closes in just over 12 ... hours! Grow your speaking experience, share your expertise & help your community learn more about the #Microsoft #data platform.
Submit now: http://ow.ly/rta750FcyNW
T - 7 days
@AnalyticAnna will be talking about:
"Don't miss the bus: Functions, Azure SQL, Geospatial, JSON"
... Registration details:
https://www.meetup.com/dbavug/events/276911440/
Wednesday, June 23rd, 2021
2:00 PM EDT
1800 GMT
#Azure #AzureSQL
