Tuesday, May 2, 2023

Monitoring Deadlocks in Azure SQL Managed Instance

 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!


To read the rest here is the link: Monitoring Deadlocks in Azure SQL Managed Instance


As always Dear Reader, Thank You for stopping by.


Thanks,


Brad




Monday, May 1, 2023

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




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

Tuesday, April 4, 2023

Tales From The Field Weekly Wrap Up for the Week of 03-27-2023 & MegaCON

Zach's 1st MegaCon 2011
 Hello Dear Reader!  This past week is a blur.  It was a tough week at work.  That sentence is an understatement, but its really all I can say at this point.  Monday sent me for a tail spin.  I was fresh off a weekend relaxing with my wife, planning events with my friends, and thinking things were pretty well set.  Life has a way of suprising you.

We powered through last week, had our Community Round Table, and dropped our new content.  Internally at Tales from the Field we did some Camtasia training, explored some new technology, and started some planning for the next 3 months.  I'm excited about those things.  Before I knew it the weekend was upon us.

12 Years Later MegaCon 2023

I'm really tough to shop for, I hear that a lot around Christmas time.  I don't mean to be difficult, but if I want something I tend to buy it.  Books, collectibles, comics, whiskey, gin, ....I digress.  This year my wife did something exceptionally cool for me.  She bought me things to give me experiences, one of those was ticket's to MegaCON in Orlando.  She bought me floor passes & and extra pass to share.  

I shared mine with my oldest son Zachary.  My first MegaCon ever was with Zachary when he was 7 years old.  When it comes to comic book conventions I've only ever been to two and he was with me at both of them.  He enjoyed this so much, I think this is a must do again next year!

One of the things I've always loved it the effort people put into their costumes, how generous they are with their time, and a willingness to celebrate with others.  That was as true when he was a little kiddo dressed in a Superman t-shirt as it was this year when he was dressed as Eren Yeager this year.

I hope you had a good weekend out there Dear Reader!  On to the wrap up.


WEDNESDAY 03-29-2023

On Wednesday we dropped our MS Tech Bits, Turn SQL to KQL IN SECONDS with Azure Data Explorer.  This video is based off the demo I did with Patrick LeBlanc (Twitter | @PatrickDBA) in our Session at SQLBits (Twitter | @SQLBits).

I love Azure Data Explorer, it is an incredibly powerful service for digesting log data and querying massive data sets and returning results in seconds.  It has so many capabilities and possibilities.  BUT... I don't know KQL and I don't know if I want to learn another language.  Fear not as I show in this video you can use the EXPLAIN statement to translate SQL to KQL that you can then run against your data sets.

I'm hoping this leads to peopel realizing that the bar for entry to this service is low, if you know SQL then you know KQL!


TUESDAY 03-28-2023

On Tuesday I once again teamed up with Josh Luedeman (Twitter | @JoshLuedeman), Andres Padilla (Twitter | @nodestreamio), & Neeraj Jhaveri (Twitter | @neeraj_jhaveri) to review the AMAZING community content that you all produced!  If you missed that make sure to check it out.


The true star of the show is the content produced by the Community.  Here is the content in order that it was covered on the show:

Neeraj

Multi-Column Distribution for Dedicated SQL pools is now GA! by Mariya Ali Twitter @mariyaali

Bradley

How to use an Annotation in Azure Data Factory or Azure Synapse Analytics Data Integration Pipeline?  by Alpa Buddhabhatti Twitter  @AlpaB7

Andres

How to set up a Python virtual environment on Windows by Abhinav Saraswat 

Josh

Announcing the Release of Azure Data Studio 1.4.2  by Erin Stellato Twitter @erinstellato

Neeraj

Working with the GPT-4 and ChatGPT models on Azure by Derek Legenzoff Twitter @DerekLegenzoff

Bradley

What is Visual ChatGPT?   by  Andy Sansom 

Andres

Spark Monitoring  by Dustin Vannoy Twitter @dustinvannoy

Josh

Turn your database into an API in minutes with Data API builder for Azure Databases  by Jasmine Greenway Twitter @paladique

Neeraj

The Importance of SQL Saturdays  by Angela Tidwell Twitter @AngelaTidwell

