In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC. Let us read more…
The session-level options can be found using the @@options variable in SQL Server. Let us decode that in this blog post and learn about it.
The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers.
During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.
Here is the updated list for March 2020 of all the tools which I recommend. Do let me know if you use any of the above tools.