Monday, April 24, 2023

Tales From The Field Weekly Wrap Up for the Week of 04-17-2023 Jorge, Wrexham AFC, & Guys Night Out

 Hello Dear Reader!  This past week was one I had been looking forward to for quite some time.  A couple of months ago I had started reaching out to my other guy friends.  We all  have busy lives, but we need to take time to spend with one another outside of dinner's with spouses, game nights, or Marvel movies.

Not that those things aren't great, but something that allowed us to just relax.  

Let me back up a bit, I love the podcast The Armchair Expert with Dax Sheppard.  On it they refrenced a study that lead me to this article on How loneliness is killing men.  Which shocked me.

I have this really cool Uncle we all idolized.  He was always taking trips to go golfing, hunting, or fishing with his buddies.  Growing up I thought that was really amazing.  As I got older and had kids, amazing turned into questions.  

How did he find the time to do this?  Shouldn't he be spending this time with his family and kids?  He was a really great Dad and family man, was his life out of balance or did these things matter?


I should have picked up the phone and called him.  I should have asked.  But I never have.  Then my kids got older, and getting their attention and even time with them became more and more scarce.

This lead to another realization.  My buddy Jorge Segarra (Twitter | @SQLChicken) and I were talking.  Jorge is doing the beautiful work of being a stay at home Dad and taking care of his kids.  We were having a great conversation, he was picking up kids from school, they got in the car like a chaos bomb and he said, "I should probably let you go this is going to be too noisy for you".

"I'm good", I replied and we kept the call going.  I've been a single Dad, a divorced single Dad, and a very lucky married man with a great partner.  The chaos of the call reminded me of picking my kids up from school about a decade ago.  We also realized that not many men could talk about some of the issues I faced and he was facing.  We also talked about how men don't talk about these things.  I brought up the podcast and the article.

We talked about the need of having time to go out with friends, re-engergize, and come back in a better head space to be father's and husbands.  For the first time, I understood my Uncle.

That was January.  We started planning.  We would talk more regularly, it had been months since our last phone call.  That needed to change. 

We found a weekend that worked, it took a while.  We set the date.  There were other gentlemen invited who could not make it, but hopefully next time.  It was this past Saturday.  Jorge, Daniel Taylor (Twitter | @DBABulldog), Josh Luedeman (Twitter | @JoshLuedeman), and myself planned a day.

It involved a spa visit for Jorge and myself, a cabbana by the pool for all of us to relax, a nice steak dinner, and watching John Wick 4.  Along the way we listened to Wrexham AFC win PROMOTION and toasted them from afar!!!

The day was perfect and we are all looking forward to the next time.  Long way of saying this, but if you are reading this think of your friends and reach out to them.  It is litterally the best thing you can do for your health.... and theirs.

All right, on to the recap!

MONDAY  4-17-2023

On Monday Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) and Andres Padilla (Twitter | @nodestreamio) delivered a video on Azure Cost Management!  They have a discussion about different options to save money on a subscription.


They also show you how to use the Azure Price Calculator, Cost management and billing in the Azure Portal, how to set a budget, and how to set cost alearts!  Great stuff!


WEDNESDAY 4-19-2023

On Wednesday my video on Azure SQL Space Management for Azure SQL Database came online.  

This was a really fun video to make based off of a customer conversation and our amazing documentation on the subject.

TUESDAY 4-18-2023

The highlight of the week is always the Azure Data Community Round Table.  Josh, Neeraj, Andres, and myself kicked off a review of those articles that we found to be super helpful from the last week.


Here is the star of the show, the content in the order of appearence on the show:


Neeraj

The Power of AI for Medical Imaging: 5 Key Applications & Use Cases by Katarzyna Rojewska Twitter @k_rojewska, @DLabsAI

Bradley

Make data more human with Azure OpenAI and Azure SQL by Valentina Alto Twitter   @AltoValentina

Andres

Integrating Azure OpenAI and Azure Speech Services to Create a Voice-Enabled Chatbot with Python  by Jiadong Chen Twitter @chen_jd

Josh

