“Lock Escalation” is an optimization technique used by SQL Server and it is basically how it handles locking for large updates. When SQL Server is going to modify a large number of rows – it is more efficient for the database engine to take fewer, larger locks (table lock) instead of dealing with a large number of individual locks (row locks).
SQL Saturday Chattanooga was held on 24th June at UTC Chattanooga EMC Building. I have been to multiple SQL Saturdays earlier, but this was my first time in SQL Saturday Chattanooga. I was humbled to get the opportunity to present two sessions during this event.
I am excited to announce that I have been selected to speak at SQL Saturday Pensacola on 3rd June, 2017. I have heard so many good things about this event from my peers, that I feel humbled to be part of the event this year. SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.
One of the events which I was lot excited to attend was the pre-Build event – ‘Microsoft AI Immersion Workshop’. The event promised to be a great opportunity for developers to learn about building intelligent applications using Microsoft and open source technologies. Now that the event is over, I must say that it did live up to its expectation.
During my SQL Saturday Birmingham Presentation on SQL Tips and Tricks, one of the productivity feature which got lot of love from most of the attendees was the use of custom colors to differentiate between SQL environments. SSMS provides us with an ability to set different colors for connection to separate environments.
SQL Saturday Birmingham 2017 was held on 18th March at Samford University. This was my first SQL Saturday as an Organizer. I also presented on Productivity Tips and Tricks in SSMS.
On 14th January, 2017 I attended SQL Saturday Nashville held at Middle Tennessee State University (MTSU), Murfreesboro. I have been to multiple SQL Saturdays before, but this was my first SQL Saturday as a Speaker.