T-SQL Tuesday #193 – Notes to my past self and from my future self

It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to yourself from the past and the future.” It has been a year and a half since I went on full time disability due to ALS. I worked for as long as I was able contribute well. It was a sad but necessary reality. This very reality feeds into my notes.

Note to my past self, ten years ago

Don’t allow others to influence you away from your passion for data excellence and leadership. When you are told that becoming a Microsoft MVP is only a personal (or selfish) endeavor and will not help the company and it doesn’t matter, DON’T LISTEN! They are showing how little they know or understand you. The same is true about your data community involvement.

I was awarded the Microsoft MVP award for my work on Microsoft Fabric about a year and a half ago. It was then I learned how much access you get to the engineering teams at Microsoft and a worldwide network of fellow pros. Throughout my years working for Microsoft partners, I have been on data partner advisory councils. I appreciated that exposure, but MVPs already knew what we were hearing for the first time. I can only imagine how I could have helped steer the technological direction of my companies with that insight.

A quick soapbox… It never ceases to amaze me how many MVPs and advisory members do not give feedback and recommendations back to Microsoft. These relationships should be mutually beneficial. From personal experience, I know that giving feedback to Microsoft is beneficial. Many times, Microsoft teams and others thought I was an MVP even though I was not. It was because of my feedback on the data platform through other channels.  …end of soapbox.

My overall point to my past self is that you should pursue the path that you see as right for you. Don’t let the naysayers deter you. You need to play to your strengths.

Note from your future self

Before I start this, living ten more years would be amazing. ALS life expectancy is 2-5 years, and I am in year four.

Don’t stop what you are doing. It will continue to be easier and more efficient for you to create. Don’t be afraid of continuing to contribute to the data community. Your mind still works. It will take a lot of patience to work with data tools that are not eye gaze friendly. Don’t let that deter you. Have fun, find a lane and run with it.

I just started getting back to technology. I created the Data on Wheels ~ ALS website, only using eye gaze technology. “Look mom, no hands!” It has been a great experience for me and got me back into technology. I tried using Power BI for the data analysis but quickly realized that I needed Microsoft Fabric to do the work I wanted to do which is out of reach financially (trial capacities are time boxed). So maybe I will see what I can do to solve that problem.

Wrapping it up

I listened to company leaders early in my career. They were wrong. I trusted their input too much. I should have sought additional advice. It would have been better for me and the companies I enjoyed working for.

Today, I have the desire but not the patience or means in some cases to data work. I enjoyed it a lot. I should not give up. I look forward to sharing what I learn.

My advice to everyone is to follow your passions and find enjoyment in your career. Seek council from many different perspectives in your pursuit.

Managing subscribers, creating newsletters

When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous post, this is not the case. I wanted a way to allow people to subscribe to my content. It turns out that I needed an email marketing solution which was quite a surprise.

The search is on

I had a very basic list of needs.

  • A way to subscribe
  • Subscriber management
  • Email subscribers

The first platform recommended by WPBeginner whose parent company is the source for many of my plug ins was Constant Contact. I then looked at HubSpot and MailChimp because I had heard of them. They met my needs but at a cost. If they had free options, they were limited in functionality. I ended up choosing Brevo which has a robust free plan.

To be clear, I needed a low to no cost solution to meet my needs and fill this gap in functionality. I do not generate income from my website, so a free option is required. Brevo fits the bill nicely.

Ancillary costs

As part of the setup, I needed to set my sender email address and domain. Both needed to be verified and compliant with the major email providers’ requirements. I had to create DKIM and DMARC records in my domain.

Screenshot of the sender settings page in an email marketing platform, displaying details about verified sender domains, DKIM and DMARC configurations, and sender management options.

Little did I know that this was not a straightforward process. The email I am using is a Microsoft 365 account hosted and managed by GoDaddy. First, getting the correct entry required me to contact GoDaddy for support. They worked on the backend to get me set up and create the entries I needed for DNS.

Note: If you manage your own Microsoft 365 and Azure accounts, you can do this process. It will require elevated permissions to both environments.

The second requirement to make this work is to turn on Advanced Email Security. I wanted to apply this to the email I was using, but it is a domain level setting. Six emails had to be updated. The cost of this required upgrade is the most expensive single cost of my website build out. On the plus side, we are getting far less spam. 😊

Image showcasing information about GoDaddy's Advanced Email Security, including details about online threats like malware, ransomware, and phishing.

Newsletters are a bonus

When I started working with Brevo, I was not sure how to send out emails. After some digging, I discovered campaigns. I am not an email marketer, so this was not obvious to me. I created my first campaign by following the steps provided. It was very easy to do.

Newsletter creation interface showing sender information, recipient count, subject line prompt, and design options.

I used a template to create my first newsletter. It was a very intuitive process. I used clicks to add new items to the newsletter. I think you can use drag and drop also. I created a couple of test campaigns to see how it all worked. I liked what I found. I created and sent my first newsletter shortly thereafter.