Bradley

KQL Series – ingesting data with Azure Data Factory by Hamish Watson Twitter   @TheHybridDBA

Andres

Eliminate these 11 phrases that ‘make people question your credibility,’ says public speaking expert  by Christina Helena Twitter @christinahelena

Josh

Azure Podcast - Episode 455 - Azure ML in the Real World  by Azure Podcast Twitter @AzurePodcast


WRAP IT UP

This week we have our Community Round Table on Tuesday where we will once again feature content from you the Azure Data Community!  We will be live at 1 pm EST, but you can always catch us after the broadcast on our YouTube Channel.

Wednesday we will have a video discussing the internals of Heaps, Clustererd Indexes, & Non-Clustered Indexes!

Time to say goodbye until next week.  Hope you have a great week and as always Dear Reader, Thank you for stopping by.


Thanks,


Brad



Tuesday, March 28, 2023

Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up

William, right, 11 years ago the morning of our college tour
 Hello Dear Reader! When I got off the plane from SQLBits I wasn't feeling great.  To be honest, I was a little concerned.  I'm a diabetic asthmatic.  Some people are generally unconcerned when they get a cold, some even feel that way about Covid.  Not I.  

For years when I get a cold they would linger, antibiotics would need to be perscribed, consumed, and then about a month later my voice would return to normal.  I've been very fortunate that my immue system seems to have recieved a kick start in the last few years.  No longer is the need for antibiotics absolute.  

 No longer is a cold a one month sentence of exercise purgatory.  Really, I feel lucky.  Despite feeling awful on Monday & Tuesday, by Friday morning I felt great and sounded like Barry White.  So with me feeling better, my wife very happy with my deep sexy voice, we packed up the car and drove my youngest son William to a campus tour of the University of North Florida

It was a really beautiful campus and the tour was fantastic.  William is going to be very happy up there.  I'm familar with UNF thanks to SQL Saturday Jacksonville.  It has been held on their campus since my first trip to the event all the way back in 2011 and SQL Saturday #74.

Seeing the campus from the eyes of a perspective student was amazing.  I'm used to the excitement of Friday morning pre-con's and the buzz in the air as you follow the SQL Saturday signs to the parking garage.

This time it was following the signs to the Campus Tour, taking in the campus, food venues, gym, and different  class rooms.  What an exciting time he is about to embark on!  As if it wasn't enough, father time gave me a solid kick to the feels.  The picture posted above of William and his younger sister finger painting was my Facebook memory.  My phone alerted me that I had a memory, and I clicked on it.  All I could think of was how time flies.  There's no way, when I snapped that picture 11 years ago, that I imagined him getting ready for college.

Alright Dear Reader, let's get to the re-cap.


MS TECH BITS - WEDNESDAY 3-22-2023

My deep voice was in full effect as we took a jump into the Transaction Log.  The Transaction Log is an essential part of SQL Server.  That's an understatement.  That's like saying your lungs are essential.  The Transaction Log is fundemental.  We look at what it stores, how it holds data, how Virtual Log Files work, and a little bit about recovery models.

If you are interested in replicating the demos, I'm keeping them over in my GitHub Repo for SQL Scripts.  The demo envrionment I used for this was a docker container running SQL Server 2022, if you want to know how to set up that environment check out this video.


COMMUNITY ROUND TABLE - TUESDAY 3-21-2023

The Community Round Table featured my sultry deep voice as well as Josh Luedeman (Twitter | @JoshLuedeman), Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri), and Daniel Taylor (Twitter | @DBABulldog).


We did a quick recap of SQLBits talking about the wonderful event, and then we covered the content.  No more delays, let's get to it.  Content in order of appearence on the show:


Neeraj 

Performance Tuning Synapse Dedicated Pools - Understanding the Query Lifecycle by Sarath Sasidharan Twitter @sarathsasidharan2016 


Bradley 

Call to Action for Female Speakers to Submit to EightKB  by Tracy Boggiano Twitter  @TracyBoggiano 


Dan 

SQL: Setting local date and time for a session in Azure SQL Database  by Dr. Greg Low  Twitter @greglow 


Josh 

How To Convert Parquet Files into GeoJson Files and Save it in Data Lake using Synapse Notebooks by Sally Dabbah 


