This is a session about new features in SQL Server Management Studio and runtime data exposed via showplan. Microsoft’s goal is to make showplan, one stop shop for query performance troubleshooting. I presented the session to following user groups and events. Rhode Island SQL Server User Group on February 07, 2018 PASS DBA Virtual Chapter on […]
On February 15, 2018, SQL Server Management Studio 17.5 was released. A new feature called “Data Discovery & Classification” was launched with this release. You can read about this feature in the following posts. SQL Data Discovery and Classification What’s new in SSMS 17.5: Data Discovery and Classification Since this feature was released a common question was […]
There are many blog posts available online about reading SQL Server Error Log or SQL Server Agent Error Log. What I needed was to search for a string (or string within a string) in all available error logs. Save the results in a table. That way I can find the frequency and pattern of the […]
There was a question in dba.stackexchange.com titled “module_end extended events duration in microseconds?” that I answered and it was Microsecond in that instance. Later on, I questioned myself if the duration is always in Microseconds for extended events. I found it is a mix of Millisecond, Microsecond and some are unknown meaning famous NULL. I […]
This is a session about cardinality estimation, a phase during query optimization. I presented the session to following user groups. Pass DBA Virtual Chapter on April 25, 2017 SQL Saturday Rochester (#619) on April 29, 2017 Rhode Island SQL Server User Group on May 03, 2017 Maine PASS Chapter on May 18, 2017 Seacoast SQL […]