Category: Blog

  • Solar Projection v Estimates

    We got a solar system in 2022 to try and fix some of our power costs and hedge against the future. We were fairly confident it would work well, but weren’t 100% sure. So far, it has reduced our power bill quite a bit, though it’s a bit hard to tell right now if this is actually saving much money.

    However, the performance is above what was estimated. I’ve built a Power BI Report that tracks the actual production v the estimates. So fat, almost every month has beaten estimates and our power production is well above what we expected.

    Given the fact that power prices have increased in CO and I expect more increases to come, this is nice.

    I can’t embed the report here, but this is an image of the report:

    Power BI report of production v estimates

    I need to add some more costing here, but our current bill is often around $22/month, of which $13.50 is a connection charge. Usually we are paying around $8-12 of demand charges for peak usage from 4-8pm. Hard to get the family to slow down here, and there isn’t much solar during this time.

    This is, however, much better than last Nov/Dec, when we had $220 bills. Even with the loan payment, I think we’re paying less than in the past.

  • Daily Coping 28 Dec 2022

    Today’s coping tip is to look for something positive to say to everyone you speak to.

    This works well during the holiday season as most people are in a good mood and share happy thoughts. Just before Christmas, as we ran a few errands before the holiday, I made it a point to do this. My efforts:

    • Tell the person checking me in at the gym they looked nice
    • Tell my yoga teacher that I appreciated her holding the class as it was welome
    • Wish a friend in class happy holidays and ask about their family, hoping they enjoyed the time together
    • Thank, tip, and complement the person making my coffee on their outfit after class.
    • Wish all cashiers happy holidays.

    I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

  • Join me at VS Live Las Vegas 2023

    I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited to go to a new place, and I’m looking forward to seeing lots of friends at the show.

    If you want to join me at fun show, register with the code Jones for $500 off the price.

    VS Live is a multi technology show. I always learn something interesting there from Brian Randall, Rocky Lhotka, Bob Ward, Andrew Brust or any of the other amazing speakers. There are lots of development sessions, both technical and soft skills, along with a few of us data people delivering talks on how to deal with the database and power your software.

    The schedule is up and it looks exciting. I have sessions I’m delivering:

    • Architecting Zero Downtime Database Deployments
    • Adding Graph Structures to your SQL Server Database

    There are lots of other great talks as well, so think about kicking off your 2023 development efforts by coming to  VS Live Las Vegas, Mar 19-24, 2023.

    Register with the code Jones for $500 off the price.

  • More DevOps with the SQL Solutions Group

    I’m doing another webinar on Jan 18, 2023 with the SQL Solutions Group.

    You can register here and reserve a spot.

    Scott Klein and I did a webinar last summer, where we talked about SQL Server and how it integrates into DevOps. Since then, Scott has been working with some clients on integrating DevOps. We’ve talked a bit about the challenges they’ve faced and we decided to do another webinar, going over some of the challenges clients face in moving to a DevOps style of software development.

    Join me on Wed, Jan 18. Be sure you register for the event and set a reminder.