I’m getting ready to board a plane now, heading to Orlando for the first live SQL Saturday in 2021. I’m excited and looking forward to seeing friends that I’ve missed. I hope to meet new people and enjoy the event.
This is only a live event, so no hybrid broadcast, but I’ll get pictures and video and write up a report next week on how things went.
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 plan a fun or exciting activity for the weekend.
This weekend is SQL Saturday Orlando 2021, and I’m traveling today down to the event. I’ll be there until Sun am, when I’ll head home. It’s a bit of work, but I’m planning on seeing lots of people, during and after the event, which should be great. It’s been a long time.
Also looking forward to a good Cuban sandwich, usually my routine before I return home.
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 be kind to yourself; remember progress takes time.
As I’ve gotten older, I’ve started to relax and understand how time impacts my life. While some things seem just a few days ago, I also appreciate all the wonderful memories across the years.
For me, I am stressed now by a lot of chores that need to get completed before winter. A busy spring got me behind, and while I’ve been working to catch up, I’m also trying to live the rest of my life and not get single minded-ly tracked on just chores.
One of my chores, which I’ve written about a few times, is cutting the pastures. 35 acres is a lot of stuff to manage, and I’ve been trying to get out 1-2 times a week and make some progress. It feels like things will never end, but just this week I hit a milestone.
I’d been going out and getting the land in front of and next to the house cut. This is about 15-18 acres of land, and it feels like cutting it cut will take forever. Even with a tractor and PTO mower, it’s slow. I’ve been getting more cut, and this past weekend I went out both days for multiple hours. With the temperatures dropping and wind blowing, not to mention lots of dust, it was a bit miserable.
However, I finally managed to get the front completely cut with the tractor. There are a few spots on the side of the house that I need to cut, but they’re small and the riding mower will work. Getting the majority done means I don’t need to try and get the tractor out from through multiple gates and coordinate with other employees.
It’s taken time, and I kept reminding myself. Now I can see that all that patience paid off.
Doesn’t look like much, but the 3ft weeds and grasses, not to mention yuccas are gone.
Now I need to work on the other 15 acres of pastures across the next few weeks.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
The other day I was working with a licensing issue and someone requested my MAC address to track something down. I know I could dig into the adapter properties, but that’s an annoying set of clicks in Windows. I decided to spend that time checking out how to get the MAC address from a command line.
I tried “ipconfig” at the command line, which I always have open. I got my IP and DNS info, but no MAC. A quick search on Google showed me I needed more detail.
ipconfig /all
This gives me all the info, as you can see below:
I’d prefer PowerShell for many things like this, mostly because I could programmatically extract the values and use them elsewhere. I don’t need that here, but I might for something.
In this case, this is in the WMIObject, which is an ugly command. I’ll never remember this.
Get-WmiObject win32_networkadapterconfiguration | select description, macaddress
However, there’s an easier cmdlet.
Get-NetAdapter |select MacAddress, Name
This will return what I want. I get see which MAC is associated with which adapter.
Both quick ways to get some information.
I had to get some info, and I took a minute to learn something. This took me just 2-3 minutes to learn how to do this and practice. Then it was less than 10 minutes to do this post.
For reference, I used these links:
