Tales From The Field Weekly Wrap Up for the Week of 04-24-2023 Steve Martin, Martin Short, & Tacos

 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. 

 Dan walks through both tasks in this video to break down Backup to URL Seperation of duties.

WEDNESDAY 4-26-2023

On Wednesday I went in a different direction.  I had read a blog recently on how to pass a data frame to an Azure OpenAI model so you could ask questions about the data frame.  We had featured it in our Azure Data Community Round Table two weeks ago.  The blog was Make data more human with Azure OpenAI and Azure SQL by Valentina Alto (Twitter | @AltoValentina)

In this video Use OpenAI, SQL Managed Instance, Python, and VSCode to UNLOCK INSIGHTS About YOUR Data!!!, I walked through how to make this work using a data fram from a Domestic Box Office movie data table I had in a database. This was a lot of fun to walk through and the reception to this video has been really nice.

TUESDAY 4-252023

Of courese on Tuesday we had our Azure Data Community Round Table where we feature your content and it is always the star of the show. 

Here is the content coverd on the show in order of appearance:

Dan

• One Way to Provision an Azure Key Vault by Andy Leonard Twitter @AndyLeonard

Bradley

• Moving the SSISDB Catalog on a new SQL Server instance by Rajendra Gupta via SQLShack Twitter    @rajendragupta16 via @SQLShack

Andres

• Analysing Data with ChatGPT (Data Analysis and ML )  by Jesiel (JCharis) Emmanuel Agbemabiase  Twitter @JCharisTech

Josh

• Use ChatGPT to see multiple perspectives. An example: ORMs and database code  by Kendra Little  Twitter @Kendra_Little

Dan

• Troubleshooting Azure Data Studio by Deborah Melkin Twitter @dgmelkin

Andres

• MLOps on Databricks: A How-To Guide  by Rafi Kurlansik Twitter @kurlare

Bradley

• Data API builder – Introduction by Davide Mauri Twitter  @mauridb

Josh

• How to use the new dynamic format strings for measures in Power BI  by Meagan Longoria Twitter @MMarie

Dan

• PostgreSQL for the SQL Server DBA: The First Four Settings to Check  by Ryan Booz Twitter @ryanbooz

Bradley

• ChatGPT blew my mind with this Power BI scenario by Adam Saxton via Guy in a Cube Twitter  @awsaxton & @patrickdba via @GuyinaCube w @StephTBruno @shan_gsd

• Call back to Power BI datasets CI/CD (the easy-ish way)  by @StephTBruno & @shan_gsd

Andres

• AutoML Comparison in Databricks VS Azure Machine Learning by Mohammadsaleh Gharehdaghi Twitter @MG_cafe01

Josh

• The Top 10 Features of PostgreSQL Every Developer Should Know by Ajay Patel Twitter @Bond_AJ

WRAP IT UP

Ok Dear Reader!  We have a BIG BIG WEEK!  Not only do we have a video by Josh Luedeman this Monday on how to Set up Windows with Chocolatey for Data Developers in SECONDS!! GIT, WSL 2, PowerShell! and another video by yours truly coming up on Wednesday, but this week is SQL SATURDAY JACKSONVILLE!!

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!

Thansk,

Brad

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

• Edge AI: From Model Development to Deployment   by Raj Prasanna Ponnuraj

Josh

• Faster training and inference using the Azure Container for PyTorch in Azure ML  by Bea Stollnitz Twitter @beastollnitz

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 Fundamentals.  The 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

Tales From The Field Weekly Wrap Up for the Week of 02-20-2023

Hello Dear Reader! We had a beautiful weekend here in Florida.  Spring is in the air, mainly because the temperature is ranging between 85 to 90 degrees Fahrenheit.  This has lead to some rather pronounced sneezing on my morning exercise routine.  The type of sneezing that has scared children and small animals.

It was a really nice weekend, enjoying the tale end of February before a busy March.

This was a good time to get some recordings done, have some outings with the Mrs., and meet the gentleman for a morning of golf.   I'm not good at golf, quite terrible actually. It is a good excuse to spend two hours with friends talking about life, family, and generally trading our perspectives on things.

As we say goodbye to Winter and begin to focus on Spring it seemed like last week was indeed the perfect way to send off February with a bang.

Off to the wrap up.

Tuesday 2-21-2023

On Tuesday we had a little bit of Christmas in February with out Elfster show.  Our good friend Lonnye Bower (Twitter | @ilovesql) had the brilliant idea to have a gift exchange!  Andrew Nathan (Twitter | @AndrewNathan05) & Daniel Taylor (Twitter | @DBABulldog) were quick to sound off their excitement and we planned our eventual holiday extravaganza!  

We all were super excited for this.  No technical topics in this show, just a bunch of friends joking around, playing Secret Santa, and opening presents.  If you are looking for some fun and a laugh, please tune in.  This was a really fun time!

Wednesday 2-22-2023

On Wednesday we dropped our latest MS Tech Bits.  These are videos that will cover different Azure technologies and how you can incorporate them.  Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) & Andrés Padilla (Twitter | @nodestreamio) walk us how to use BICEP templates from our GitHub repository to walk you through deploying Pattern 1 in order to deploy you Azure Synapse Analytics environment.       

This is a great video and it is just the start, personally I'm really looking forward to additions to this series.

Thursday 2-23-2023

On Thursday we had our Community Round Table featuring amazing content by you the Azure Data Community & sometimes great authors from our community at large!

Josh Luedeman (Twitter | @JoshLuedeman) wore his hat from the Tuesday show, and we kicked off reviewing the content our team had seleted for the week.  But you don't want to here me talk about it, here are the links!

Links in order of appearence on the show:

Neeraj

• A complete CI/CD experience for Azure Synapse Link for SQL Server 2022  by Kevin Chant Twitter @kevchant

Bradley

• SQL Transaction Processing and Analytic Performance Price-Performance Testing By William McKnight & Jake Dolezal via gigaom Twitter @gigaom

Andres

• Streamline your Edge AI development and operations with KAN  by Olivier Bloch Twitter @obloch

Josh

• Script to Install the Tools I Use on My Jumpbox by Tracy Boggiano Twitter @TracyBoggiano

Neeraj

• Securing your Synapse environment  by Liliam Leme Twitter @LemeLiliam

Bradley

• Synapse Espresso: Optimize Delta Table performance with Optimize & ZOrder Indexing by Stijn Wynants Twitter @SQLStijn

Andres

• Train your Model in AML, score it in ADX by Adi Eldar

Josh

• Sql-action v2 GitHub Action for Azure SQL Database deployments   by Kevin Chant Twitter @kevchant

Neeraj

• Deploying Azure Bicep Templates Using The Azure CLI  by Chris Pietschmann Twitter @Build5Nines

Bradley

• json_object and json_array Functions SQL Server 2022 Tutorial  By Daniel Calbimonte Twitter @MSSQLTips

Andres

• I Wanna Go Fast!)Performance Optimization Tips & Tricks for Azure Data and App Services  by Marcelo Silva & Victor Santana

Josh

• Using the Dedicated Administrator Connection with SQL Server in a Docker Container  by Joey D'Antoni Twitter @jdanton

WRAP IT UP

We've got a big week planned this week.  Vicky Harp (Twitter | @vickyharp ) Principal Product Group PM Manager will be on the Tuesday show!

On Wednesday I have some MS Tech Bits that will be posted, on Thursday we have the Community Round table featuring data from the Azure Data Community, and it maybe featuring your content!  Let us know if you are writing a blog, producing a video, or doing something noteworthy in the community! 

As always Dear Reader, Thank you for stopping by.

Thanks,

Brad