Neeraj 

Creating a custom disaster recovery plan for your Synapse workspace Part 1   by Freddie Santos Twitter @fredguis 


Bradley 

Building, Deploying, Sharing a Remote Jupyter Book in Azure Data Studio by  Steve Hughes  Twitter @DataOnWheels 


Dan 

How I evaluate personal safety at tech conferences  by Eugene Meidinger Twitter @SQLGene 

 

Josh 

Azure Data Factory Global Parameters and Azure Bicep Templates  by Tao Yang Twitter @MrTaoYang 


Neeraj 

My week at SQLBits 2023: Why You Should send your Employees to Conferences by Kay Sauter Twitter @KaySauter 


Bradley 

Connecting Power BI to Azure SQL Database using Private Endpoints  by Andy Cutler Twitter  @MrAndyCutler 


Dan 

Why read committed is the default isolation level, and what to do next  by Kendra Little Twitter @Kendra_Little 


Josh 

Azure Data Factory CI/CD with GitHub Actions  by Olga Molocenco   

 

WRAP IT UP

We did some experiements earlier this month and loved the reception we recieved.  We are working hard over here at Tales From The Field, TFTF, HQ to come up with some additional content for next month.

This week we have our Community Round Table on Tuesday & our MS Tech Bits on Wednesday.  We hope you will join us for them, and if there's anything you would like to see sound off in the comments!  We always love to hear from you Dear Reader.

And as always, Thank You for stopping by!

Thanks,


Brad


Monday, March 20, 2023

Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023

 Hello Dear Reader!  What an incredible week we had.  I started off traveling on Monday of last week.  At the airport I ran into my friend David Pless ( Twitter | @dpless), he and I were on the same flight to London!  It was great to start off the trip hanging out with a good friend. 

After landing Tuesday morning, I took the Tube to Padington Station, then the Great Western Railroad out of London heading to Newport Wales.

There is a Rail Strike occuring in the country right now.  That added a bit of tension to travel days as we did not know if trains would be running or not.  One day your train would not have any issues, the next you would recieve alerts that your service may be disrupted.  Luckily I did not experiance any issues with trains, but the drama hung in the air all week long for everyone.

SQLBits was taking place at the Newport Wales ICC.  It was a fantastic venue, for more on that take a look at the shorts which started with a walk up and grew to be a review of the days events at SQLBits. 

I was hustling to get out there because I was assisting with an amazing pre-con being put on my by Azure FastTrack Product Group, PG, colleague Stijn Wynatts (Twitter | @SQLStijn), Filip Popovic & Mark Pryce-Maher  from the Microsoft Azure Synapse PG, & Mr. Simon Whiteley (Twitter | @MrSiWhiteley) Microsoft MVP for Lakehouse in a Day!  I was one of the people walking around and assiting others. I did that straight up until our Tuesday show.  

Wednesday I assisted with Bob Ward (Twitter | @BobWardMS), Marissa Matthews, and Buck Woody's training day, The SQL Server 2022 Workshop.  It was a PACKED room.  We had over 120 people sign up and we needed multiple additional tables.  We did a lot of hands on work, I know if you where there chances are I helped you do it at some point!  It was another fantastic day of learning.  After that we went to a Girlguiding, Welsh Girl Scouts, volunteering event with other Microsoft Employees and Microsoft MVP's.  We helpd to pick up litter and keep some of their fields and facilities clean.  This was just good for our souls.  It was wonderful to meet people from Newport and work along side them.  This was hands down my favorite event that we did this week.  Which is high praise, because this week was amazing.

I will get more into the work done in the updates below, but it was a wonderful and exhausting day that would end with myself in the Auditorium presenting with none other than Patrick LeBlanc (Twitter | @PatrickDBA).  Saturday Patrick & myself presented on The Most Powerful Azure Service that You've Never Heard of.

Intruged?

Let's head over to the recap.

MS TECH BITS - MONDAY 3-13-2023 & WEDNESDAY 3-15-2023

On Monday my colleague Marco Aurelio Cardoso from the Azure FastTrack PG joined me to discuss OpenAI and Prompt engineering.  We put this video together to showcase a partical application of how these services would be utilized.  We also had some fun asking about the physical hygine of Master's of the Univers Characters as well.

