So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More often than not this leads to the “not seeing the trees through the forest” syndrome as my grandfather used to call it.
Sadly this happens to me more than I like to admit. I am tenacious when it comes to problem solving and I don’t like to “give up”. However, once I hit that mentality of “I’m not going to let this problem beat me” is when I most need to take a break.
I have found that if I quit focusing on the problem at hand and do something else, often times not work related, for a few hours when I come back to the issue I solve it within 10-15 minutes.
Case in point, just yesterday I was troubleshooting a Power BI Data Gateway issue. We had the Gateway installed and configured. The Power BI Service could see and communicate with it so we were all set to create our first data source.
We entered in all our information about the data source and when we clicked the Add button, it came back with a failure. It was a very generic error that didn’t really tell us anything. I searched the Power BI Community forums only to find that we had done everything correctly. I was stumped, but I started down the path of “I’m not going to let this problem beat me!” Right then is when I should have put it down and walked away. But no, I kept doing the same things over and over again expecting a different result (and we all know what that leads to – CRAZY town).
I was forced to take a break and go coach my swim team of 6-12 year old kids. I completely forgot about the problem for 2 hours while I coached and talked with my kids. When I got home and sat down at my desk, I had an epiphany. Check the Gateway logs! Wow, why didn’t I think of that before?! I discovered that the gateway had gotten itself into a bad state so I restarted the gateway service and was able to successfully create the data source using the data gateway. That took less than ten minutes, sheesh. If only I’d been forced to coach swim team earlier.
So the next time you encounter a problem and just can’t seem to figure it out, take a break. Give your brain something else to focus on and you just may save yourself from a trip to CRAZY town.
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to do another smaller event. They are much more intimate and offer a better chance of engaging with attendees, sponsors, organizers and other speakers.
I heard about a smaller event called SQLGrillen that took place in Germany. Their motto is “Databases, Bratwurst and Beir”. How cool is that?! But alas, I missed the call for speakers deadline, so I kept my fingers crossed that the event organizers would put it on again this year and low and behold they did. They’ve changed the name to DataGrillen, but it’s still the same cool event.
I submitted a session and to my surprise and amazement, I was selected to speak. I will be giving my Profiling Your Data session on Friday, June 21, 2019. Now my German is very limited (Nein, Ja, Bitte, Bier & Bahnhof) but I’m still excited and I hope to see you there.
The event is already sold out, but they do have a wait list. If you want to go get your name on the list as soon as possible because it’s FIFO.
Auf wiedersehen for now.
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s what I call a gift that keeps on giving.
I have always wanted to attend SQLBits so I decided that 2019 would be the year I would finally attend. Since I had decided to attend, I thought, “what the heck, why not submit session? I’m going to be there anyway.” But never in my wildest dreams did I ever expect to be selected. I will be presenting my Profiling Your Data session.
It’s been twenty years since I was in England and I am super excited to be going back. I have family ties to England so I added a few extra days for sight seeing. Last time I was there I visited Malvern Link, home of the Morgan Motor Car Company, my dad’s favorite auto manufacturer. This time I am planning a quick trip over to Liverpool so I can see where my Dad’s favorite band (and one of mine) was started, you may have heard of them, they’re called The Beatles
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January 12, 2019.
I’ve been to Nashville before, in fact I was just there last June for Music City Tech, and am super excited to be going back.
I will be presenting my Profiling Your Data session. If you’re in area and haven’t registered yet, there are still seats available, you can register here.
Feel free to stop by and say, “Hi”, I’d love to see you.