I really like the metrics. They tell me the delivery rate, the opens, and the clicks for each campaign. This has been helpful to understand the effectiveness of the newsletter.

Screenshot of a newsletter campaign report titled 'Newsletter #3 National Caregivers Month' showing details such as delivery rate, open rate, and click-through rate.

Managing subscribers

This functionality is the primary reason I wanted a solution. In Brevo, this work is done in the CRM. I started by creating a couple of lists. After I became familiar with lists, I imported a spreadsheet with family and friends who were invited to one of my children’s weddings. I used this to see who wanted to subscribe to the newsletter. I found a couple of additional lists that I imported to recruit newsletter subscribers. All the lists I used were ours and included people who we know or have expressed interest in our journey.

When I was done with the importing and recruiting, I had around 1000 contacts. About 50 were blocklisted due to hard bounces and unsubscribes. More than 80% were opened. In the end I had around 60 subscribers. Overall, this process went very well.

I also use list segments. I created segments to manage my daily email count which is limited to 300 emails a day in the free version. I am also using segments to help me welcome new subscribers.

There is more functionality in the CRM that I don’t use. Most of it is for sales pipeline like deals and tasks. I don’t have a need for this capability.

Automation

I use automation to clean up my lists. It is the most difficult feature for me because it uses drag and drop to build the workflows. I have only begun to explore its full capabilities.

Flowchart showing a process with two steps: adding a contact to the 'Newsletter subscribers' list and removing a contact from the 'Friends and family' list, culminating in an exit point.

Final thoughts

I really like this application. The only thing I wish I could do is embed the form that allows subscribers to modify their information into my website. I can include it in the newsletter which works for now. This is a minor inconvenience. I would recommend Brevo for individuals like me and small organizations who need these capabilities. There are many more features available in the free version and even more in the paid tiers.

Check out my website and subscribe to the newsletter.

Becoming a creator, my website experience

Over the past few months, I have debated starting a new blog to discuss our ALS journey. I realized we were writing about ALS on the Data on Wheels blog, CaringBridge, Facebook, and LinkedIn. I also created videos on YouTube. Adding another blog would only clutter the message. So, I decided not to move forward.

What changed? At the Walk to Defeat ALS, my wife, Sheila, created some business cards with all those links. It was cluttered. About the same time, I completed the hand off of the Data on Wheels blog to my daughter, Kristyna. She made some changes to the home page which helps users find what they are looking for. This got me thinking. Surprising, I know. Could I create a single location for us to share with people that would make it easier to find our content?

I started a thing…

I researched various options for creating websites using GoDaddy where we already have our domains and email. The primary feature I was looking for was a set of tools that are easy to use. It was essential that any tool I selected be fully compatible with my eye gaze technology.  

I decided to use a hosted WordPress site on GoDaddy. I have years of experience with WordPress. The Kubio plug in added features which helped me create the site easily. (Steve Hughes – Data on Wheels ~ ALS)

I discovered Kubio while looking through WordPress themes. I chose the Rufous theme which includes the Kubio features. This set of tools uses a lot of click to create options instead of code or drag and drop. I can use these tools very effectively with my eye gaze technology.

So many plug ins

I created the website with WordPress on GoDaddy. I use the Kubio Pro plug in to make the design process easier. Right away, I realized the website was missing two key components I used on our WordPress hosted blog: statistics and email. Adding these two features would send me down some rabbit holes.

WordPress.com spoiled me with its included Jetpack stats. Jetpack did not offer a free option, so I chose MonsterInsights. I have set up a Google Analytics account because MonsterInsights uses that data for its reports.

MonsterInsights is a part of Awesome Motive. I bring this up because getting MonsterInsights led me to many other products they have that I added to my website. Here is the list of plug ins I am using beyond MonsterInsights:

  • All in One SEO (AIOSEO) Free. I use this to add focus keywords and optimize my search engine page previews. It also creates sitemaps for search engines.
  • UserFeedback Lite. This lets me add feedback surveys.
  • Duplicator. I use this to create backups of my site.
  • WPForms Lite. I created my contact form with this plug in.
  • WP Mail SMTP Pro. I needed to upgrade to Pro to use Microsoft 365 email services.
  • WPConsent. I customized and added a cookie consent form. Cookies are used to improve my analytics.
  • Broken Link Checker. It currently only validates internal links. I am evaluating an upgrade to Pro to check external links.

Except for WP Mail SMTP Pro, I am using the free versions of these plug ins. To support AIOSEO, I had to set up accounts with Google Search Console and Bing Webmaster Tools.

I also use Super Page Cache and Optimole to improve performance on my site. Optimole is used to improve image performance. I am using the free versions of these plug ins.

Subscription support

One big piece of functionality that I wanted was subscription support. This was more difficult than I thought it would be. You need a CRM to manage your subscribers or contacts. Then you need a marketing platform to send emails out to your subscribers.

