LinkedIn

Using Python to automate tasks such as connecting to a database, executing queries, analyzing results, generating reports in XLS format, and emailing

Database connection SQL execution Data analysis Excel (XLSX) report generation Emailing the report using Outlook Logging & error handling You can adapt this directly ...
LinkedIn

Creating a Local Agentic DBA Assistant Using Python, Ollama, and Free LLMs

Agentic AI is rapidly becoming a strategic capability within modern software engineering, yet many DBAs assume that meaningful exploration requires substantial investment in cloud‑based models or ...
GitHub

Robot Framework Database Library

The Database Library for Robot Framework allows you to query a database and verify the results. It requires an appropriate Python module to be installed separately ...
GitHub

Using-an-Output-Converter-function.md

crsr.execute("CREATE TABLE #dto_test (id INT PRIMARY KEY, dto_col DATETIMEOFFSET)") crsr.execute("INSERT INTO #dto_test (id, dto_col) VALUES (1, '2017-03-16 10:35:18 ...