Showing posts with label Citus Con. Show all posts
Showing posts with label Citus Con. Show all posts

Monday, May 8, 2023

Tales From The Field Weekly Wrap Up for the Week of 05-01-2023 A new house, a reunion, & 15 Years of SQL Saturday Jacksonville

 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!

That would normally be enough news for a month, but you know me there is no rest.  After closing on the house I hit the road to the 15th Anniversary of SQL Saturday Jacksonville.

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!

TUESDAY 5-2-2023
We kicked off the Azure Data Community Round Table this past week discussing the weather and how much we were all looking forward to getting together at SQL Saturday Jacksonville.


Of course as we all know the star of the show is the Community.  So without further ado here are the links in order of appearance on the show:

Neeraj
The Plain-English Guide to Data Warehouses [+ Examples]  by Swetha Amaresan  Twitter @swethamaresan

Bradley

Andres
Opening the eyes of the machine: Computer vision with AutoML by Gavita Regunath & Dan Lantos Twitter @gavi_sr

Josh

Neeraj

Bradley
SQL Server Row Count for all Tables in a Database by Dattatrey Sindol Twitter @dattatreysindol via @mssqltips

Andres
Building a startup using Azure Computer Vision by Nikhil Sehgal Twitter @nikhilsehgal_ai

Josh
Chocolate Install Git Config by Gary Ewan Park Twitter @gep13

Neeraj
Best practices for Purview and a federated way of working   by Piethein Strengholt Twitter @phstrengholt

Bradley
EightKB 2023 – Schedule and Registration by Andrew Pruski via SQL Server Central Twitter  @dbafromthecold via @SQLServerCentrl

Andres

Josh
Monitoring Deadlocks in Azure SQL Managed Instance by Bradley Ball Twitter @SQLBalls


WRAP IT UP
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.

Thanks,

Brad




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