Daily Coping 14 Jan 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 learn something new and share it with others.

I do try to share things, and years ago I added tips, tricks, etc. to my blog. I’ve gotten out of the habit, but I changed that recently. I took the time to share something I learned.

The rear hatch on my X5 stopped latching. In fact, I was driving back from the store and saw the interior light on in the trunk. When I got home, I couldn’t get it to close. I ended up taking some time to find the issue and repair it, but then I took a few pictures and added a blog entry.

Hopefully it will help someone else.

Posted in Blog | Tagged , , | Leave a comment

RIP Gareth Swanepoel and GoFundMe

Last week we lost another SQLFamily member. Gareth Swanepoel passed away on 8 Jan 2021. He was a fellow speaker, jolly fellow, and Microsoft PM. Across many years of seeing Gareth at events and chatting with him, he was one of the happiest people I had the chance to. He always had a smile, a joke, and something pleasant to say.

He is yet another sad casualty of the COVID-19 pandemic.

If you’d like to donate to help his family (kids and spouse), there is a GoFundMe for the Gareth Swanepoel Memorial Fund out there raising money. Please feel free to.

Todd Kleinhans maintains a SQL Memorial, to which he has added Gareth and others we have lost in recent years.

Some Memories

One of my memories, just one of many. I was lucky enough to run into Gareth at numerous events over the years:

ErQhoBkW8AElDdS

I saw his tattoo, which made me smile:

This is a great photo from Monica Rahbun:

This might sum things up well. A happy guy, always looking to have fun:

Posted in Blog | Tagged , | Leave a comment

Security Updates for SQL Server Jan 2021–CVE-2021-1636

There was a security bulletin (CVE-2021-1636) for SQL Server, an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running.

SQL Server has released a number of patches. You can see them on the Release blog, but there are KB links below. If you have any servers that potentially can be accessed by unauthorized traffic, consider patching them.

SQL Server 2019

SQL Server 2017

SQL Server 2016

SQL Server 2014

SQL Server 2012

For SQL Server 2016 and earlier, make sure you are at the Service Pack levels listed. If you aren’t, you cannot patch these instances.

Posted in Blog | Tagged , , | 1 Comment

Getting a New Remote Git Branch–#SQLNewBlogger

I was notified of a new PR at DataSaturdays, and I went to look at the changes. In this case, a lot of styling items in the code, which I can’t quite picture. I also wanted to check the behavior of some sorting changes. How could I do this?

I saw the branch, but I wasn’t sure how to get it locally. For me, I started with Google, which too me to StackOverflow. Here I found an answer.

I have git v2.29, so I could probably have used just the checkout command, but I ended up doing this command:

git fetch

which got me the new branch.

2021-01-05 10_27_18-cmd

From here, I did a checkout of this branch, tested the code, and then could approve the PR.

I know I’ve likely had to get a branch before, but I am hoping that writing this post will help me remember.

SQLNewBlogger

This is a skill that is handy for working with code, and these days, even infrastructure and management. Git is an important skill, so showcase some things you learned, how, and why, on your blog.

This post took me about 6 minutes to write.

Posted in Blog | Tagged , , | Leave a comment