Voice of the DBA

Tag: syndicated

  • Daily Coping 13 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 make some tasty food for someone who will appreciate it.

    An easy tip for me, and one that I do often and get joy from doing it.

    The other day I was trying to decide what would be good for the family. During a recent camping trip, a few people had enjoyed the kebabs that someone else had purchased, so I decided to do some at home. A couple people here hadn’t had them, so I grabbed shrimp, steak, and vegetables from the store and then put them together.

    20210802_194752

    I was a little quick, as part of the family was finishing horse chores, so I dropped them in the microwave to keep warm.

    They were a hit.

  • 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.