Tales From The Field Weekly Wrap Up for the Week of 05-08-2023 Mother's Day, Big News for MS Build, & the recap

 Hello Dear Reader!!  We also have some really, really, BIG NEWS for next week!  It also happens that next week is Microsoft Build, make sure to register for free!  But that news is coming a little later today.

What's that..?  I can't drop a teaser at the begining and then not give you a little more?  That's fair.

...OK Dear Reader here's a sneak peak.  

We have not one, but TWO one hour live shows that will be on Wednesday May 24th & May 25th.  We also have TWO big guests.  

Brad Schacht (Twitter |@BradleySchacht) from the Azure Synapse Product Group AND Adam Saxton ( Twitter | @AWSaxton) aka one half of @GuyInACube will be there.  But that's really all that I can say until a bit later.  Other than, this is going to be fun & this is going to be BIG.  Enough about the future let's talk about last week.

This past week was Mother's Day, happy belated Mother's Day to all the Mom's out there!  My parent's 50th wedding anniversary was this past year.  My siblings and I teamed up to buy them a cruise to Europe and they are out having a wonderful time!!  Because of this Mom was not here this Mother's Day but there are plenty of Mom's to be recognized in the family, more than just those that we get to see locally.  My niece had her first Mother's Day, congratulations Destiny!!  To celebrate we did what has become an annual tradition.  I make mimosa's, we take the ladies to the spa, and we all get pedicures.

Let's start with the mimosa recipe because it is a good one:

• 1/3 a champagne flute of Orange Juice
• 1/2 oz Don Julio Blanco tequila
• 1/2 oz Gand Marnier Cognac & Orange Liqueur
• fill remaining flute with good champagne like Veuve Clicquot

The pedicures started as a simple thing.  I took my wife and her Mom, my amazing mother-in-law Judith Gonzalez to get a pedicure and manicure.  The next year my Mom & youngest Sister came over and I included them.  Instead of just sitting there waiting I decided to join them for the pedicure and the tradition began. 

The next is that every year I get the kids to help me cook Mother's Day brunch.  The main course was by request.  Heart shaped chocolate chip pancakes.  I don't do anything simple.

In my house bananas are enjoyed by all.  So I made a banana's foster's syrup to go with the pancakes.  For this recipe you need banana's, butter, brown sugar, good dark rum (we used my Diplamatico), and maple syrup. 

You make banana's foster, flambe, then you add in the maple syrup and stir, finally ladling over finished pancakes.  Quick tip, the syrup is hot so if you cut fresh unsalted cream butter and put it on the pancake, then pour the syrup, the butter will be perfectly soft when the plate lands on the table.

Pedicures, pancakes, mimosas, all complete I set about fixing a toilet at the new house and installing a bidet.  All in all a very productive weekend.  Dear Reader, I hope you and your family had a great and Happy Mother's Day.  Ok, on to the recap.

MONDAY 05-08-2023

On Monday Andres Padilla (Twitter | @NodeStreamIO) & Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) presented Computer Vision using Azure ML Studio!!  

In this video Andres walk through the steps to connect to Azure machine Learning Studio, Importing the required libraries, downloading the data, all the way through training your model.  

WEDNESDAY 05-10-2023

On Wednesday I released No-Code PERFORMANCE GAINS with Intelligent Query Processing in Azure SQL & SQL Server!!  I walk through 2 different ways to restore the World Wide Importers database into Azure SQL Database. 

Then we review how to provision a Serverless Azure SQL Database and why you want to use Serverless.  Using demos from Bob Ward's ( Twitter | @bobwardms) demos from his amazing SQL Server 2022 class that is available for free here!!  I then show how self-healing Persisted memory grant feedback works in Azure SQL Database by dropping the performance of a query from over 1 minute to less than 2 seconds!

This is in place for Azure SQL Database, Azure SQL Managed Instance, and SQL Server 2022 we just need to have our database compatibility level at 150 or above.

TUESDAY 05-09-2023

On Tuesday it's my FAVORITE half-hour of the week! The Azure Data Community Round Table with Josh Luedeman (Twitter | @JoshLuedeman), Andres Padilla, Neeraj Jhaveri, and myself.  We recapped the fun that we had at SQL Saturday Jacksonville.

After a conversation that covered Guardians of the Galaxy 3, The Flash, and Andre's amazing drone demo at SQL Saturday Jax we got to the real star of the show.  The content.  Here is the content covered on the show in the order of appearance:

Neeraj

• Microsoft Digital Event  by Tyler Mays-Childers, Guy in Cube Twitter @sposit & @GuyInACube

Bradley

• Using the New Open Source SQLCMD to Create Containers by Steve Jones Twitter @Way0utWest via @SQLServerCentrl

Andres

• Everything You Want to Know About Onnx by Janakiram MSV Twitter @janakiramm

Josh

• Four Different Ways to Incorporate Azure Synapse and PowerBI by Ginger Grant Twitter @desertislesql

Neeraj

• Build real-time dashboard with Power BI dataset produced by Azure Stream Analytics no-code editor  by Xu Jiang Twitter @xujx

Bradley

• Automating Database Maintenance on Azure SQL by Josephine (Branch) Bush Twitter @hellosqlkitty

Andres

• Supercharge Archive Content Discovery with ChatGPT and Azure Video Indexer  by Fardau Van Neerden Twitter @thefmister

Josh

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

Neeraj

• Analytics Vidhya's Top 10 Blogs on Computer Vision in 2022  by Sanjana Rajpal Twitter @AnalyticsVidhya

Bradley

• The Blooming of AI Spring  by Patrick LeBlanc & Buck Woody Twitter @PatrickDBA & @BuckWoodyMSFT via @Spotify

Andres

• Microsoft’s New Azure Storage Mover Makes Cloud Migrations Easier  by Rabia Noureen Twitter @RabiaNoureen11 

Josh

• Monitoring SQL Server on Linux Part 1: Installing sysstat (Surviving Without Perfmon)  by Rick Lowe Twitter @dataflowe

WRAP IT UP

A couple of reminders this week.  Don't forget Dear Reader we have our Azure Data Community Round Table Tuesday 5/16 at 1 pm EST. Today we have an MS Tech Bits where our very own Daniel Taylor (Twitter | @DBABulldog) walks us through how to use Ola Hallengren's scripts to set up Database Maintenance on Azure SQL Database using Azure Data Factory! 

Remember to stay tuned for that big news, and as always Dear Reader Thank You for stopping by.

Thanks,

Brad

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