Category: Blog

  • Daily Coping 12 Aug 2021

    I started to add a daily coping tip to the SQLServerCentral 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. 

    Today’s tip is to smile and be friendly to the people you see today.

    I’ve used this tip before, during the mask mandates, and this was harder to do. With fewer masks in my life, this is easier.

    I find this to be a good habit of mine. Smile and wave to people, whether I know them or not, no matter what the situation, just be pleasant.

    It makes the world better for all of us.

  • More Interactive Notebooks from MS Docs

    I saw a note from Microsoft recently that they are trying to improve some of the support experiences for customers that are going through their docs. The idea is to make it easier for a customer to get a rich code experience for troubleshooting or learning.

    This is a preview feature, but here’s a quick look.

    Full Transaction Logs

    For some people, the transaction log gets full. Not for me, but it has happened in the past, and I’ve learned how to be proactive here. However, this topic might be the number one topic at SQLServerCentral over the years.

    Microsoft has a docs article on troubleshooting a full transaction log. In the article, at the top, is a new button. You can see here, this will open a notebook in ADS.

    2021-08-10 17_50_23-Troubleshoot full transaction log error 9002 - SQL Server _ Microsoft Docs — Moz

    When I click this, I get a security warning and do I want to open this with an app.

    2021-08-10 17_50_27-Troubleshoot full transaction log error 9002 - SQL Server _ Microsoft Docs — Moz

    Then I get the app chooser:

    2021-08-10 17_50_34-Troubleshoot full transaction log error 9002 - SQL Server _ Microsoft Docs — Moz

    Then ADS opens.

    Well, kind of. I have to approve something else.

    2021-08-10 17_51_54-Welcome - AdventofCode - Azure Data Studio

    And again.

    2021-08-10 17_52_00-Welcome - AdventofCode - Azure Data Studio

    I appreciate secure computing and good practices, but this type of clicking again and again is going to get people to do the “run everything as sa” security mindset and start to always allow things to open.

    In any case, I do get a notebook. The text is the text of the KB article, which is comprehensive.

    2021-08-10 17_53_43-● T-Shooting_LogFull_9002.ipynb - AdventofCode - Azure Data Studio

    The code is included, but I can run this case. Not cut/paste, not mess with, just connect to an instance and run it.

    2021-08-10 17_53_53-● T-Shooting_LogFull_9002.ipynb - AdventofCode - Azure Data Studio

    There are instructions for fixing things.

    2021-08-10 17_54_01-● T-Shooting_LogFull_9002.ipynb - AdventofCode - Azure Data Studio

    And there are options for how to solve different issues, some of which also have code.

    2021-08-10 17_54_08-● T-Shooting_LogFull_9002.ipynb - AdventofCode - Azure Data Studio

    To me, this is a great way to help customers quickly solve issues. I look forward to seeing how this goes, and how people use it. For now, I know there are two articles in preview, if you want to give this a try.

  • Daily Coping 11 Aug 2021

    I started to add a daily coping tip to the SQLServerCentral 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. 

    Today’s tip is to spend time wishing for other people to be happy.

    This has been a hard 18 months, going through the pandemic and not being able to live life as I would have expected. However, it hasn’t been that hard for me. Some tough times, but really, my life has been great.

    I know many others haven’t been as lucky. I’ve known a few, and I’ve read about others. I also know that in general, lots of people struggle in life, working very hard for little, and dealing with stress, hunger, fear, and more on a daily basis.

    Today I’m stopping for a minute to think about kids that don’t get enough to eat every day. As poor as I was a few times in life, I didn’t miss meals. That’s not always the case, and hope that life goes better for these kids and they find joy and happiness somewhere in their lives.

  • T-SQL Tuesday #141–Finding a Balance

    tsqltuesdayThis is a great topic, and the host is a good friend, TJay Belt. We’ve met each other’s families and a lot of our conversations revolve around non-work stuff. I actually am friends on Facebook with TJay and follow his outdoor adventures on a weekly basis as he hikes, bikes, boats, and more.

    This month he asks us to write about Work/Life Balance, which is an important topic to me.

    Work From Home

    My first attempts to find balance started at the turn of the millennium. Actually in 1999, when I worked at a financial services company. We had instability in systems, to the point that I kept a pillow in my office as I spent more than a few nights there.

    After that I changed jobs a few times until I finally went to work for myself at SQLServerCentral. Since then, I’ve been at home for 18 years, including through this pandemic. A few things that I’ve learned in that time.

    Be Flexible

    The first time I was at home regularly was sharing an office with my wife, who had been telecommuting for a company for quite a few years. She was on the phone a lot, so I learned to keep headphones around, or be ready to grab my laptop and go work downstairs.

    I also learned that things come up at home. Maybe my wife was planning on getting kids and a meeting popped up, or vice versa. It was helpful to be flexible and ready to adapt.

    Set Some Rules

    When my wife started working from home, we had a 5yr old. He was pretty good with rules and learned to be quiet when the door was closed. A couple years later, our second was born, and that was a challenge. We had a nanny, and that was helpful, but we slowly had to  teach the 2nd (and 3rd) rules about noise and disturbances.

    On the plus side, we learned to be flexible and make time for kids. If they needed some attention and we weren’t busy, give it to them. Include them in breaks, walks, or head to school. I loved going to lunch with my kids when they were at school in 1st, 2nd, 3rd grade.

    Blending Chores

    One thing that helped me is that I blended work and life when at home. My boss or coworkers wouldn’t hesitate to ping me if they needed something at 6pm, or now, 7am, and that’s OK. However, I also know that doing laundry, or prepping something for dinner, or even cutting grass are things I might do as a break from work or while listening to a call.

    I mixed my life with work, taking advantage of the proximity. In an office, I might wander to the break room, or go talk to someone and do a little less work. Here, I try to get something done. I’ve taken an hour to change oil or put on winter tires in the middle of the day, and it sometimes lets me return to work refreshed.

    At the same time, if I have a bunch of chores, it’s much easier to go back to work after dinner for an hour if I need to get something done.

    Set Some Hours

    At first I tried to make a strict set of office hours and work from 8-4, like I was in office. That didn’t work for me. It felt like I was not taking advantage of being at home, around kids at times, and more.

    However, I also learned to get away. I am lucky in that I’ve often had a separate office, but I have had laptops or other devices around the house. I’ve learned not to check email or do work when I’m not working. If I use the computer to check something for life, I don’t spend time looking to see if I’ve missed something at work.

    Spoiler: I’ve always missed something and it’s almost always not that important.

    I do, however, make up time if I have had a bad week. When I struggle to work, it’s hard as a creative person. In an office, I’d listlessly sit at my desk and let time pass me by. Now I get up and go do something to help myself.

    I’ll then make up that time in the evening or on the weekend.

    Time Zones Suck

    I work for a UK company in Colorado. I’m GMT-7, which means I really have a few hours in the am when I can reach people in the UK and work together. I also get some people scheduling things at 7am, or even 6am, my time. Not often, but it happens. We have an office in CA, and I sometimes get messages around 6pm my time, just before someone there knocks off.

    I roll with this. My wife hasn’t been thrilled, but during the pandemic I’ve had a lot more 7am calls than ever before. A ton at 8am. I just deal with it because it’s not every day, and the flexibility is a trade off. I’ve done plenty of 9am yoga classes, taking an 8:00-8:50 call on the way and in the parking lot. They deal with it, so I can as well.

    Remember

    We work to live, not the other way around.