Thursday, June 1, 2023

Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices

 Hello Dear Reader!  Sorry this is so late, moving houses has gotten me a bit behind this week.  I will do better next week!

As you may have heard last week Microsoft Fabric was officially unveiled to the world.  As a part of this launch we had a few extra live videos as a part of the larger Digital Event that happened in conjunction with Microsoft Build!  We have a ton still to come on Microsoft Fabric and there will be LOTS of videos so stay Tuned!

Also as I previously mentioned, we are moving.  This weekend was a very seminal moment for me.  On Friday after 4 delayed installation attempts the internet was installed in the new house.  That can only mean one thing to me.  Time to move the office.  Once I move the office, I'm working there.  So this weekend I packed up everything, moved it, and set up the office.  From here on out I'm in the new house!

I'm really excited.  While it will not show up on the videos, the ceilings are really high.  I've had pictures, awards, mementos from over my career that have often been packed up in a closet. For the first time I have space to put it all out and it's really kinda awesome.

Lot's of feelings go into this move.  The house we are leaving has been very good to us.  This is where we all truly became the family we are today, went through some very difficult and painful moments, high school for both my boys, COVID, elementary school for my daughter, the kids started dating (something I'm still not sure I'm ready for), some brilliant wonderful happy moments, game nights, movies nights, movie premieres, and BBQ's.

Cheers to you old house, thanks for the memories.... and I hope we get some of our deposit back!

Ok Dear Reader, onto the content.

MONDAY 5-22-2023

On we released my latest video USE Azure Managed Identity to Backup Azure SQL Managed Instance to Blob Storage, NOT SAS Tokens!!


In this video I demo how easy it is and discuss why you should be using Managed Identity instead of SAS tokens to perform your Azure SQL Managed Instance COPY_ONLY backups.  This was a lot of fun to make and a great video


WEDNESDAY 5-24-2023

On Wednesday Neeraj Jhaveri (Twitter | @neeraj_jhaveri) and I presented an Introduction to Microsoft FABRIC!! How to Enroll, How to Opt in, How to build a Data Warehouse!! 



My love for Neeraj has never been a secret the man get's a big introduction on everyone of our Tuesday Azure Data Community Round Tables, and the fact that we got to break the news of Microsoft Fabric meant the fireworks were flying!  We covered how you enroll, towards the end we covered how Power BI Admins make sure to opt into the preview, and I showed how to create a Data warehouse and ingest data!

THE PRE-SHOW

As if that wasn't enough the Tales from the Field team was all together myself, Neeraj, Josh Luedeman (Twitter| @JoshLuedeman), Andres Padilla (Twitter | @Nodestreamio), & Daniel Taylor (Twitter | @DBABulldog) were joined by Adam Saxton (Twitter | @AwSaxton) one half of the dynamic duo of Guy in a Cube(Twitter | @GuyinaCube),  Kal Yella, and the wonderful Bradley Schacht (Twitter | @BradleySchacht) joined us to kick off the Microsoft Fabric Digital Event for Day 1, with the Microsoft Fabric Digital Event Pre-Show Day 1.


We started off by finding out that the Power BI CAT and Azure Synapse CSE Team were now the Fabric CAT Team!  We discussed Day 1, feedback from customers, questions we had seen, and much more.  You definitely want to check it out!

THURSDAY 5-25-2023

As if one extra live show was JUST NOT ENOUGH on Thursday we came back to do the Microsoft Fabric Digital Event Pre-Show Day 2. Adam Saxton, Kal Yella, and Bradley Schacht from the Microsoft Fabric CAT Team joined us.  



We discussed the content from Day 1 of the Digital Event, what you could expect to see on Day 2, and we did DEMO'S!!  Make sure to check this out!


TUESDAY 5-23-2023

On Tuesday we were eagerly awaiting the announcement of Microsoft Fabric on the Build Keynote during the pre-show.  This was our first opportunity to talk about it publicly.  


The star of these shows is, as always the content created by the Azure Data Community.  Without further ado, here it is:


Honorable Mentions

Microsoft Digital Event Pre-Show: Azure FastTrack, Power BI CAT, & Azure Synapse Analytics PG    by  Bradley Ball, featuring Adam Saxton & Bradley Schacht & Guy in Cube Twitter @SQLBalls, @BradleySchacht, & @GuyInACube

Microsoft Build 2023 Book of News 

Neeraj

Using Azure DevOps with Synapse Workspaces to create hot fixes in production environments  by Vytas Suopys Twitter @Vytas Suopys

Bradley

How to take secure, on-demand backups on SQL Managed Instance  by Zoran Rilak Twitter @zoranrilak

Andres

Building Interactive Enterprise Grade Applications with Open AI and Microsoft Azure  by Andrei Zaichikov  

Josh

Spreading your SQL Server wings with serverless SQL Pools  by Kevin Chant Twitter @kevchant

Neeraj

