Showing posts with label Azure Data Explorer. Show all posts
Showing posts with label Azure Data Explorer. Show all posts

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



Monday, February 6, 2023

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

 Hello Dear Reader!  After a weekend with a lot of activities, it was a down week here at Casa Balls.  Woke up and walked a lot.  I'm still not back to running.  A groin pull is not something I've had a lot of experience with, yet it entered my life in December and I cannot wait for it to leave.

I miss running, last year I ran 755.1 kilometers.  Right now I can walk, as long as my pace is not too quick, and I can ride a bike.  The key is really to get out in the morning, take in some sunshine, and get the blood flowing.  

If I can do that I find that helps put me in the proper headspace to be productive during the day.  One of my favorite things as of late it take pictures.

In the morning I set out and take pictures as I walk around the neighborhood.  Even when I did "run", it was actually interval running.  The reason I note that is I tend to take pictures when I'm in the walking portion of my interval run.  With the exception of my phone, I do not carry a camera on me.  I still  manage to get some really great pictures of the day.  

So this weekend was a lot of walking, cooking, and hanging out.  I hope you had a great weekend, and made it out to enjoy some time outside or inside amongst family and friend. On to the re-cap!


Tuesday 1-31-2023

On Tuesday we had Andrew Nathan (Twitter | @AndrewNathan05) Principal Engineering Manager from the Azure FastTrack Core team was our special guest.  We discussed the Zero Trust Security imitative by Microsoft that all customers should consider when building their architecture.  We also discussed International Travel Tips ahead of SQLBits!  SQLBits is the largest Microsoft focused Data Community conference in Europe.  This year it is Hybrid which means Dear Reader, if you cannot make it in person you could still attend this fantastic conference.




We played our hosting show, I was the host this week!  Want to know who won?  Check out the video above to enjoy the show and find out!


Wednesday 2-1-2023

NEW THIS YEAR! We will be dropping weekly technical content every Wednesday, our MS Tech Bits.  This week it was my turn to produce a video.  I was working with a friend and they wanted to know how to troubleshoot deadlocks they were experiencing.  The first step in that process is understanding what is a deadlock and how to find them when they occur.  So I made this video How to Monitor Deadlocks in Azure SQL Managed Instance to help.


This is a fun little video where I walk you through the process.  Also there is a bit of an easter egg in this vide.  If the shirt I'm wearing on the video looks familiar that's because I wore this in another blog post, and it means a lot to me.

Thursday 2-2-2023

On Thursday we had our Community Round Table.  This is one of my favorite shows every week because we get to give a shout out to the great content producers in the community.  People writing blogs, producing videos, or even GitHub repositories that help people get things done.  It's just amazing.


Here's a list of the content featured on the Round Table in order of appearance:

Neeraj

International Travel Tips: 26 Things to Know Before Going Overseas by Clark Howard Twitter @ClarkHoward

Bradley

Network, Develop & Share @ SQLBits 2023 | Data Exposed Exclusive   By Rie Irish & Simon Sabin Twitter @IrishSQL & @simon_sabin & @SQLBits

Andres

How to integrate Azure Databricks with Azure Machine Learning for running Big Data Machine Learning jobs?   by Pieter Sterkens

Josh

Introducing 'Managed AirFlow' in Azure Data Factory  by Avishek Narain Twitter @narainabishek

Neeraj

12 Tips to Prepare for an International Trip by BenĂ©t J. Wilson Twitter @benetwilson

Bradley

Tempdb Performance Improvements in SQL Server 2022 are Dramatic by Monica Rathbun Twitter @SQLEspresso

Andres

Unleashing the power of AI with Azure OpenAI: A simple guide to get started.  by Meer Alam Twitter @alamMeer

Josh

Beginner's Guide to Azure Data Factory by Catherine Wilhelmsen Twitter @cathrinew

Neeraj

International Travel to and from the United States   | CDC by The CDC Twitter @CDCgov

Bradley

Ready to be a Kusto Detective with Azure Data Explorer? By Patrick Leblanc & Guy In A Cube Twitter @PatrickDBA & @GuyInACube

Andres

MLflow 2.0 and Azure Machine Learning by Facundo Santiago Twitter @santiagofacundo

Josh

When to have Multiple Data Lakes   by James Serra Twitter @jamesserra


WRAP IT UP

And now we draw the blog to a close.  We have a great line up this week!  Make sure to tune in Tuesday at 1 pm EST for a very special guest.  Wednesday we have our second MS Tech Bit coming up with my co-hosts Andres Padilla and Neeraj Jhaveri covering Tips and Tricks for Migrating Azure Data Lake Gen 1 to Gen 2.

On Thursday we will wrap up our week with our Community Round Table also at 1 pm EST.  I hope you all have a wonderful week, and as always Dear Reader.  Thank you for stopping by.


Thanks,


Brad