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