Thoughtful Thursday #3

What I’m Doing: I have the rest of the week off of work and am focusing on improving my python. I figured out how to connect to my Microsoft SQL Server using pyodb. Here is the easy to remember connection string using set variables: cnxn = pyodbc.connect(‘DRIVER={ODBC Driver 17 for SQL Server};SERVER=’+server+’;DATABASE=’+database+’;UID=’+username+’;PWD=’+ password) From there,Continue reading “Thoughtful Thursday #3”

A Warning in my Execution Plan

Since I investigate a lot of SQL queries at my job, I’ve been studying techniques to optimize SQL Server functionality, create efficient indexes and examine SQL Query performance. I’ve learned a lot about reviewing execution plans, monitoring system performance, and using tools like Query Store and Wait Stats to dissect queries hogging resources. Overall, itContinue reading “A Warning in my Execution Plan”