Running a local AI model for DBA work
Cloud AI assistants are great, but as a DBA I am always a bit careful with what leaves my machine. Query text, table names, error logs: it adds up. So I wanted to find out: can I run a decent coding…
Categorie AI
Bevat..
Join order (Build/Probe, Outer/Inner) & Physical Operator Selection
In the past you always tried to make queries faster by starting joining with the smallest table and end with the largest one, or visa versa, whatever you did.. you never got it very fast.. now lets take a closer…
Automate Executionplan Analysis by Skill and Query Store
Erik Darling has created a plugin/skill to analyze execution plans. (see: erikdarlingdata/claude-plugins: Claude Code plugins from Erik Darling Data ) well, lets use it in a convenient way by using the QueryStore and create an Actual plan and feed that…
Is AI making an end to my jobs as a SQL Server Query tuner? Yes, No.. lets find out.
My friend Erik Darling posted a video on Youtube ( (3) New Claude Plugin For SQL Server Query Plan Analysis – YouTube ) where he showed how to work with a Skill to analyze queryplan. “Two commands to install:/plugin marketplace…