Marco showed me how to create an Azure AI Chatbot that utilizes an OpenAI model to create an interactive Chatbot in a Slack Channel.  We had a really good discussion about Responsible AI and the need to understand the source for the information that our model is returning. 

Wednesday I had a video on how to set up a SQL Server 2022 Instance in Seconds, also it is free using the free version of Docker and SQL Server 2022 Developer Edition on a Docker Container.

There are some internal concpets regarding SQL Server that it is importiant to understand.  Understanding how to stand up an evironment quickly to test out new features is a good skill to have and will be key for some of our futuer conversations.


SQLBits 2023 SHORTS 

All this week I was making shorts videos recaping some of the activities of the conference.  I'm only one human and could not make it to everything, but if you couldn't make it to SQLBits or if you want some nestolgia from the event please take a look.

Newport Wales ICC walk up to #SQLBits 2023 Training Day 2


SQLBits Behind the scenes Day 1 Keynote, Sessions, & Volunteer Event

EPIC SQLBits Costume Party, 5K Run, & General Sessions Day 2!!


Last Day at SQLBits 2023, Community Keynote, General Sessions, & Saying goodbye

As you can see this was an exceptional event.  So many fantastic sessions, I cannot wait to go look at the SQLBits channel to find the sessions I missed and watch them when they are posted!  Keep in mind SQLBits makes these sessions available for you to consume so make sure to check them out.

COMMUNITY ROUND TABLE - TUESDAY 3-14-2023

Buck Wood (Twitter | @BuckWoodyMSFT) joined Josh Luedeman (Twitter | @JoshLuedeman), Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri), Andres Padillia (Twitter | @nodestreamio), and myself.  Buck and I were live from the SQLBits Conference.  


No further delays, lets get to the content in the order of appearence:

Neeraj

Roll with us at SQLBits 2023! - Microsoft Community Hub by Marisa Mathews Twitter @MarisaMathews @AzureSQL

Bradley

Creating an Azure SQL Private Link Endpoint and managing DNS By John Lunn  Twitter @jonnychipz

Andres

Parameters and Hyperparameters in Machine Learning and Deep Learning by Kizito Nyuytiymbiy  Twitter @KizitoNyu

Josh

Scale Multiple Azure SQL databases on a logical server  by Laith Ayesh

Neeraj

Azure Synapse analytics (dedicated SQL pool) data modelling best practices  by Bhaskar Sharma Twitter @sharmabhaskar

Bradley

Pro SQL Server 2022 Wait Statistics Book  by  Thomas LaRock  Twitter @SQLRockStar

Andres

How to Write Better Prompts for Chat GPT  by Derek Slater Twitter @GripRoom


Josh

Code Reuse with Spark Functions for Azure Databricks  by John Miner Twitter @JohnMiner3

Neeraj

Appreciation Posts for Engineers Day Across Globe  by Muskaan Sabarwal Twitter @MuskaanSabarwal

Bradley

SQL Server Wait Statistics (or please tell me where it hurts…)  By Paul Randal Twitter @PaulRandal

Andres

ChatGPT-3 Prompt Engineering  by Matt Nigh Twitter @literallynigh

Josh

Monitoring PgBouncer in Azure PostgreSQL Flexible Server  by Varun Dhawan Twitter  @iVarund


WRAP IT UP 

As I type this I'm crossing the Atlantic Ocean to head back home.  I don't know that there is anything left for me to say.

Tuesday we have the Community Round Table & Wednesday we will be dropping our MS Tech Bits.  I'm ready to lean this seat back and get some rest.

Have a great week Dear Reader, be good to one another.  And as always, Thank you for stopping by.


Thanks,


Brad




Monday, March 13, 2023

Tales From The Field Weekly Wrap Up for the Week of 03-06-2023 & Pineapple on Peperoni

 Hello Dear Reader!  Last week was an incredible week.  We dropped new content on Monday, Tuesday had the Community Round Table, Wednesday MS Tech Bits, and released YouTube Shorts all week long.

