No lies. In my younger years, I procrastinated a lot. I was always putting off homework and chores until I forgot about it. For whatever reason, I didn’t take many things seriously, and I didn’t care about doing things on time. Sure, I wanted to be smart, and I loved delving into things for whichContinue reading “When I stopped Procrastinating”
Author Archives: Eric K
Using VBA to Analyze Stocks
Coding in VBA to crunch excel spreadsheet data wasn’t very fun, but it was good mental exercise and got my mind working. I found the language obtuse compared to python, and making mistakes that output to the spreadsheet was annoying to clean up. Not to mention the numerous times I crashed the excel application withContinue reading “Using VBA to Analyze Stocks”
Thoughtful Thursday #7
Another thoughtful Thursday coming to you Saturday. Thursday has become homework day since I’m back in school, so I have less time to pump these out on those days. Even so, I’m still sticking with the title… What I’m playing: The new league in Path of Exile dropped on Friday. I wish I had moreContinue reading “Thoughtful Thursday #7”
Thoughtful Thursday #6
A few days late on this one, but better late than never! What I’m doing: It feels great to be a student again. Every time I get out of my car and walk into the UofM building, I think about all the brilliance that has been through those doors before me and become inspired. ClassContinue reading “Thoughtful Thursday #6”
Thoughtful Thursday #5
What I’m thinking: Since we have had a ton of snow this February, I’ve been thinking about my shovel technique. I think the best way to shovel a driveway is to start down the middle vertically. Then, horizontally push the snow closer to the banks of the driveway until you’re close enough to throw theContinue reading “Thoughtful Thursday #5”
Thoughtful Thursday #4
I’m back to the blogosphere… if that is still a thing. Happy Valentine’s day! What I’m doing: I have been enjoying my last week of freedom before the Data Analysis coding camp begins. The new video game, Apex Legends has captivated me and my group of friends. It is great to play if you haveContinue reading “Thoughtful Thursday #4”
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”
Thoughtful Thursday # 2
Continuing the trend… What I’m thinking about: I should be focusing more on my python skills. I will have to brush up using a few online tutorials before I start class. What I’m working on: I have a few on-going projects. I started collecting more stock data for my financial model to assist me withContinue reading “Thoughtful Thursday # 2”
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”
Thoughtful Thursday #1
Inspired by Timothy Ferris’ 5-Bullet Friday where he lists 5 things he is keeping up on, I am going to list some things that I’m doing and thinking. I call the exercise Thoughtful Thursday. Timothy Ferris is a best selling author and self-proclaimed human guinea pig. If you are unfamiliar with his work, I highlyContinue reading “Thoughtful Thursday #1”