William, right, 11 years ago the morning of our college tour |
Hello Dear Reader! When I got off the plane from SQLBits I wasn't feeling great. To be honest, I was a little concerned. I'm a diabetic asthmatic. Some people are generally unconcerned when they get a cold, some even feel that way about Covid. Not I.
For years when I get a cold they would linger, antibiotics would need to be perscribed, consumed, and then about a month later my voice would return to normal. I've been very fortunate that my immue system seems to have recieved a kick start in the last few years. No longer is the need for antibiotics absolute.
No longer is a cold a one month sentence of exercise purgatory. Really, I feel lucky. Despite feeling awful on Monday & Tuesday, by Friday morning I felt great and sounded like Barry White. So with me feeling better, my wife very happy with my deep sexy voice, we packed up the car and drove my youngest son William to a campus tour of the University of North Florida.
It was a really beautiful campus and the tour was fantastic. William is going to be very happy up there. I'm familar with UNF thanks to SQL Saturday Jacksonville. It has been held on their campus since my first trip to the event all the way back in 2011 and SQL Saturday #74.
Seeing the campus from the eyes of a perspective student was amazing. I'm used to the excitement of Friday morning pre-con's and the buzz in the air as you follow the SQL Saturday signs to the parking garage.
This time it was following the signs to the Campus Tour, taking in the campus, food venues, gym, and different class rooms. What an exciting time he is about to embark on! As if it wasn't enough, father time gave me a solid kick to the feels. The picture posted above of William and his younger sister finger painting was my Facebook memory. My phone alerted me that I had a memory, and I clicked on it. All I could think of was how time flies. There's no way, when I snapped that picture 11 years ago, that I imagined him getting ready for college.
Alright Dear Reader, let's get to the re-cap.
MS TECH BITS - WEDNESDAY 3-22-2023
My deep voice was in full effect as we took a jump into the Transaction Log. The Transaction Log is an essential part of SQL Server. That's an understatement. That's like saying your lungs are essential. The Transaction Log is fundemental. We look at what it stores, how it holds data, how Virtual Log Files work, and a little bit about recovery models.
If you are interested in replicating the demos, I'm keeping them over in my GitHub Repo for SQL Scripts. The demo envrionment I used for this was a docker container running SQL Server 2022, if you want to know how to set up that environment check out this video.
COMMUNITY ROUND TABLE - TUESDAY 3-21-2023
The Community Round Table featured my sultry deep voice as well as Josh Luedeman (Twitter | @JoshLuedeman), Neeraj Jhaveri (Twitter | @Neeraj_Jhaveri), and Daniel Taylor (Twitter | @DBABulldog).
We did a quick recap of SQLBits talking about the wonderful event, and then we covered the content. No more delays, let's get to it. Content in order of appearence on the show:
Neeraj
Performance Tuning Synapse Dedicated Pools - Understanding the Query Lifecycle by Sarath Sasidharan Twitter @sarathsasidharan2016
Bradley
Call to Action for Female Speakers to Submit to EightKB by Tracy Boggiano Twitter @TracyBoggiano
Dan
SQL: Setting local date and time for a session in Azure SQL Database by Dr. Greg Low Twitter @greglow
Josh
How To Convert Parquet Files into GeoJson Files and Save it in Data Lake using Synapse Notebooks by Sally Dabbah
Neeraj
Creating a custom disaster recovery plan for your Synapse workspace Part 1 by Freddie Santos Twitter @fredguis
Bradley
Building, Deploying, Sharing a Remote Jupyter Book in Azure Data Studio by Steve Hughes Twitter @DataOnWheels
Dan
How I evaluate personal safety at tech conferences by Eugene Meidinger Twitter @SQLGene
Josh
Azure Data Factory Global Parameters and Azure Bicep Templates by Tao Yang Twitter @MrTaoYang
Neeraj
My week at SQLBits 2023: Why You Should send your Employees to Conferences by Kay Sauter Twitter @KaySauter
Bradley
Connecting Power BI to Azure SQL Database using Private Endpoints by Andy Cutler Twitter @MrAndyCutler
Dan
Why read committed is the default isolation level, and what to do next by Kendra Little Twitter @Kendra_Little
Josh
Azure Data Factory CI/CD with GitHub Actions by Olga Molocenco
WRAP IT UP
We did some experiements earlier this month and loved the reception we recieved. We are working hard over here at Tales From The Field, TFTF, HQ to come up with some additional content for next month.
This week we have our Community Round Table on Tuesday & our MS Tech Bits on Wednesday. We hope you will join us for them, and if there's anything you would like to see sound off in the comments! We always love to hear from you Dear Reader.
And as always, Thank You for stopping by!
Thanks,
Brad