We also waded into controversy on Twitter.  It began with a seemingly innocent and funny post by Buck Woody (Twitter | @BuckWoodyMSFT) and well.... it just took off from there.

Needless to say, anyone who doesn't like Pineapple and Peperoni on their NY Style pizza clearly has never tried it and is therefore wrong.  End of discussion.

A quick note.  

*Hawiian pizza is disgusting.  Canadian Bacon is a lie.  Real Canadian Bacon should be maple coated real-bacon.  Not ham.  Ham should not be on a pizza, with the only exception being a supreme pizza.

End note.

My Mom & Dad were over for my youngest daughter's 13th birthday.  Happy Birthday Serenity!  During which my father, who ran a pizza restaurant, and spent over 25 years in the restaurant business. had never tried it.  He did, and he was surprised how good it was.  He even went for a second slice!


On to the recap!


MONDAY 3-6-2023

Andres Padilla (Twitter | @NodeStreamIO) & Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) kicked off Monday with an introduction to Azure OpenAI.  


This video has proven very popular, I'm not going to ruin it for you.  Head over and take a look.  Andres walks us through registering to gain access to & then shows us some of the Azure OpenAI playground.  


TUESDAY 3-7-2023

Tuesday is the new home to our Community Round Table.  It was a great show, but as always the star of the show is the content from the Azure Data Community.


List of content in order of appearance on the show:

Neeraj

AWS Lambda Function to import CloudTrail Logs to Azure Sentinel by Sreedhar Ande Twitter @sreedharande

Bradley

SQLBits Agenda and PowerShell, displaying and searching   By Rob Sewell  Twitter @SQLDBAWithBeard

Andres

IoT Production Training Pack by Raul Alarcon  

Josh

Farming from space: How orbital data is unlocking novel agriculture insights by Matt Jennings  Twitter @MattJenningsMS

Neeraj

Power BI Paginated Reports - Subscriptions by Olivier Van Steenlandt Twitter @Oli_Vsteenlandt

Bradley

Advancing Spark - Power BI Databricks Connector with Native SQL  by  Simon Whiteley  Twitter @MrSiWhiteley

Andres

Automatic IoT Edge Certificate Management with GlobalSign EST   by John Lian 

Josh

Using calculation groups or one to many relationships for time intelligence selection   by Alberto Ferrari Twitter @FerrariAlberto

Neeraj

Azure Synapse Spark Notebook – Unit Testing   by Arun Sethia 

Bradley

Provide data lake access with Azure Synapse Analytics  by Patrick LeBlanc, Adam Saxton, Guy In A Cube Twitter @PatrickDBA, @AdamSaxton, @GuyInACube

Andres

Best Computer Vision projects With Source Code And Dataset by Naem Azam  Twitter @naemazamankon

Josh

Announcing the retirement of Streaming Dataflows  by Jadelyn Ray Twitter @MSPowerBI



WEDNESDAY 3-8-2023

On Wednesday we released The SECRET Language of Azure SQL!!! WAIT STATS! That's right Dear Reader 3 exclamation marks. This is serious.  It's also not really a secret. Everyone wants you to know about this.  


In the comments I have links to a great script that Paul Randal (Twitter | @PaulRandal) wrote over a decade ago, to a book on the subject that Thomas LaRock (Twitter | @SQLRockstar) has written.  Check out the video then read Paul's article and order Tom's book.  This is a very critical topic for any SQL DBA or Developer to understand.


SHORTS

We release a whole host of Shorts related to the subject of interviewing for a job as a SQL DBA or for a SQL Developer.  There quality gets better as the week goes along.  I switched video editing tools and was able to improve the quality. 


Here's a list:

 We will see how this goes, bit of an experiment on our part.  We had around 1000 cumulative views on this last week alone.  It's a difficult format because you have a max of 60 seconds to get a fairly technical point across.  If there is something you'd like to see we'd love to hear from you!

WRAP IT UP

Alright Dear Reader.  I've off to SQLBits this week.  Stay tuned to the channel.  We have a SPECIAL Monday content drop, our Tuesday Community Round table, Wednesday MS Tech Bits, Interview clips from previous interviews will be dropping, also maybe some shorts from SQLBits


As always Dear Reader, Thank you for stopping by.


Thanks,


Brad