Hello Dear Reader! Last week was an incredible week. We dropped new content on Monday, Tuesday had the Community Round Table, Wednesday MS Tech Bits, and released YouTube Shorts all week long.
We also waded into controversy on Twitter. It began with a seemingly innocent and funny post by Buck Woody (Twitter | @BuckWoodyMSFT) and well.... it just took off from there.
Needless to say, anyone who doesn't like Pineapple and Peperoni on their NY Style pizza clearly has never tried it and is therefore wrong. End of discussion.
A quick note.
*Hawiian pizza is disgusting. Canadian Bacon is a lie. Real Canadian Bacon should be maple coated real-bacon. Not ham. Ham should not be on a pizza, with the only exception being a supreme pizza.
End note.
My Mom & Dad were over for my youngest daughter's 13th birthday. Happy Birthday Serenity! During which my father, who ran a pizza restaurant, and spent over 25 years in the restaurant business. had never tried it. He did, and he was surprised how good it was. He even went for a second slice!
On to the recap!
MONDAY 3-6-2023
Andres Padilla (Twitter | @NodeStreamIO) & Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri) kicked off Monday with an introduction to Azure OpenAI.
This video has proven very popular, I'm not going to ruin it for you. Head over and take a look. Andres walks us through registering to gain access to & then shows us some of the Azure OpenAI playground.
TUESDAY 3-7-2023
Tuesday is the new home to our Community Round Table. It was a great show, but as always the star of the show is the content from the Azure Data Community.
List of content in order of appearance on the show:
Neeraj
•AWS Lambda Function to import CloudTrail Logs to Azure Sentinel by Sreedhar Ande Twitter @sreedharande
Bradley
•SQLBits Agenda and PowerShell, displaying and searching By Rob Sewell Twitter @SQLDBAWithBeard
Andres
•IoT Production Training Pack by Raul Alarcon
Josh
•Farming from space: How orbital data is unlocking novel agriculture insights by Matt Jennings Twitter @MattJenningsMS
Neeraj
•Power BI Paginated Reports - Subscriptions by Olivier Van Steenlandt Twitter @Oli_Vsteenlandt
Bradley
•Advancing Spark - Power BI Databricks Connector with Native SQL by Simon Whiteley Twitter @MrSiWhiteley
Andres
•Automatic IoT Edge Certificate Management with GlobalSign EST by John Lian
Josh
•Using calculation groups or one to many relationships for time intelligence selection by Alberto Ferrari Twitter @FerrariAlberto
Neeraj
•Azure Synapse Spark Notebook – Unit Testing by Arun Sethia
Bradley
•Provide data lake access with Azure Synapse Analytics by Patrick LeBlanc, Adam Saxton, Guy In A Cube Twitter @PatrickDBA, @AdamSaxton, @GuyInACube
Andres
•Best Computer Vision projects With Source Code And Dataset by Naem Azam Twitter @naemazamankon
Josh
•Announcing the retirement of Streaming Dataflows by Jadelyn Ray Twitter @MSPowerBI
WEDNESDAY 3-8-2023
On Wednesday we released The SECRET Language of Azure SQL!!! WAIT STATS! That's right Dear Reader 3 exclamation marks. This is serious. It's also not really a secret. Everyone wants you to know about this.
In the comments I have links to a great script that Paul Randal (Twitter | @PaulRandal) wrote over a decade ago, to a book on the subject that Thomas LaRock (Twitter | @SQLRockstar) has written. Check out the video then read Paul's article and order Tom's book. This is a very critical topic for any SQL DBA or Developer to understand.
SHORTS
We release a whole host of Shorts related to the subject of interviewing for a job as a SQL DBA or for a SQL Developer. There quality gets better as the week goes along. I switched video editing tools and was able to improve the quality.
Here's a list:
- SQL Interview Questions - Understand the Versions of SQL
- SQL Interview Questions - Follow Up After the Interview
- SQL Interview Questions - Understanding Wait Stats
- SQL Interview Questions - Understanding Execution Plans
- SQL Interview Questions - How do you pronounce 'SQL'?
- SQL Interview Questions- the Data Community
- SQL Interview Questions- The Worst Question Ever
- SQL Interview Questions- DON’T RELY ON 3rd Party Tools!
- SQL Interview Questions- Know the basics Clustered Indexes
- Next Week SQLBits 2023!!
We will see how this goes, bit of an experiment on our part. We had around 1000 cumulative views on this last week alone. It's a difficult format because you have a max of 60 seconds to get a fairly technical point across. If there is something you'd like to see we'd love to hear from you!
WRAP IT UP
Alright Dear Reader. I've off to SQLBits this week. Stay tuned to the channel. We have a SPECIAL Monday content drop, our Tuesday Community Round table, Wednesday MS Tech Bits, Interview clips from previous interviews will be dropping, also maybe some shorts from SQLBits.
As always Dear Reader, Thank you for stopping by.
Thanks,
Brad