Showing posts with label TSQL2sDay. Show all posts
Showing posts with label TSQL2sDay. Show all posts

Monday, June 19, 2023

Tales From The Field Weekly Wrap Up for the Week of 06-12-2023 Cooking, Father's Day, & the Shrinking Household

 Hello Dear Reader! This past week was a busy one.  As we've started to settle into the new house we are transitioning from eating out or having meals delivered, to knowing where the pots & pans are so we can cook again.

I made a really nice beef stew and butter chicken from scratch.  My family is full of picky eaters, so the true litmus test of any meal is the answer to the question, "Is this make it again good?".  The answer to both of those dishes was a resounding yes from even my pickest of eaters.  There was one hold out on the butter chicken, but after a rousing review from the rest of the household my son Will tried it with all of the lack-luster enthusiasm of a 5 year old being told to "eat their vegitables".

I was asleep when he made it home from work and heated it up, but the lack of leftovers in the morning told me I could hang the "Mission Accomplished" banner.

This past Sunday was Fathers Day here and in many countries around the world.  It was a great day over here at Casa Ball.  My Mom, Dad, Mother-in-law, little Sister, beautiful Wife, & the kiddos all went to brunch, we watched a Cubs game (to bad they didn't win), and I grilled out burgers. Also our household and my buddy Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) put together some videos for you all.


Here's one from my family.




Here's one from Neeraj.



And a big HAPPY FATHER'S DAY to all the Dad and the role models guiding people out there!  Your impact will be felt for generations and is essential to all those that you care for.

Father's day brings the realization closer to home that our household is shrinking.  My youngest is off to visit her Mom until early August and my oldest is off to Summer classes at college.  In the Fall my daughter will be back, but my youngest son goes off to college several hours away.  There is a bitter sweet feeling to all of this.  We've done our jobs properly.  The kiddos are starting to be off in the world.  I will need to figure out how to make smaller portions or have more people over for dinner!

All this to say, I remember when they were little and they wanted your attention non-stop.  If you have kids that are those ages appriceate those times, they will pass by before you know it.  But there are many new adventures still to be had, look forward to those as well.

Alright Dear Reader, let's get to that content!

MONDAY 6/12/2023

On Monday Neeraj Jhaveri released his first SOLO video Microsoft Fabric Decision Trees, Deciding Which Service to USE!!


In this video he walks through some of the documentation that we have for Microsoft Fabric to help you understand what services you should use based on your specific skill sets!


WEDNESDAY 6/14/2023

On Wednesday we posted my latest video Microsoft Fabric, Notebooks, Spark, Writing New Tables to our Lakehouse, & Baseball! I doned my trusty Microsoft Zune t-shirt and walked through how to take data in our Lakehouse that we've created using a shortcut so we do not have data duplication, and then how I walk through some data exploration and write out a data frame as a table in my Lakehouse!


I use this to determine the best day of the week to see my favorite baseball team play, the Chicago Cubs.  The key to this is invoking your imagination to see what it possible when using the service.  If you get a chance I hope you will check it out!


TUESDAY 6/13/2023

On Tuesday we had our Azure Data Community Round Table! It was another great show with my colleauges.


As always the STAR of this show is the creators from the Azure Data Community.  Here is the content in order of appearence: 

Neeraj

Announcing Microsoft Fabric capacities are available for purchase | Microsoft Fabric Blog | Microsoft Fabric  by Mihir Wagle (he/him) Twitter @Ravskkaur

Bradley

Working with ALS – ALS Awareness Month 2023  by Steve Hughes Twitter  @DataOnWheels via @SQLServerCentrl

Dan

Hybrid Flexibility in Azure SQL Managed Instance   by Rie Merrit Twitter @IrishSQL

Josh

Foldable SQL Regions   by Jess Pomfret Twitter @jpomfret

Neeraj

Synapse Real-Time Analytics: Discovering the best ways to get data into a KQL database  by Anshul Sharma Twitter @anshuldsharma


Bradley

Azure chaos STUDIO  by Arun Sirpal  


Dan

T-SQL Tuesday #163 Invitation – What is the best piece of Career Advice you ever received  by Gethyn Ellis Twitter @gethyn_ellis


Josh

Announcing a general Availability of SQL Bindings for Azure Functions     by Drew Skwiers-Koballa Twitter @SysAdminDrew

Neeraj

Things to Do for Father’s Day: 20 Fun Ideas   by Alison Ensign  Twitter @FamilySearch

Bradley

Get skilled on Microsoft Fabric – the AI-powered analytics platform  by Shannon Lindsay Twitter  @shan_gsd


Dan

PostgreSQL Tutorial for beginners   by Daniel Calbimonte Twitter @SQLShack

Josh

Create Your Own Microsoft Fabric Environment  by Kevin Chant Twitter @kevchant



WRAP IT UP

Ok Dear Reader, don't forget we have our Azure Data Community Round Table at 1 PM EST on Tuesday, and today Daniel Taylor (@DBABulldog | Twitter) will have his latest MS Tech Bits posted at 12 PM EST today!!  SECURE Azure SQL Managed Instance Backups with Azure Storage Private Endpoints!! 

Make sure to check that out when it is LIVE.  I hope your weekend was wonderful, if you have something you did that was awesome sound off in the comments!  I 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