#TSQL2sday #137 Invite Using Notebooks Every Day

Posted on April 6, 2021 by way0utwest

tsqltuesdayIt’s time for the T-SQL Tuesday blog party, and I’m hosting this month. I don’t host too often, but since I had some schedule mix ups, I’ll handle this month. Read the invitation below and then write your post for next Tuesday, Apr 13.

If you want to host a T-SQL Tuesday, let me know. You can ping me on Twitter.

Jupyter Notebooks

I first heard about Jupyter Notebooks years ago. At the time I was just getting started in Python and I thought these were a great way to share code online with others. However, the setup and administration was a pain, and I quickly gave up.

When I saw Microsoft add notebooks to Azure, I got slightly excited again, but once again, it was a bit of a pain to work with these. Too much administrative overhead, in my opinion.

That changed a bit with Azure Data Studio, which has seen notebooks get added, and become easier and more stable. If you haven’t tried notebooks, get ADS and give it a try today. I even wrote a short piece on using these.

Your Invitation

For this month’s T-SQL Tuesday, I want you to write about how you have used, or would like to use, a Jupyter notebook. This seemed to be exciting for many people at first, but I haven’t seen a lot of uptake from users in general. So I’m curious if you are using them.

A few resources for you:

There is even a way to run these from PowerShell.

So let me know how you are using notebooks, or your plans for the future.

Publish your post sometimes on 13 Apr, UTC time.

The Rules

Publish your post sometime on 13 Apr 2021, UTC time.

Leave a comment or traceback on this post.

Use the T-SQL Tuesday logo at the top of this post in your post and link that back to this invitation.

Spread the word.

Posted in Blog | Tagged , | 15 Comments

Daily Coping 6 Apr 2021

Posted on April 6, 2021 by way0utwest

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 appreciate nature around you, wherever you are.

I am lucky that I live in a rural area, with animals, so nature is always around. I try to get outside and regularly enjoy and appreciate how amazing nature can be. I’ll stop and watch the horses, or even pause during a drive to see the deer run by.

Recently I went on a hike with family and dogs, and while we went through an open space near neighborhoods, I stopped to look and enjoy the trees, the landscape, more of nature than just animals. Apparently my dog was interested in the trees as well.

20210320_134939

Or maybe what was behind them.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 6 Apr 2021

Running Scripts in Parallel with SQL Multi Script

Posted on April 5, 2021 by way0utwest

One of the lesser known tools in the Redgate Toolbelt is SQL Multi Script. While few customers used it, those that did loved it, as it solves a problem that many people have: deploying a script to a lot of servers at once. While Central Management Servers help a little here, they don’t quite have all the features of Multi-script, which is not only a management, but a deployment tool as well. With companies using sharding and multiple systems for clients, this is becoming more important all the time.

A few years ago a customer asked me if we could make this run faster. At the time, we had limited the tool to 25 threads at a time, which made sense when it was developed. However, with modern hardware, I asked the developers to remove this limit. This was an easy change, and now you can scale up your script execution.

You can do this with the “Application Options” in the menu. As you see below, parallel execution is enabled.

2021-03-24 09_59_07-Application Options

What’s more, this value is dynamic. If you start executing this agaisnt a series of databases and need to scale up or down, you can change this value and it will take effect immediately.

If you’ve never given SQL Multi Script a try, and have the need to run scripts against a lot of servers, give it a try. It’s a little known, but incredibly valuable, tool.

Posted in Blog | Tagged , | Comments Off on Running Scripts in Parallel with SQL Multi Script

Daily Coping 5 Apr 2021

Posted on April 5, 2021 by way0utwest

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 take an extra break or two today during work.

I had to do this last week a few times. After the snow in Colorado, I went out a few days to help my wife clear things up and ensure animals were cared for. In doing so, I decided to manhandle the tractor front bucket to get it connected. Doing so, I ended up tweaking my back.

As a result, I decided to give myself a few breaks during the next couple days, not pushing too hard, but taking some breaks to relax and rest a bit during the day. I didn’t want to completely stop life, but I recognized that I needed to go a bit slower.

I am usually pretty good about taking breaks, but not always. I’m trying to be more consistent, especially as my day often starts early to talk with UK colleagues. I need to remember that if I’m working until 5 or 6, I need to have breaks in the middle.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 5 Apr 2021