Hello Dear Reader, what a week! On Thursday my wife and I closed on a new house. We are so incredibly excited! We owned a house for a very short period of time. When we bought the house we did not look at the school districts.
When the kiddos came to live with us full time during the pandemic we quickly found out the schools were..... really bad. Great neighborhood, beautiful house, bad schools. So we quickly came to the conclusion that we would have to move.
We found and even better neighborhood, AMAZING schools, but the cost was the house. We hadn't owned long enough to get much equity. As a matter of fact we lost quite a bit of money. We sold during the pandemic before the housing market went crazy. We thought we would save for a year and then buy a new house in this great neighborhood. What's the old phrase? "Man plans, God laughs". Yeah, the housing market went nuts. One year turned to two, two years turned to three, and three looked like it would turn into four. With three months left before our lease expired I did a lot of calculations and found we might be able to get a house. AND WE DID!!!
We had just started to really enjoy doing the small things that make a house yours. The best part is we only one mile away from our old house, so we get to keep the same awesome schools, we stay in the same neighborhood, and I get to keep my same running & walking routes!
Josh Luedeman (Twitter | @JoshLuedeman), Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri), Daniel Taylor (Twitter | @DBABulldog), Andres Padilla (Twitter | @nodestreamio), & myself all decided we should submit to the conference. The really amazing part, as much time as we've spent with online we've never all gathered together before. Josh, Neeraj, & I had met pre-covid during work trips, but Andres & Dan had joined our team during the pandemic. Our good friend Bradley Schacht (Twitter | @BradleySchacht) from the Azure Synapse Product Group joined us!
We started out with a nice dinner on Thursday and the in person preparations began for our pre-con DBA 101: A Full Day of Fundamentals. We had a great group of gentlemen that joined us for the day. We covered a lot of basics about SQL Server and the Cloud, specifically Azure, but we made sure people understood how to translate that skill set.
We did a lot of group exercises, starting with building on premise, hybrid, and cloud architectures. Then applying SLA's, RTO, RPO requirements so we could discuss how to configure backups, high availability, and then disaster recovery.
We reviewed basic security within SQL Server which translates to Azure SQL, as well as some basic Identity topics covering AD & AAD. Great group of people and a great way to kick off Friday.
Friday night took us to the SQL Saturday Speaker dinner and then a group activity we had planned together watching the Guardians of the Galaxy 3. No spoilers. Great movie and a really nice send off to the trilogy.
After that we headed back to the hotel, hung out, had some nice conversations, and then went to sleep so we could start the big event, SQL Saturday.
All of us who have been in the community for a while have seen the ups and downs that happened during the pandemic. We all had a lot to deal with in that time, and there were some devastating losses for me personally. Maybe next year I will write about it, but there are some areas that are still to raw for me. I'm sure there are for a lot of people. I tried to remind myself during that time that in the middle of something you cannot see the end, nor can you see the recovery. I held fast to the idea that they would occur.
In the SQL Community I have made so many close deeply personal friendships, that calling people "friends" hardly does justice to what I feel. Of those people Karla & Rodney Landrum are up there at the top. The last time I saw them they came to Orlando to visit. Karla, Rodney, Sue, and myself went to Chef's in the Paris district of Epcot. We also had them over to the house. I cooked, Karla mixed the drinks (which I loved still to this day!) and we had a fantastic time. That was 2019. There is no way we could have known how long it would be until we saw each other again, what we would have encountered. It was all I could do not to breakdown crying as I hugged Karla.I didn't realize she would be there, and the joy I feel even know days removed is palpable. I'm so glad we are having in person events again. I'm so glad I get to see my friends, donate my time, and teach people. If you have a SQL Saturday happening near you, you've got to check them out, I cannot recommend getting involved enough.
Ok, over to the recap.
MONDAY 5-1-2023
On Monday Josh Luedeman published his first video, way to go JOSH!! Josh's video Setup Windows with Chocolatey for Data Developers walked us through using the Chocolatey packages to install and configure post-Windows installation tasks easily!
He installed Git, WSL 2, Ubuntu, Spotify, Discord, PowerShell, Azure Data Studio, SQL Server Management Studio, and Signal! If you find yourself setting up a new Windows computer, this is a fantastic shortcut to the installation process.
WEDNESDAY 5-3-2023
On Wedneday we released my latest video on creating a Dynamic Pipeline in Azure Synapse & Data Factory!! This is a process that I've walked many customers through over the years. The key is we are trying to minimize the number of Source & Sink data sets created to import data in this video.
Dynamic Pipelines are incredibly powerful and can be used in many different ways. This was just one of them, but based on the reaction from you Dear Reader, we will be showing a few additional ways this can be used!
What an amazing week we had last week, and it's only going to get better! This week we have Andres & Neeraj presenting Computer Vision with Azure ML Studio that will be live today at 1 PM EST.
I will have another video this Wednesday, and of course our Tales from the Field Azure Data Community Round table will be this Tuesday Live at 1 PM.
I'm sure we will figure out some adventure to have this weekend, alright Dear Reader. Time for me to head out, as always Thank You Dear Reader for stopping by.
Hello Dear Reader! My lastest blog on our Azure FastTrack blog for Microsoft is live, Monitoring Deadlocks in Azure SQL Managed Instance.
Here's a little from the blog:
To paraphrase Annie, Deadlocks ARE JUST AWFUL! When they occur, it means one transaction was the victim and rolled back, the other succeeded. You have a couple different ways to monitor them in Azure SQL Managed Instance. Let's review those together.
What is a deadlock? To quote our MS Learn Documentation, "Deadlocks occur when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs".
In layman's terms a deadlock occurs when two queries are blocking one another and neither could ever complete its transaction. Pretend two people need to use the same door. They cannot fit through at the same time. One must stop and let the other proceeded first. Now add on top of that they both reached for the door knob and grabbed it at the same time, both pulling the door in an opposite direction.
Instead of simply waiting, one must let go of the door knob. In this case the door knob is a table, the hands reaching out are attempting to gain a lock. In SQL Server, all versions of the database engine, this is accomplished by the Lock Manager it uses a process called FIFO, first in first out, to determine who has to let go.
In the case of SQL one transaction is a deadlock victim, it is killed and the transaction is rolled back. So if this is occurring on your system fixing it is very important. First you have to find out if they are occurring, and that's what we will cover in this blog post today!
Hello Dear Reader! I've realized something writting this blog. I don't like to sit still. It is very rare that I have a down weekend, and this weekend was no different. My amazing wife did something really cool for me for Christmas.
You see I'm hard to shop for, or at least that's what I've been told. I don't mean to be, but I am. My birthday is in January. When I was a kid you got presents on your bithrday and on Christmas. Even though they are in different years, mine are so close together that for 10 months of the year there is nadda, then 2 months PRESENTS!
So with that in mind, if I want something I tend to buy it. At this point in my adult life I'm just used to that. So Sue came up with something cool. I love giving people experiences be it with food, giving advice or tips on Orlando, Disney, or Universal Studios or even when peoplke come over playing bartender, setting up events with friends (see last week).
Sue got me experiences, and what a time we've had. That included this Saturday seeing Steve Martin & Martin Short live. I was laughing so hard throughout the event, but it wasn't just comedy. They are story tellers, showmen, and presetors. I couldn't help of people I know like Buck Woody (@Twitter | @BuckWoodyMSFT ), Patrick LeBlanc (Twitter | @PatrickDBA), or so many other amazing people in our community.
The timing and the comfort of doing a show with someone you know well. That made me think of Josh Ludeman (Twitter | @JoshLuedeman). There is no one in this world that I've presented with as much as Josh. As I enjoyed the banter back and forth you could see the comfort that comes from time and practice.
It was a great time and a great day. On Sunday we had that unusual down day. I did some work in the office, getting ready for our soon to be move, and when it came to dinner I wanted out of the house. I snapped a picture while we were out at bartaco. It has be come more and more rare to have all five of us at dinner together. Looking at the picture afterwards I realized something importiant. Serenity is now at the teenage point of making goofy faces in every family photo.
....it'll be a long two years, but I have plenty of her brother's from that period in time. As the youngest this is the last time I'll have to go through this. That acknowledgement came with a bittersweet feeling.
All right enough about the weekend, let's get to the round up!
MONDAY 4-24-2023
On Monday Daniel Taylor (Twitter | @DBABulldog) dropped his first video on the channel. Congratulations Dan! He had a really great point of view, working with a customer he needed to solve the problem of teaching them how to backup SQL Server via URL. The twist is the DBA's do not have rights to get SAS tokens, and so he had to teach the Azure Admins how to do that portion.
On Friday Neeraj Jhaveri, Daniel Taylor, and myself will be teaching our DBA 101: A Full Day of Fundamentals, but Andres Padilla & Josh Luedeman will be presenting at the event as well. The whole Tales from the Field crew is together live for the first time at a conference.
This is going to be a lot of fun. We have 8 sessions on the agenda so come and attend, have a conversation with us, or grab a sticker while we have them!
We hope to see you in Jacksonville, but more than anything Dear Reader thank you for stopping by!
Friday night took us to the SQL Saturday Speaker dinner and then a group activity we had planned together watching the Guardians of the Galaxy 3. No spoilers. Great movie and a really nice send off to the trilogy.
