Posted in SQL Server, Source Control

Setting Up Git

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.

Continue reading “Setting Up Git”

Posted in Azure Data Studio, SQL Server

Presenting with Azure Data Studio

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.

Continue reading “Presenting with Azure Data Studio”

Posted in Speaking, SQL Server

PASS Summit 2020 Call for Speakers

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….

20191108_073219
PASS Summit 2019 – testing out the podium

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!

 

Posted in SQL Server, T-SQL Tuesday

T-SQL Tuesday #124 – Query Store 1st steps

TSQL2SDAY-150x150It’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.

Continue reading “T-SQL Tuesday #124 – Query Store 1st steps”

Posted in SQL Server

Setting up Azure Data Studio

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:

Continue reading “Setting up Azure Data Studio”

Posted in Speaking, SQL Server

Speaker Idol 2019 – The Advice

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.

GoodIdea-giphy Continue reading “Speaker Idol 2019 – The Advice”

Posted in SQL Server, T-SQL Tuesday

T-SQL Tuesday #121 – SQL Gifts

TSQL2SDAY-150x150

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!

 

Posted in Speaking, SQL Server

Speaker Idol 2019 – Putting it together

20191108_073219
testing out the podium

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.

Continue reading “Speaker Idol 2019 – Putting it together”

Posted in Speaking, SQL Server

Speaker Idol 2019 – Thank You!

I won Speaker Idol 2019. 

This happened a couple of weeks ago now and somehow that sentence still feels surreal to write. But it happened. It’s on Twitter and everything…

I will definitely have follow up posts about my process putting everything together and advice but I thought I’d keep this one short and readable for now.

So I wanted to start with the Thank Yous, because there are a lot of them.

20191108_163538
Someone fixed my ribbon…

Continue reading “Speaker Idol 2019 – Thank You!”