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.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 12 Aug 2021

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.

Posted in Blog | Tagged , , , | Comments Off on More Interactive Notebooks from MS Docs

Digitizing Construction

Perhaps you think of the construction industry as being more analog and less interested in building a robust digital infrastructure. This article talks about one large company that is modernizing, and has accelerated that move during the pandemic. They are generating lots of data with drones capturing images of projects and and with more collaboration between many different groups that are often not physically co-located together. While their business is construction, they are really a large enterprise that faces many of the same challenges any enterprise faces with moving information around, in a secure and convenient way for their staff.

However, even smaller companies are depending more and more on a modern infrastructure. I had a contractor renovate my bathroom recently, and while there certainly is some in-person work, plenty of the planning, payment, supply chain, and more comes from the use of digital technologies. Even a 55 year old contractor is embracing new ways of doing business.

This isn’t just in new construction. Many repair companies around the US are consolidating and joining into groups, with better guarantees for their work, but also more precise scheduling, bidding, smoother (and quicker) payments, and even the sharing of designs and problems through images, reducing the number of physical trips that staff makes, and giving a better experience to the customer. This does come at a charge, often with a higher cost for projects, but I find that I can count on many of these services more than I could with random handy people and contractors in the past.

Construction will always be a hands-on job for some.  After all, plumbers need to go where the pipes are located. The workers and their companies are taking advantage of more technology and innovations to make their jobs easier. We use new materials, new techniques, and products that make the construction of physical spaces, and the deconstruction, quicker and easier than in the past. In many cases, we often get a superior product, though there is often more cost.

There are also problems. Any time someone is building something, there is a chance they make an error, or a physical part fails, or the supply chain doesn’t keep up. It does seem that I tend to find fewer of these issues than in the past. When I do, often an organization will fix a problem and stand behind their work. If they don’t, the one part of the digital world that definitely affects construction is the sharing of information by customers. Bad ratings, complaints, and more are common, and can often affect business for contractors quite a bit. Positive ratings can result in more work than an individual can handle.

Maybe that’s the part I like the best, that the digital connections we have online allow us to share feedback and images of workmanship. At least in my area, that’s led to some good outcomes.

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Tagged | Comments Off on Digitizing Construction

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.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 11 Aug 2021