What Is Responsible AI? | Built In  by Ellen Glover Twitter @BuiltIn

Bradley

Junior Data Professionals The Key to Every Data Team's Success  by Abhinav Jayanty + Taylor George

Andres

How to deploy your AI model on Edge devices with Azure  by René Bremer

Josh

Azure SQL input binding for Azure Functions   by Anuraj Parameswaran Twitter @anuraj

Neeraj

Generative AI defined: How it works, benefits and dangers Generative AI defined: How it works, benefits and dangers (techrepublic.com)  by Owen Hughes Twitter @owenrdhughes

Bradley

Reflections on My First-Ever Presentation, Fifteen Years Later  by Tim Mitchell Twitter @Tim_Mitchell

Andres

An Overview of Microsoft Azure NLP Solutions  by Lida Ghahremanlou  Twitter @lida_ghr

Josh

Using Docker on Windows with Persistent SQL Server Settings and Databases  by Josephine Bush Twitter @hellosqlkitty



WRAP IT UP

No assignments this week Dear Reader as it is already Thursday.  I will attempt to resume our normal cadence next Monday!  My hope for you is take some time, rest, relax, and think of the fact that I'm moving the heavy stuff during the hot months in Florida.  Then take an extra deep sip of that ice cold <insert beer, mixed drink, or non-alcoholic beverage of choice />.

Until next time Dear Reader and as always, Thank You for stopping by.


Thanks,


Brad

Tuesday, May 23, 2023

Tales From The Field Weekly Wrap Up for the Week of 05-15-2023 The Graduate & the Very BIG Week

MY WILL, MY BUG, MY GRADUATE

Just a little under 18 and one half years ago, William came into my life.  There are a lot of words to describe a new baby, but the one surround Will's birth is hard to quantify.  Don't get me wrong.  Joy, happiness, elation, wonder, awe, all-encompassing-love, all of those words were there.
Holding Will's hand on day 3

Eventually.  

Will's birth was the most intense 24 hours, and then week, of my life. 

William was my third child, so having one was not new to me, but this experience was.  Whereas his brother and sister had cried loudly, been weighed, and handed over in warming blankets to be cuddled with; William was rushed away.  He was born into this world with a collapsed lung.  

While I've spoken about this, I've never written about it before.  There is a lot flooding back to me just looking at the picture on the screen. He was born just before Christmas and I've always been thankful to the nurses, the doctors, and other stall at the Sentra Hampton Roads Hospital until we moved we used to bring them cookies every Christmas Eve, remembering those wonderful people there over night with us.  

The Graduate & Family
Let me skip forward in time.  William's lung miraculously reinflated.  After 5 days the oxygen hood came off, we were able to hold him, and feed him.  He came home a bright beautiful bouncing baby boy, and grew so very fast.  We have had lots of adventures.  

My Bug, my nickname for Will, loves roller coasters and amusement parks.  I think he is the only person in the family that loves theme parks as much as I do.  For the last 15 years he has been my roller coaster riding buddy.   

Last Thursday he graduated from High School.  Roller coaster riding buddy indeed.  That first hill was a big one.  He is off to college this Fall, but it feels like only yesterday I was holding that little hand.  One of my favorite quotes comes from the Little Buddhist Handbook, "The trouble IS you BELIEVE you have time".  Yes.  That is the trouble.

Next up, we will head to college orentationnext month.  Before then we will move, because we bought a house.  We've all been doing a lot of work on it getting it ready to move in.  William is leading the way on the painting front, having painted his room and helping is younger sister with hers.  The move is officially underway, not just because of the hours of work, or mounds of things we've already moved.  No, the way I know this is I am sore in places I forgot I could get sore.

THE BIG WEEK

We talked about it last week Dear Reader, but a very big week is upon us.  Microsoft Build starts today.  On Wednesday 5/24 & Thursday 5/25 there will be a massive Digital Event that will be simulcast across the Guy in a Cube, Power BI, and Azure Synapse YouTube channels starting at 9 am PST.

One hour before we will be live on the Tales from the Field YouTube channel.  Adam Saxton (Twitter | @awsaxton) of Guy in a Cube (Twitter | @GuyinaCube), Kal Yella & Bradley Schacht (Twitter | @BradleySchacht) from the Azure Synapse PG, and of course Josh Luedeman (Twitter | @JoshLuedeman), Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri), Daniel Taylor (Twitter | @DBABulldog), Andres Padilla (@Nodestreamio), and myself will be live.  

Here are the links to the pre-show:







MONDAY 5-15-2023
On Monday my friend Daniel Taylor released an AMAZING video.  He walked through the process of taking Ola Hallengren's SQL Server Mainteance Solutions and using them with Azure SQL Database using Azure Data Factory.  


If you have Azure SQL Databases in your environment Azure SQL Database Maintenance Plans with DYNAMIC Azure Data Factory Pipeline!!  It is one of our most viewed videos ever, and Dan is very excited to add on to it!

