Well you may have noticed the different look and format of my blog. I ended up making the decision last week to go ahead and move off of WordPress.com and moved it be hosted by GitHub. It was an interesting process that if many show interest I can write up what I had to go through.

I also decided to go ahead and get my own domain name: blog.wsmelton.info. Which I had to do the sub-domain link with GitHub pages because (as I understand so far) GitHub will not let search engines crawl an apex domain address, but will a sub-domain address because it is just a CNAME record and not an A record. [It’s a DNS thang.]. I also did look into getting a .com or .net, but those were both taken by some law firm in North Carolina. As well, they are charging a good bit more per year for .com addresses now a days. I hope to at some point purchase the SSL (also something not to cheap) so the site can be https compliant. One last thing I also found out was that since the “.info” is a new top-level domain name, there will be some networks that are going to block the site. I’m not exactly sure why, but nothing I can do about that right now.

GitHub pages has some nice features:

  • Markdown language is supported, and offers a good bit more formatting options than WordPress.com does on their free hosting site.
  • Still get to have an RSS feed, you can find that link down at the bottom.
  • I’m already using GitHub so why not host the blog there as well.
  • No space limit like WordPress.com has on their free subscription. I was not to close to hitting it just yet but plans I have to try and start writing more I would have hit it sooner than later.
  • Jekyll is new language for me to learn, always fun. The categories page I actually built on my own, after finding some examples to use. I would like to have them listed in maybe a drop-down or something but still working on figuring that out.
  • Best one, I can use just about any code editor I want to write blogs. I’m not restricted to using LiveWriter or WP’s online editor. I’m currently using Visual Code since it supports Markdown.

All in all I am pretty happy with how it turned out. I did have to go review every post I wrote since the converstion messed up some formatting. I also had to go update all the image references to the new location.

Current Work

I did write in a post last year that I had taken a new job (I think). I have been working as a Database Consoultant for Pythian since February 2015. It has been a fun ride and interesting place to work compared to my last employers. I work full time from home, and don’t have to travel. Which I was working from home full time prior to this job, but Pythian has much better setup to handle a global workforce that all work from home.

Fun stuff

So since I have started with Pythian I have had the opportunity to work on some fun projects/tasks with clients. Which the client list by the way is impressive for Pythian. The team I am on are responsible for 8 of the clients listed on that page.

Cloud

The big thing I have gotten involved in is support of SQL Server in environments like Azure and AWS. Many of the clients we support have or are in process of migrating servers to the cloud. It is some fun stuff to work with now.

Pythian actually asked me to earn a certification in AWS and paid for it. I was the 19,302nd person to become certified as an AWS Certified Solutions Architect - Associate. I am working on getting the equivalent certification for Azure some day. One thing I found out about Azure’s certification though is there is no “associate” and “pro” like AWS, just one for the whole thing so it will be a bit more of a challenge.

PowerShell

I’m still involved in PowerShell and integrating it into the IT process for clients. I just got done with a project for a client to automate configuration and installation of SQL Server, for building new environment(s). It was a good challenge to work and figure out use of Desired State Configuration for some of that….also gave me some good blogging topics that I hope to get out in the next few months.

I have also become a contributor for the sqlcollaborative organization on GitHub. The main part I am involved in right now has been dbatools. You can find us working on this on GitHub or in the SQL Server Community Slack channel #dbatools.

There is also dbareports but I have not gotten invovled in that project…just yet. It offers a SSRS solution for pulling information about your SQL Server estate in a more user friendly manner. Both projects are focused on helping the less experienced DBAs (accidental or not) and even those experienced that may not have the time to role their own solutions. Just that bit of community help that allows you to do your job a little easier.

I will hopefully start blogging more about some of the commands in dbatools that is being released…some cool stuff coming out each month.

Future

Well I hope to start writing more frequently. I did a stint over the last year where I was writting for other sites (one being Pythian). However, I found while that was fun to get my content out there it was more work that it was worth. Pythian actually allows me to syndicate my content on their site, and it is part of my of job to blog as I have time. Yeah they pay me to blog about work stuff, it’s awesome! I have some post that were published this past year on Pythian’s site but not on my personal site.

So here is to the future, and hope you find it as fun as I do.

Header image source