Author: way0utwest

  • What’s Important to Your Organization

    I’ve had the chance to work in a number of organizations in my career. Every one of these places needed to run a network and software applications to support the business. Most of them also built a portion of the software they used, with some applications being purchased. No matter how much software they built, whether it was a lot or a little, there was always a need to manage a software lifecycle. Whether you build or buy software, you will have new applications, patches for existing systems, and the retirement of others over time.

    While every organization recognized the value of software, some saw this as an expense, like salaries or buildings. The funds needed for computing the “cost of doing business.” In organizations that felt this way, there was always a focus on controlling or reducing costs, doing just what needed to be done, and being efficient with how computing was used. These organizations seemed to be stodgy and traditional, with management focused more on the analog world than the digital one. Some were quite successful, which I often think is a combination of good management, good staff, and luck.

    These days, I think that view the software is an expense is less and less successful in many industries. Over time, this view will see a deterioration in the success of those businesses compare to competitors that treat software differently. It might be a slow decline over decades or a more rapid one in a few years. I truly believe in software eating the world, and every company needs to be a technology company. They don’t all need to build software, but they do need to manage it, and more importantly, take advantage of software to better run their businesses.

    We see this in all kinds of industries. Perhaps it’s highly visible in the automotive industry these days, but in plenty of others, from finance to insurance to retail to manufacturing, the use of software as a strategic asset improves the competitiveness of business. Even in government, organizations are finding that making better use of software allows them to offer more services at a lower cost.

    I wonder how many of you see your employers treating software as a strategic part of their business model. Do they aim to increase profits or become more efficient or even innovate in their industry with the power of modern computing? Or is it just a tool that they depend on, and consider the cost of doing business? If your group isn’t seen as strategic, likely they don’t value your work as highly, don’t provide training, and don’t create opportunity or innovation that ensures your work is interesting. If those are things that matter to you, perhaps it is time to look around for other employment.

    Steve Jones

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