In one week from now, on November 6th, PASS Summit 2018 kicks off with its v.20 Celebration party! Yay! :D
This will be the 20th PASS Summit, and my 6th time attending. These years have just gone *whooosh*! I have gone from being a shy first-timer in 2013, a volunteer in 2014, a crazy costume lady in 2015, a triple speaker in 2016, and a member of PASS HQ in 2017. I think this year I’m starting to move backwards – I’m “just” a speaker again! But I’m only presenting two sessions this year :)
I will be presenting one 10-minute Lightning Talk on Azure Data Factory, and one 75-minute General Session on Biml.
While I love talking about Biml, I’m very nervous about my session this year. Why? Because it’s a level 400 session, and that can mean very different things to different attendees. I presented a version of this session at SQLBits earlier this year, and I got feedback ranging from “too basic, needs more demos” to “too technical, needs more explanations”. I’m expecting similar feedback from PASS Summit :)
But! I have been working a lot on this session over the past couple of months. It will be different from what I presented at SQLBits, and it will even be different from the version I presented for MDPUG Norway, which was supposed to be my rehearsal. While I presented for MDPUG Norway, I realized that I had way too many things I wanted to improve, and have been tweaking ever since. Looking forward to it, but also very, very, very nervous!
Anniversary, yay! That’s right, this year I will be attending my fifth SQLSaturday Oregon :D
In 2014, I was a volunteer who ended up doing an impromptu lightning talk about Biml. I returned as an actual speaker in 2015 and 2016, presenting my Biml sessions. 2017 was a different experience when I attended as a PASS representative. In 2018, I’m back as a speaker.
Last year at Microsoft Ignite, I was fortunate enough to interview Mike Flasko and Sanjay Krishnamurthi. This year, I got to have a follow-up chat with Mike Flasko and Sharon Lo! We talked about the recent and upcoming Azure Data Factory updates :)
In this interview, Mike and Sharon share the highlights from their session at Microsoft Ignite 2018. What are visual Data Flows? How are Azure Data Factory Data Flows different from the recently announced Power BI Dataflows? What’s on the Azure Data Factory roadmap? And finally, how can you provide feedback and get involved in private previews?
Azure Data Factory Updates with Mike Flasko and Sharon Lo
(I apologize for the unsteady video :( Unfortunately, I didn’t see how shaky it was until post-production. If it gets too distracting to watch, please just listen. Mike and Sharon share a lot of interesting things :) )
Thank you so much to Mike and Sharon for chatting with me on a busy day!
My Microsoft Ignite week is just about to start, and I’m SO excited! I’ve been looking forward to this week since last year, and it’s finally here, yay :)
Since this is such a huge, special event, I try to make the most of it. And funnily enough, that means… Attending fewer sessions! Yep, that’s right. It sounds a little strange for a conference, I know. But to me, the biggest value comes from meeting other people, and maybe even help someone else. So while I have a few sessions on my must-see list, my schedule is packed with other fun things:
I’m presenting two sessions this year, so they are obviously on my list of things to do ;) You can read about my sessions in my previous blog post Speaking (Twice!)
Live Streams and Recordings
If you can’t make it to Microsoft Ignite this year, don’t worry! You can live stream all the sessions from September 24-28th, or watch the recordings on-demand from September 25th.
Group Idea Swaps and Mentoring
In addition to presenting two technical sessions, I will be leading two Group Idea Swaps and Mentoring sessions. Each group consists of only 8-10 attendees, so it will be much more like a conversation than a presentation. I’m really looking forward to this! I love how Microsoft has added this to focus more on interaction and personal connections this year :)
Earlier today, I ran into an interesting “feature” in the SQL Server Management Studio (SSMS) Results Grid.
During development, I found what appeared to be duplicate data. Uh-oh! I spent three hours debugging my query, looking into the underlying ETL, and doing all kinds of tests. I absolutely could not figure out what was wrong!
Then it hit me. Maybe my query was fine? Maybe the problem was how the results were displayed in the SSMS Results Grid? I tried expanding the columns. And sure enough. There it was. All my data, perfectly fine.
After facepalming, I started laughing. One of my Norwegian phrases is “erre mulig!?” It roughly translates into an exasperated, humorous “how on earth is that possible!?” I kept laughing. And of course, I had to tweet about my fail of the day: