I somehow have been using some form of source control for my entire database career. And I’ve been using Git for the past several years at work. I decided to create a repository as another way to make my sessions and scripts accessible and as better way to organize them, rather than just uploading to the SQL Saturday or user group sites and keep them scattered across multiple folders on my computer.
You would think as someone who has used source control regularly, it would be fairly simple to do. When it comes to that someone being me, you would be wrong.
A while back, someone had sent out a tweet asking if statistics were used for the inserted\deleted tables, or something like that. I finally got a chance to follow up on that idea. Check it out here in the IDERA community forums!
I had the honor of being part of the first Data Platform Discovery Day event, held over two days – one for US and one for Europe. This was a virtual event designed for those who are new to the Microsoft Data Platform. I was honored that they picked me to present my “Back to the Basics: T-SQL 101” session.
I decided this was the perfect opportunity to play around more with SQL Notebooks in Azure Data Studio (ADS). I didn’t give myself a lot of time to get ready – just a couple of days.
It’s official – the PASS Summit 2020 Call for Speakers is open from now (March 26th) until April 23rd. You can find the official announcement here or go straight to the submission page.
This time last year, I saw a lot of people on Twitter stressing about pulling together their abstracts and making sure they submitted on time. As I watched them go through this process, I thought about whether I wanted to submit. I wasn’t sure I was ready to do it yet. Was I a good enough speaker? Did I have a strong enough abstract? As the deadline hit, I decided not submit. There was still a small part of me that wishes I had but again I wasn’t sure I was ready for it. That’s why I made a deal with myself that if Speaker Idol was held again, then I would throw my name in the ring. We all know how that turned out….
Now the question for me is what to submit. I still feel like there’s extra pressure to have an amazing, high quality session because it’s PASS Summit. I definitely have a session or two that I already have ready that I think are good enough to submit and I have a new idea for one forming in the back of my mind. So, my challenge is to pull the new abstract together and clean up the existing ones so I can submit them in time.
The only thing I think I won’t get to experience this year is the stress of wondering whether I’ll get picked or not. Although submitting multiple sessions means I still get to stress about which one gets picked. But for now, I will just enjoy the fact that we knew I was speaking at Summit before we knew Bob Ward was speaking. Pretty sure he’ll still have more people attend his session than mine – which I’m perfectly OK with. I’ll take my little victories where I can find them. But I’m looking forward to seeing who else will be speaking with me this year.
If you are where I was last year – a new-ish speaker who hadn’t spoken at Summit before, I say: Submit. What’s the worst that can happen… you get picked?
I know there’s a lot of craziness in the world right now and who knows what’s going to happen or change on us. But in the meantime, I remain optimistic and am looking forward to planning for the future. See y’all in Houston!
It’s another T-SQL Tuesday! This month, our host is Tracy Boggiano (b|t) Thanks to Tracy for hosting.
(If you’re interested in learning more about T-SQL Tuesdays in general, you can check out the website for past invitations and the background.)
Tracy invited us to talk about our experiences adopting Query Store and if we haven’t yet, why not. This couldn’t be a more timely post. I just enabled Query Store on my test database last week. Seriously – just last week.
I’ve been wanting to work more with Azure Data Studio for a while. I attended Vicky Harp’s (t) session about SQL Server tools at PASS Summit and I really appreciated what I was seeing. But it’s hard to just jump to a new tool without having a goal. I think I finally found some good ones. I have several presentations to work on. After seeing others use Azure Data Studio for demos, I like the way it can add comments around the various code sections in notebooks so I decided that I want to use it for my sessions as well. Plus I like the idea that I can use one tool for SQL and for PowerShell. I can already see how useful that is so I want to play with that ability more as well.
It had been a while since I had installed ADS or updated it or probably even opened it to be honest. I still have it set up to have it show the welcome page when it starts. But this is what I saw:
This should be my final post about Speaker Idol 2019. I’ve said Thank You’s, I’ve told you how I put the presentation together, and now it’s time to give back. Here’s my advice for anyone who wants to do this in the future. Some of these apply regardless of whether you’re competing so I’m breaking these out in general.
It’s been a while since I’ve been able to pull together a T-SQL Tuesday post. But Mala (b|t) has given us a topic that is easy enough that even someone like me, who overthinks and over-edits her posts, can pull something together.
For this month’s topic, Mala asked us what our gifts over the past year have been. The no-brainer answer for me is a supportive #sqlfamily.
I had two pretty big “gifts” recently (you can read about them here and here) – neither of which would have happened if it hadn’t been for the support of this community.
But even more than that, I’ve been able to get to know more people in the SQL community over the past year – too many to mention by name. The fact I can call many of you “my friend” and not just “some random person I stalk follow on Twitter” is a true gift.
I’m look forward to sharing this gift of #sqlfamily with more of you this coming year!
I thought I’d share some more about my Speaker Idol experience. This post feels a little weird for me because I am writing about pulling together my presentation. I say this is weird because I’m not used to talking about myself like this. But my real goal in sharing this is every speaker has a different way they pull presentations together and as this was a very different presentation, I thought I’d share my process. That or I feel the need to milk the Speaker Idol win a little more. Or maybe it’s a bit of both.