WEDNESDAY 5-17-2023
On Wednesday I released 5 REASONS TO USE Azure SQL Managed Instance!!  This was our first list.  I had several different videos I've made and will make on Azure SQL Managed Instance.



I don't feel like enough people are aware of the service and what it can do.  If there is an item on the list you want to see a longer video on, let me know we always love the feedback!


TUESDAY 5-16-2023
On Tuesday we had our Azure Data Community Round Table featuring content from the creators in the Community for the Community!  We had a great conversation opening the show about Mother's Day weekend and the activities surrounding it for each of us, plus a Happy belated Mother's Day to all the MOM's out there!!!



As always the star of the show is the content, so here is the content by the WONDERFUL creators by order of appearence on the show:

Honorable Mention

·         Microsoft Digital Event Pre-Show: Azure FastTrack, Power BI CAT, & Azure Synapse Analytics PG   by  Bradley Ball, featuring Adam Saxton & Bradley Schacht & Guy in Cube Twitter @SQLBalls, @BradleySchacht, & @GuyInACube

Neeraj

Scaling strategies for large scale AzureCognitive Services deployments  by RK Iyer

Bradley

·         Announcing General Availability of Azure Data Studio extension SQL Database Projects by Steve Jones Twitter @Way0utWest via @SQLServerCentrl

Andres

·         Getting started with Azure Machine LearningResponsible AI components  by Ruth Yakubu Twitter @ruthieyakubu

Josh

·         Azure Resource Inventory by Claudio Merola Twitter @ClaudioMerola_

Neeraj

·         ChatGPT + Python+ Power BI   by Gabe Araujo, M.Sc. Twitter @AIGenesis3

Bradley

·         Script to Decode SQL Server Locking and BlockingWait Resources   by Eric Blinn Twitter @mssqltips

Andres

·         Pandas, Spark, and Polars - When To Use Which?  by Martin Karlsoon Twitter @HelloKarlsson

Josh

·         A Beginner's Guide to Database Reliability Engineering by Kovid Rathee Twitter @Kovid_R

Neeraj

·         How Microsoft can help you go passwordless thisWorld Password Day by Alex Weinert  Twitter @Alex_T_Weinert

Bradley

·         T-SQL Tuesday 162 – Execution plans according toChatGPT  by Hugo Kornelis Twitter @Hugo_Kornelis

Andres

·          Getting aGrip on Data and Model Drift with Azure Machine Learning  by Natasha Savic & Andreas Kopp

Josh

·         TDE: Database Backups and High Availability  by Matthew McGiffen Twitter @mattMcGiffen



WRAP IT UP
Ok Dear Reader remember today is the kick off of MS Build.  If you haven't registered go do it, it takes a few minutes and it get's you free access to the big show.

On Monday we posted USE Azure Managed Identity to Backup Azure SQL Managed Instance to Blob Storage, NOT SAS Tokens!!  if you are using Azure SQL Managed Instance you want to go give that one a look, this is the way we should be doing our COPY_ONLY backups.

Today is the Azure Data Community Round Table, followed by our live pre-shows on Wednesday & Thursday.  PLUS a very special video drop this Wednesday.

We hope you get to spend some time with us this week and as always Dear Reader, Thank You for stopping by.

Thanks,

Brad


Monday, May 15, 2023

Microsoft Digital Event Pre-Show: Azure FastTrack, Power BI CAT, & Azure Synapse Analytics PG

 Next week is Microsoft Build and there is a Microsoft Digital Event occurring on May 24 - 25 starting at 9 AM Pacific Time for a live simulcast with a lot of exciting announcements.  This is EXTENDING into a 2 day digital event!  This is a big event that will be emceed by everyone's favorite hosts Adam Saxton & Patrick LeBlanc the dynamic duo also known as Guy in a Cube

 

Now before we get to the BIG EVENT, we need a pre-show!  The pre-show will be happening as a lead in each day on Tales from the Field  one hour before the Digital Event kicks off.  The Digital Event will take place as a simulcast on the YouTube channels of Power BIAzure Synapse Analytics, & Guy in a Cube.

 

Tales from the Field is a show hosted by four Microsoft data experts from the Azure FastTrack PG, all of the hosts are engineers on Azure FastTrack helping customers and working with Microsoft Product Groups to improve the customer experience.  The hosts of Tales from the field are Bradley BallJosh LuedemanAndrés PadillaNeeraj Jhaveri, & Daniel Taylor.  They produce technical content weekly and hold an Azure Data Community Round Table highlighting blogs, videos, or any other helpful information provided to the community by the creators within community!

 

Their guests for this pre-show will be Adam Saxton Principal PM for the Power BI CAT Team and one half of the dynamic duo that is Guy in a Cube and Bradley Schacht Principal PM from the Azure Synapse Analytics Product Group.




Read the rest of this blog over on the Microsoft Technet Blog here!