Thankfully, there are many options out there that bundle these together and work for small operations like me. I chose Brevo based on research, reviews, and the right price, $0. So far, it is working well for me. I did have to upgrade my email accounts with GoDaddy to make them compliant with the various email services. Otherwise, my emails went directly to junk. I am looking forward to learning more about this platform. I created my subscription form with Brevo and will use it for my newsletters.

As you can see, I have learned much so far. It will take time and patience to get better at this. My intention is not to scare anyone who might be considering this. Remember that I first created the Data on Wheels blog in 2010 with minimal effort. I wanted to use this platform to be more creative. This option makes that possible and has been code free which has made it easier for me to build using eye gaze. That’s right, this site was created “hands free.”

My first year on full disability, wow!

What a year …

At the end of May 2024, I went on full time disability. For the first time in my adult life, I was not fully employed. I remained engaged as a Microsoft MVP on data platforms by creating a video series on Microsoft Fabric called “Fabric 5”.

The series focused on key architectural principles to be considered when implementing Fabric in your organization. This includes medallion architecture options, security considerations, and business continuity gaps. I started the series using my voice even though I would lose my breath. Along the way, I would start talking with my mask with the help of captions. Eventually, I would use an AI generated voice from Team Gleason to record the videos. I would close out 2024 with a four-video series on business continuity.

That brings me to this year. I started the year in the hospital for most of January and the start of February with pneumonia and breathing problems. During my stay, I had to get a tracheostomy which took away my ability to talk because I also require full time ventilation. After I got home from the hospital, I needed a few months to recover. ALS sucks! As I started getting “back on my feet,” I have worked with my eye gaze system from Tobii Dynavox to communicate, work on my computer, and type. I am using that system to create this blog post.

Eye gaze keyboard, I type one key at a time.

Now what?

I am going to try to write a couple more blog posts. I need to see if I can create videos. I am working through my new normal and not overextend myself as fatigue is a real issue with ALS. I am excited to contribute as I can. As always, I am thankful for the support and prayers from the data community.

The Next Phase & A Fresh Start

Steve walking down a road in Yosemite

As of June 1, I am no longer an employee at 3Cloud. I am now officially on long term disability. This marks the first time since I graduated from high school that I am not working full time in some capacity.

A Little History

Bethany House Publishers logo

I started working with technology around 1995. My career started with Microsoft Access with which I built a warehouse management solution for Bethany House Publishers.

Magenic logo

I was recruited from there to work with Magenic as a VB developer. I learned about SQL Server and fell in love with databases. From there I learned how to use Analysis Services and really enjoyed working with MDX. That is right, I actually like working with multi-dimensional models and with MDX. I continued to work with these tools and built up a good reputation and skillset in that area. Star schemas and multi-dimensionality just made sense to me. During my time at Magenic, I developed my technology leadership and presentation skills. I became a Practice Lead and drove business and technical expertise in the data (SQL Server), collaboration (SharePoint), and integration (BizTalk) areas.

Xata truck

My time there was split around a stint at Xata, a transportation management company. It was here that I created Data on Wheels. This became the brand I would use for the next 14 years to disseminate technology learning in data and business intelligence. I would eventually move over to Pragmatic Works to continue my focus on data.

Original Data on Wheels logo
Pragmatic Works logo

While I was at Pragmatic Works, I started to specialize in presales and would eventually lead that team. I would go on to lead the entire consulting organization. During that time, I would spearhead the move to Azure and cloud data work. We would eventually be acquired by 3Cloud and grow their data team substantially. I worked closely with management to help grow the data business including building up our Microsoft Fabric expertise.

3Cloud logo

In my second year at 3Cloud, I was diagnosed with ALS. This would change my career and life in so many ways. The company has treated me very well given this situation. They have given me great support through this journey right up to the very end of my time there which was at the beginning of June 2024. I am happy that they stood by me through all of this. I wish them the best as they continue to grow and become the best Azure company in the world!

What’s Next?

Fabric 5 thumbnail

In the next phase of my journey, I plan to continue to give back to the data community for as long as I am able. I will try to speak when I can, which will depend on how I am doing and how I am sounding. I also plan to continue recording Fabric videos. My hope is to do some additional content on accessibility with Fabric including how to use various features to support development in practical ways (I will not be typing a lot of code). I am going to work with CoPilot in the various tools such as Fabric, M365, and Windows and share how it can help someone like me continue to be productive in a work setting.

I will continue to educate anyone who will listen on ALS and how to keep living with it and working with it. As this disease continues to ravage my body, my plan is to continue to share how to work with it and how to enjoy the best life you can while you can!

I will not give up!

I will not give in!

I look forward to sharing journey with all of you and I hope you enjoy it with me. Thank you for all the support through the years and all the support yet to come.

For I know the plans I have for you,” says the LORD. “They are plans for good and not for disaster, to give you a future and a hope.” – Jeremiah 29:11 (NLT) (emphasis mine)