Back home, but still a long way to go by Hugo Kornelis Twitter @hugo_kornelis

Neeraj

How does AI actually work? by Kristina Bravo Twitter @BravoKristina 

Bradley

T-SQL STUFF – Taking it to the limit by  John McCormack Twitter @actualjohn


Andres

Using  MLFlow Recipes to refactor messy notebooks by Jeanne Choo  


Josh

Master Databricks and Apache Spark Step by Step Video Series by Bryan Cafferky Twitter @BryanCafferky

Neeraj

Can Data and Analytics Help Save the World? by Troy Hiltbrand Twitter @trohil

Bradley

Using SQL Alerts to Spot Suspicious Activity in SQL by David Fowler via SQL Server Central Twitter @SQL_Undercover  @SQLServerCentrl


Andres

Next-Generation Computer Vision Capabilities with Project Florence by Adina Trufinescu Twitter @abiramivina


Josh

Citus Con Reminder (Keynote was at 12-330 ET/9-1230 PT, EMEA tomorrow 9-1230 CEST) by Citus Con Twitter @CitusCon



WRAP IT UP

We've got another great week planned for you, and we hope you can make the time to join us.  On Monday Daniel Taylor is dropping his first ever MS Tech Bits on how seperation of duties requires Azure Administrators and DBA's to work together in order to backup to utilize backup to URL.

On Tuesday at 1 pm EST we have our Azure Data Community Round Table and on Wednesday I will be droping a video utilizing Azure Open AI to read and collect insights on my Azure SQL Data.

Take care of yourself Dear Reader, and as always Thank You for stopping by.

Thanks,


Brad

Monday, April 17, 2023

Tales From The Field Weekly Wrap Up for the Week of 04-10-2023, Taylor Swift, & The Disney 10 Miler

 Hello Dear Reader!  Last week was a really busy week with an even busier weekend.  We will get to the show recap's in a moment but first let's dive into the weekend.

Months ago my wife & youngest son worked together to get Taylor Swift tickets for this past weekend.  I've enjoyed quite a few songs of Taylor's, but live music isn't really my thing.  My wife loves it.  She had a career working in radio and she was the planner & show runner for many many live music concerts.  She "makes" me go with her.  

To be honest I always have a great time, but it is not something I seek out for myself.  So when Sue & William were excitingly explaining to me over dinner how they were able to secure 3 tickets my first thought was they were taking my sister Julie or my youngest daughter Serenity (both of whom would have fought me..... and probably won... to get these tickets).  It was not Julie or Serenity.  It was me.

Don't get me wrong, I was happy to suggest they offer up the ticket to someone else.  Heck, I got us a really great hotel room at the Tampa Edition.  It had a Michelin star chef.  An amazing bar, a welcome cocktail with a lavender spritz and their gin brewed specifically for the hotel, not to mention a Rum bar, and to top it all off an in house spa.

My offer was that they could go to the show, I would go to the spa and get a massage, go to one of the restaurants and eat some food, go to the bar and get some drinks, then head to the pool where they had a pool side bar, take a nap, wake up, go grab some more drinks, and wait for them to get back so they could tell me all about it.

As you can tell from the pictures my offer was refused.  We had a great time.  There were songs we sang along to, that we danced to, and it was a spectacle.  It cannot be said that Ms. Swift puts on one helluva show.  She performed for 3 hours straight and sang 44 songs from 9 different albums and 2 surprisesongs.

On Saturday morning we woke up, had a really nice brunch at The Pearl and made our way back to Orlando so I could pick
up my race packet for the Run Disney 10 Miler.  I will be honest Dear Reader, I forgot I signed up for this race until the week before.

I have picked my running back up post injury, but had not been training on longer races.  Normally my long Disney Races are half marathon's, 13.1 miles or 21 K, this was a 10 mile run or roughly 16K.

Those 3.1 Miles or extra 5 K's make a difference.  Seriously.  That is normally the part of that race where I hit a wall.  Not literally.  In running when you hit a wall is a condition of sudden fatigue and loss of energy which is caused by the depletion of glycogen stores in the liver and muscles.  It makes that the most difficult portion of the race.

