Happy New Year! It has been quite a long while since I last wrote a blog post. After making it 100 straight blog posts without missing a Tuesday or Friday deadline, I decided to take a little break from blogging. However, I’ve done a few exciting programming and database related things in that time, and […]
Send Automated Email with PowerShell
I am supposed to send a weekly status report to my team lead and manager every week. I really like that the company takes an effort to know what is going on with the employees, and I like that I have the ability to speak up as soon as an issue arises. However, I almost […]
Badge Generator in Python
I volunteered to help out a local board game convention this year. The organizer is a friend of mine and has helped with my own board game event (a cancer research fundraiser called Play It Forward). To help out, Play It Forward is providing badges, badge holders, and lanyards. The Goal The organizer of the […]
Looking Back
It’s really hard for me to believe, but this is my 100th post to TechTrek. I’m really proud of everything that has happened and all of the things that I have learned since my first post on November 5th, 2015. I’m incredibly proud of myself for not once missing a publishing date — I set a […]
SQL Tips & Tricks #3
I have a lot to learn. I know that this is particularly true when it comes to SQL, so I try to note down neat things I learn about SQL and add them to one blog post when I have enough. If you missed the previous ones, you can view them here and here. SET […]
Generating Word Cloud From Twitter Feed with Python
Every week, someone on Reddit posts a “word cloud” on all of the NFL team’s subreddits. These word clouds show the most used words on that subreddit for the week (the larger the word, the more it was used). These word plots are always really fascinating to me, so I wanted to try to make some […]
Service Level Agreements
Several weeks ago, we reviewed ITIL, its practices, terminologies, and certification (you can read that here). Part of ITIL’s definitions and methodologies are something known as SLAs. An SLA is a Service Level Agreement. It is an agreement between an IT service provider and a customer. It describes the IT service, documents Service Level Targets, and […]
An Introduction to Git
It’s been pointed out to me that I do a lot of Introduction posts. I am nearing my 1 year mark on the blog, so I am hoping to start getting deeper into some of the topics I have covered previously (seems like it is about time!). However, there is still one topic that is […]
What Is The Kimball Group?
The Kimball Group is a team of people that specialize in designing data warehouses for business intelligence. They came up with a methodology for designing data warehouses and other general business intelligence methodologies. What Is A Data Warehouse? A data warehouse takes data from a company’s databases and optimizes it for analytics. Data warehouses are […]
Automate Snippet Generation with PowerShell
SQL Server Management Studio has a built in Snippet Manager. Snippets are SQL templates that you or your team uses regularly. You might use some snippets because the code is so long, or maybe the code is very short (such as your user id) but it is something you use often. Snippets let you easily […]