By not hitting that wall I was never truly fatigued during the race.  I was able to keep my run-walk-run-walk method going and averaged 8 minutes per kilometer and finished in 2 hours and 11 minutes. 

At home we my lovely wife was home busily preparing for my Mother-In-Law's 77th birthday!!  I love my Mother-In-Law Judy.  She is an incredible woman.  My brother's-In-Law, my nieces, and one of my nephews made it over.  However the star of the show was my baby grand-niece.  No pictures, but she is the most beautiful and adorable little girl.  She is six months old and in a very fun phase where she is not yet walking, but alert, attentive, and very opinionative.  You knew what she liked and didn't like!  The party was great and seeing family was the cherry on the cake.  

Like I said, busy weekend.  Now let's recap last week!!

WEDNESDAY 4-12-2023

On Wednesday we dropped the demo heavy companion to last weeks video SQL Server Internals: HEAPS VS. CLUSTERED INDEXES!

This was a really fun video to make, and I'm hard at work on this weeks content which will be a fun video about Azure SQL and how it utilizes space.


TUESDAY 4-11-2023
Tuesday was a great show.  We started off the Community Round Table with a side conversation about being a parent and giving the magic of wonder to our children.  Josh Luedeman (Twitter | @JoshLuedeman) reminisced about Castle Greyskull with me from our childhood.  Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) talked about when he gave his kids the gift of iPhones!  Andres Padilla (Twitter | @nodestreamio) talked about an AMAZING Christmas where his father hung his the Star Wars ships he received from the ceiling like they were flying!



We also covered AMAZING Azure Data Community content from the creators.  Here's the content in order of appearance:

Neeraj 

Bradley 
Using Azure Data Factory to read and process REST API datasets by Rayis Imayev Twitter  @RayisImayev 

Andres 

Josh 

Neeraj 


Bradley 
EightKB Topics  by Andrew Pruski Twitter  @dbafromthecold 

Andres 
Understanding Chaos Engineering by John Engel-Kemnetz Twitter @jkemnetz 


Josh 
Armchair Architects: Data Mesh Architecture by David Blank-Edelman Twitter @otterbook  

Neeraj 
Introducing Microsoft 365 Copilot – your copilot for work  by Jared Spataro Twitter @jared_spataro 

Bradley 
How to work with ChatGPT in Visual Studio Code  by Daniel Calbimonte via SQL Server Central Twitter  @dcalbimonte  @SQLServerCentrl 

Andres 

Josh 


WRAP IT UP
As we wrap things up a quick programming note.  We will be dropping an MS Tech Bits video TODAY on Cost Management by Neeraj & Andres!  Make sure to check that out when it goes live.

Tomorrow we have our Community Round Table show Live at 1 PM EST.  On Wednesday I will be with you for an MS Tech Bits on Azure SQL Database Shrinking Operations for Data & Log Files. 

We hope you have a wonderful week and make some time to hang out with us Dear Reader, if you did anything fun this weekend I'd love to hear from you!

As always Dear Reader, Thank you for stopping by.


Thanks,

Brad 



Monday, April 10, 2023

Tales From The Field Weekly Wrap Up for the Week of 04-03-2023 & Easter

Hello Dear Reader!  Hopefully you had a great weekend.  This weekend was filled with gatherings.  On Saturday we gathered with friends and had a really nice Game Night.... where no games were played and it was just perfect.  

It had been so long since we all gathered that we ate taco's, made some movie plans, watched hockey, and just generally enjoyed one another's company.  The food theme was tacos, my compliments to the many chef's.  Mere descriptions alone will not do it justice but there was homemade taco meat, refried beans, melted cheese, homemade rice & black beans, fresh guacamole, and some of the best chocolate chip cookies ever.

The following day was Easter.  My parents joined Sue, the kiddos, and myself.  Even though the kids are 19, 18, & 13 years old respectively.  Yet, they are never too old for an Easter basket!  When I was over in Wales & London for SQLBits I love to get candy for Easter.  There are so many amazing options to choose from and the fact that it is just slightly different, but oh so delicious, adds an element of wonder and amazement.


Some of my favorite Dad things to do are when we prepare for Christmas or Easter.  I also love some of the little things.  When the kids were small I loved making lunches. Making sure to add cinnamon apple sauce, snack cakes, some type of gummi snacks, making sure they each had their own individualized sandwiches. Serenity's favorite was a peanut butter and sliced bananawith no crust, I prefer the crust on mine.  All of those small things, that they are too big for now.

Lots of wonderful happy memories Dear Reader, the most important thing is to be present in the moment and love the people around you.  Alright, enough reminiscing.  Grab a Reese's Peanut Butter Cup shaped like an Easter Egg because it's time to bounce over to the re-cap!


WEDNESDAY 04-05-2023
On Wednesday we released our latests MS Tech Bits diving into the structures of Heaps and Clustered Indexes.  Why do we have the VS. on the slide?  The default table type in Oracle is a Heap, the default table type in SQL Server is a Clustered Index.  For years therese were the two most dominiant relational database systems and having different default recommendations creates confusions.

 


It's importiant to remember what we've learned from Ted Lasso.  "All people are different people", "Be a goldfish", also that tip about the peanut butter was pretty good and I would recommend the White Chocolatey Wonderful. I digress, all databases are different databases.  Some may be based off of ACID some are not, but indexing structures in SQL Server, PostgreSQL, MySQL, or Oracle are all things you need to understand.

It affect performance and every day functionality.  So we dive into the conceptual structures in this video, demos are coming this week!


TUESDAY 04-04-2023
On Tuesday we had our Azure Data Community Round Table!  The wonderful Daniel Taylor (Twitter | @DBABullDog) was in for Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri), Josh Luedeman (Twitter | @JoshLuedeman), Andres Padillia (Twitter | @nodestreamio), and myself had a great day talking about the AMAZING content created by the Azure Data Community.


No time to waste, here is that wonderful content in the order it was covered on the show:

Dan
DBA in training: SQL Server high availability options  by Pamela Mooney Twitter @PamelaMooney

Bradley
T-SQL Tuesday #160: Round-Up  by Damien Jones Twitter  @amazonwebshark

Andres

Josh

Dan
[How-To] SSRS migration by Garry Bargsley Twitter @gbargsley

Bradley
The Kingdom of AdventureWorks Calls for Aid - Asad Khan, Bob Ward, Sanjay Mishra & Buck Woody by  SQLBits,  Asad Khan, Bob Ward, Sanjay Mishra & Buck Woody Twitter @SQLBits, @Bob_Ward, @BuckWoodyMSFT, @AzureSQL 

Andres
Create AI tracking Drone using DJI Tello  by Murtadha Bazli Tukimat  Twitter @RobotAndCode

Josh
Single Server to Flexible Server Migration tool is GA in Azure Database for PostgreSQL  by Shriram Muthukrishnan  Twitter @azureDBpostgres

Dan
How To Learn Microsoft Azure in 2022 by Thomas Maurer Twitter @ThomasMaurer

Bradley
Power BI datasets CI/CD (the easy-ish way) by Stephanie Bruno Twitter @StephTBruno

Andres
Amazing Invention-This Drone will change everything by Mark Rober  Twitter @MarkRober

Josh
GitHub Codespaces for Students and Educators  by Nehemiah Emmanuel  Twitter @devgenix





WRAP IT UP.... AND SQL SATURDAY JACKSONVILLE!!!
This week we have the Community Round Table on Tuesday at 1 pm EST.  Join us to see the Azure Data Community blogs & videos we will be featuring.

On Wednesday we will have our MS Tech Bits, this will be the Demos that accompanied last weeks conceptual ideas about indexes!

SQL Saturday Jacksonville is just under 1 month away!! All of the Tales from the Field crew will be at the event.  Make sure to come to Daniel, Neeraj, & my pre-con A Full Day of DBA FundamentalsThe full event schedule is LIVE!!

This will be a fun week, we hope you have a great one!  And as always Dear Reader, Thank you for stopping by.

Thanks,

Brad