Category Archives: Summit

Transitions and Regrets?

Posted on by
Reply

I was originally going to write a bit on the death of Queen Elizabeth II and reflections of mortality in general but thought I’d talk about a bit more about a more personal change.

It’s not news to my readers that I’m working to get into PA School. If all goes well, this means eventually I’ll move completely out of being a DBA and purely into the medical world. But this is not a quantum leap (which I have to say, I was pleased with the premiere of the new series last night). Things are not happening over night. I still have course work and patient contact hours to get in. The process is somewhat gradual. But, due to a biological need to sleep, it does mean I need to balance my obligations and in some cases turn my back on certain things.

I was reminded of one of those yesterday: PASS Summit. I’ve written about my previous experiences here and here and more. I’ve really loved my time visiting Seattle to attend it. I also enjoyed presenting, albeit it virtually. Besides being a great opportunity to meet with vendors and to attend a LOT of great sessions, it’s a great place to make friends and to catch up with friends. And yet, I’m not going this year. Under the old scheme, I had the advantage of being a User Group leader and as such getting a free pass. This helped me cost-wise, which as an independent consultant was a bonus. That wasn’t available this time around, so that figured into the decision a bit. But perhaps far more decisive was that I really don’t feel like I can take the time off from school.

What makes this doubly tough on me is that there are a lot of friends I really was hoping to catch up with in person and the fact that for the first time, I’d be an actual Friend of Redgate, an honor I’m proud of and with Redgate being the folks in charge, something I wanted to be more a part of than in the past.

I also did not put in to speak this year, because I knew I’d have classes during this time. I had been excited to be picked in 2020 to speak. The impact of Covid forced the conference to go virtual which dampened my excitement some.

So at the end of the day I had decided not to go and pushed the decision to the back of my mind. I figured I had no real regrets.

Then yesterday, a client asked me some questions about Summit and asked me to suggest some sessions that his people might get value out of and to give him some other notes about Summit.

So I had to pull the scab off the wound and to look at all the sessions. I of course saw a lot that applied to my client, but also some I knew I’d be interested in. And of course I saw easily a dozen names of people that I knew. This reminded me how much I’ll miss the social aspect of Summit. So it hit home. I’m going to miss Summit. The regrets are there.

I’ve given a lot of thought over the last 9 months about how my decision to apply for PA School would impact my life. Slowly pulling away from the #SQLFamily is one of them.

This doesn’t mean it’s going to be a complete break just yet. I actually have hopes of applying to speak at Summit next year since by then I should have all my pre-reqs done and have the time to attend. But in the meantime, I have to sometimes pull back from #SQLFamily events to focus on school and I’d be lying if that didn’t hurt a bit. What smooths this some though is exactly how much I’m enjoying my work to move towards PA School. So, on the balance, it’s worth it so far.

T-SQL Tuesday – The Conference That Changed Everything For Me

Posted on by
1

My faithful readers get a double dose today, only because when I wrote my earlier post I had not yet seen the invite for this month’s T-SQL Tuesday. Otherwise I would have started with this post (and perhaps written a better version of it. This will be a bit hurried).

Like many I’m picking PASS Summit. No, not very creative, but true and accurate. I should note my first conference was SQL Connections back in I believe 2006 or 2007 in Orlando and that had a fairly important impact on me too. But my first PASS Summit in 2015 had a bigger one. I managed to go in the place of our SQL Server User Group organizer provided I attended the User Group update the day before and also represent us officially in that capacity. I of course did both.

But I also had an ulterior motive for going. Two of my best friends from college lived in Seattle and I had not seen them in years, in fact in well over a decade. So it was a good chance to catch up with them. (Let me just say, flying from the east coast to the west coast and trying to go to bed at 1:00 AM West coast time, but waking up at 7:00 AM doesn’t work well!)

That said, the real reason this conference was so important was because I met Kathi Kellenberger @AuntKathi. She gave a presentation on how to get published. For years I had given thought to writing a book and with the recent death of my father, who had always wanted to write the Great American Novel this seemed like an interesting session to attend. She of course gave a great presentation. I spoke briefly with her afterwards and then went on to the next session. But her session stayed in my mind. Later that day I tracked her down and asked further questions and before I knew it I was introduced to her rep at Apress.com. Very quickly I was discussing my idea with him and before I knew it, he expressed and interest and suggested I submit a more formal idea via email. Within a few weeks of the conference I did so and my idea was accepted. That was the easy part. Translating my thoughts to paper was a bit harder. But a year later by the 2016 Pass Summit I was a published author. My dad wasn’t around to see it, but the book was dedicated to him. It wasn’t the Great American Novel and honestly, sales never lived up to even my more pessimistic expectations, but that doesn’t matter. Someone paid me for my writings! And you can still buy a copy of IT Disaster Response: Lessons Learned in the Field, my take on combining IT Disaster response with thoughts on plane crashes and cave rescues. It’s not the most technical book, nor was it intended to be, but it was meant to be sort of a different and more holistic way of looking at responding to disasters. Instead of talking about “do backups like this” it talks about using ICS (Incident Command System) and CRM (Crew Resource Management) techniques to help respond to your disaster.

I’m not here to sell you on my book but talk about how that one conference and that one chance encounter with the right person changed my life. But I won’t stop you from buying it. It’s a quick and I thikn fun read! And you might even learn something.

I’ve enjoyed all my PASS Summits, including 2020 when I finally had a chance to present (albeit remotely) and SQL Saturdays (where I’ve learned a LOT and owe too many people to name a great deal of thanks for all they’ve taught) but that first Summit was the one that probably had the most impact.

Thanks for reading.

Summit Recap

Posted on by
Reply

As many of my readers know, last week was the 2021 PASS Data Community Summit hosted by Redgate. In the past I would have travelled to Seattle to attend in person. Last year, due to Covid the Summit became a virtual event. I was a bit disappointed since I had finally been selected to present and was looking forward to doing so in person. I ended up presenting virtually. That alone would have been disappointing enough, but there were other issues and basically the underlying structure that supported PASS and its structure went belly-up and declared bankruptcy.

More Thoughts on Last Year’s Summit

My recap last year was positive but I have to be honest now. I was certainly trying to put a good spin on things. The truth is, I was more frustrated than I originally let on. I’m still not only grossly disappointed by the poor closed-captioning, I’m still a bit offended. I’m as guilty as anyone for probably not being inclusive enough when it comes to things like color-blindness, difficulty of hearing, etc, but to know that the organization had weeks to get good closed-captioning done, and didn’t still offends me.

I was also extremely insulted when weeks before the Summit, User Group leaders were asked to pony up money to attend. A benefit of doing the work of leading a User Group has traditionally been a free ticket to Summit. To have that change weeks or just a few months before Summit, especially one that was going virtual definitely felt like a bait and switch.

This and some behind the scenes factors in regards to PASS had left a bitter taste in my mouth. Then of course we finally got word that PASS as an organization was no more.

There were wails of anguish, and rending of garments, and wearing of sackcloth. (ok, I may be overdramatizing a bit). But I was hopeful. As I stated then, PASS really is the community. It’s the people. And they’re some of the best people I’ve known professionally: #sqlfamily.

This Year’s Summit

So, on to Summit this year. Within months of the demise of the former structure, Redgate announced it was buying the intellectual property associated with PASS. Microsoft in the meantime was rolling out tools to help the user groups. Steve Jones was working on SQL Saturday. Things were looking good. I was hopeful.

Redgate announced the Pass Data Community Summit would happen, albeit virtually. I was excited and looking forward to it. That said, I’ll admit I did not put in to speak this year. I just didn’t have the motivation. This was a mark on me, not on Redgate’s efforts. Redgate also announced that while the precons would cost money, the Summit itself would be free. Last year there was a lot of discussion about charging for a virtual summit and while I defended the concept a bit, because there are still enormous costs associated, I also was not a fan of it, because I knew it would be a hard sell to managers. I think I was proven right there. The very preliminary numbers I heard for attendance this year appear to have FAR outpaced the numbers for last year. I think that’s a good sign.

So, enough rambling, what about Summit this year?

First two criticisms

I common complaint, and one I knew I was guilty of, was it was unclear that for many sessions one was supposed to watch the recorded session first and then attend what was essentially a live Q&A. I know for the first presentation I attended on Wednesday, even the presenter, who was in the Q&A was confused by this. I’ll admit, I never did figure out how to watch the recorded sessions beforehand.

The second was, I didn’t discover the Spatial.Chat system until the 2nd day, and that was only because I am a Friend of Redgate had received a specific email inviting me to a private chat.

Now, partly, I will put the blame for the above two criticisms squarely on myself for probably not reading the emails in enough detail. But, it does seem others had the same issue and perhaps more succinct, clear links or emails might have helped. I honestly don’t know.

The Positives

That said, despite the above criticisms, I really enjoyed Summit and in a huge part because once I learned about the Spatial.chat system and how to use it, I for the first time, felt like I was in a virtual space that closely mimicked real life. The idea of being able to move closer to people to hear them better, or to move away if I wanted to focus on some work but still be “part of the crowd” worked REALLY well. Trying to translate a physical presence into a virtual one is often tough, but I think the Spatial.Chat stuff worked really well. I found myself hanging out there more than anything else.

Since I never did figure out how to watch recorded stuff before the live Q&A, I focused on the actually live sessions and they did NOT disappoint. As usual, while folks talk about how great the social atmosphere is at Summit, the truth is we tell our bosses we go for the technical content and it was topnotch as expected. Once again great content!

I also really enjoyed the Keynotes this year. I’ll admit, because of jetlag and because I’m often up late talking with the college friends whose house I crash at while in Seattle, I am often late to the keynotes (if I make it at all) and sometimes doze off in the large, warm dark room. This year, none of that happened. I was entertained and really enjoyed them. I especially enjoyed Brent Ozar‘s Keynote on Friday and the impact of the Cloud on ones career.

I think this year’s Summit overall felt more positive for a number of reasons. For one, I think many of us are finally hoping to see a light at the end of the Covid Tunnel. For another, I think most of us are far more hopeful about the overall #SQLFamily community and future PASS Summits than we were a year ago. Finally, I think we just all felt the need to socialize again, albeit it virtually.

Redgate has already announced next year’s summit will be in Seattle again next year, but will be a hybrid event. I will be very curious to see how that works, but I can tell you right now I’m already budgeting to attend in person.

  • End note: I am a Friend of Redgate and write for their Simple-Talk blog. That said, in this case Redgate isn’t paying for my thoughts and my thoughts are my own.

Impact and Legacy

Posted on by
Reply

One of my favorite movies for many reasons is Dead Poet’s Society. Robin Williams is excellent in this role. Shortly after his death, Apple repurposed a short segment that I’ve always loved where he quotes my favorite poet, Walt Whitman: What will your verse be?

“That the powerful play goes on, and you may contribute a verse.” – Walt Whitman.

I’ve been thinking more about my legacy and the legacy of others and this week seemed a good time to muse on that. This is the week that in the past many of us would travel to Seattle (or in years before my time, other cities) and gather at PASS SQL Summit. This year things area bit different, but Pass Data Community Summit is happening, albeit remotely. Though at times like this, I can’t but help think of and riff on a line from the Passover Seder, “Perhaps next year in Seattle.” So in any case #SQLFamily is on my mind. And here’s my thoughts on the impact of some individuals.

Let me start with saying this is FAR from a comprehensive list of the people who have had an impact on me. If I didn’t name you, that’s more an oversight on my part and please don’t take it as a slight. And there’s really very little order to this.

Grant Fritchey – I’m sure I remember my meeting with Grant better than he remembers meeting me (is oft the case when a presenter or instructor teaches so many) but it was at a SQL Saturday in Boston where I first heard him speak, in this case on HIPAA. From there I learned not only more about SQL but about #SQLFamily itself and how important this community truly was.

Rie Irish – I want to say it was a SQL Saturday in Philadelphia, but I could be wrong. I was one of two men in her talk  Let Her Finish: Supporting Women’s Voices in Technology. Turns out the other was a friend she had asked to attend. I still wish more men had attended, it’s still a great topic. Rie has helped me be more aware of diversity issues in this community and called me out at least once or twice when I needed it. She’ll be speaking at my user group in a few months and can’t wait.

Andy Mallon – There’s just something infectious about being around Andy that no matter what my mood makes me want to smile.

Bob Ward – Despite him being a Dallas Cowboys fan, he’s an all-around good guy. More seriously, despite how hard he works for Microsoft, he always takes time out to speak to the community and I’ve been honored to have him speak at my local User Group more than once. And despite the general advice to “not type during a demo” he’s brave enough (or crazy enough) to pull out the debugger and debug SQL Server live!

Kathi Kellenberger aka Aunt Kathi – At my first Summit I attended a talk by her on writing a book. What a long strange trip it’s been since then. I wrote my first book and numerous articles for Redgate since then. And yes, I did say first book. I have ideas for others.

Jen and Sean McGowan – Not only have I spent plenty of time on their coach in their booth at Summit, I still find Sean’s class on regexp usage in SSMS, especially for find and replace to be one of the more useful technical skills I’ve learned that arguably isn’t really T-SQL specific.

Tracy Boggiano – For being their during Covid and for making me more aware of mental health issues. And I’m proud to say I’ve got her first ever signature on a book she co-authored with Grant Fritchey!

David Klee – My go to man on certain subjects who knows more about VMWare tuning than I’ll ever hope, let alone want to know. His current Twitter profile picture is a bit misleading, as it suggests a rather sedate, mild-mannered person, but the reality is there’s a mischievous streak there.

Deborah Melkin – I first saw her speak at our Albany SQL Saturday and was immediately impressed, especially as it was her first SQL Saturday. I immediately cornered her and didn’t so much ask as told her to prepare a topic to present to our user group. She happily obliged. One of the aspects I really like about her presentations is she can take a topic that may appear to be a 100 level topic, but still have something new to teach to experienced DBAs.

Andy Yun – I of course now can’t mention Deborah without bringing up Andy’s name. We first met at a SQL Saturday Chicago where I had a blast. At the time it was my most western SQL Saturday gig (since surpassed by two in Colorado Springs). Always helpful and just fun to be around.

Steve Jones – If nothing else, his Daily Coping Blog posts have been a light in my day (even I only skim them). That said, I honestly, don’t know how he gets time to write so much AND do actual work!

Hamish Watson – Despite being literally half a world away, great fun to be around and has shared his great chocolate me, and for that alone he gets a mention.

There are so many more folks that have had an impact: Monica Rathbun, Chris Bell and Gigi Bell, Andy Levy, John Morehouse, Matt Gordon, Kimberly Tripp, and so many more. If I’ve left a name off, I apologize. Honestly, there are dozens of members of the #SQLFamily that have had an impact on me. The only folks I’m not intentionally naming are folks local to me, simply because I want to focus on the larger, worldwide community as a whole. The folks local to me hopefully already know how important they are.

In years past, I’d be looking forward to seeing many of them in person at Summit, but this year the best I can do is perhaps see them virtually and remember them this way.

You may notice a theme too: the impact hasn’t always been directly database related. While it’s true I’ve learned some great database tips from everyone above, their impact has been larger than that. And all of the above folks are more than simply folks who “work on the Microsoft Data Platform”. They’re folks who have lives outside of that. Some rock-climb, some run up buildings, some love to cook, others love to bake, others love to work on their houses, or love to talk about their dogs or cats. And I care about all of them

They’ve each introduced a verse (or more) into the powerful play of both #SQLFamily and to my life. And I’m eternally grateful. Thank you.

Feeling Older

Posted on by
Reply

This is probably far from the last time I’m going to write on the subject, and certainly not as in depth as I plan to someday, but this past week made me feel past my prime.

While in many ways I believe age is just a number, the truth is, it does change us. While I am still very active, such as biking a century ride last year, still caving and teaching cave rescue, the reality is, the body and mind are slowing.

I’ve been working with SQL Server in one form or another since 4.21. I’ve spoken at PASS Summit, I’ve presented at more SQL Saturdays and User Groups than I can remember. I’ve published a book and numerous Red Gate articles and I’ve mentored more than a few people over the decades. I’ve worked at two start-ups (not counting mergers and acquisitions) and been a consultant before, between and after those gigs.

So I think I can safely say I’m comfortable with my credentials.

That said, the past week really made me consider if it was time to hang up my cap, or at least change caps again. I won’t go into details, other than to say a particularly stressful project for one of my clients reached a major milestone. I’m actually just one small cog in a much bigger piece of the project, but it’s a fairly important cog. And, it had issues. Now, I’ll put on my shoulders that a bit was due to issues with my code and some assumptions I had made. Most of the issues actually stemmed at a far higher level and with another consultant agency working on the project. Let’s just say that GIGO still thrives. But some of it I realized was, I was slightly off my game, and I think a bit of brain fog was involved. I don’t know if that was age related, simply a result of being cooped up for well over the last year due to Covid or what.

Regardless, the culmination of all that and other issues, some personal, started to come to a head. By Friday I was seriously wondering how much more I had left in the tank, physically and mentally.

Today I will admit I’m in a better place. The last major piece of code I needed to get working finally succeeded in production last night and the GIGO problems seem to be disappearing.

But that was after a long weekend of introspection about where I’m headed. I am at that age where retirement is no longer some far off nebulous goal, but an actual reality I have to consider. I’ve always known I’ll probably never truly retire; I do enjoy being busy and working too much. However, I have for several years now done the delicate balance between making sure I hit certain target goals for income and actually enjoying my work. Last week that balance was way off. I need to get it back.

This is my long-winded way of saying that for the first time in years, I’m honestly not sure what I’ll be doing a year from now. Perhaps I’ll still be consulting in my current form and enjoying it. Perhaps I’ll go back to a full-time 9-5 gig; I have come to realize, I deeply miss the management side of work. For my two stints as a full-time employee I was a manager and honestly, I loved that. I miss it. Perhaps I’ll be consulting in a very different way going forward. Maybe I’ll invest in real-estate. Perhaps become a vagabond teaching cave rescue across the country (this last one is not as far fetched as it sounds, I am planning on teaching at least 2 if not 3 different classes next year.)

But I think change is coming again. It’s the season.

Coping

Posted on by
Reply

I’m going to be a bit more open than I usually am in my blog posts. I think it’s time for a bit of transparency.

Let me start by saying that overall, despite the impact of Covid, the last 15 or so months have not been terrible for me. Far from it. In fact I’ve been very fortunate. So this post isn’t a rant or a series of complaints. It’s really a short reflection.

Last year for example, I biked more than I had in years, and in fact did my first century ride since college. I presented at PASS Summit for the first time, albeit virtually. I got to spend more time with my kids. Fortunately, no one close to me had a serious case of COVID nor died from it (though I had friends and former coworkers who did lose people close to them).

I even managed to organize and pull off a cave rescue training class late last summer. And of course just pulled off another weeklong course this month, and will help with another one in late August.

So overall, it’s been a pretty decent 15 months.

But lately I’ve noticed things aren’t necessarily where I want them to be. My motivation levels have been off. I’ve got at least 3-4 ideas for more articles for Redgate. But, I find myself finding reasons to put off writing them. I’ve got a few other projects that I haven’t made progress on. I need to finish tiling a backsplash in my bathroom, patch a hole in the wall in the downstairs bathroom from when I put in a fan, and a few more.

But honestly, the idea of launching into such projects just makes me go “bleah”.

I think too some of the frustration in my inability to attract new clients like I was hoping to this year has put me into the “bleah” mode, and of course in a vicious cycle caused me to put less effort into attracting new clients.

But, ultimately, I’m writing this post not because I’m looking for sympathy or for comfort, but ironically for the exact opposite reason. I find that often people hide the state of their emotional well-being and put on a happy façade, especially on social media, and as a result everyone goes around thinking that everyone else is doing better than they are themselves doing. So, I’m saying, “hey, I’m doing great, but you know what, there are days when life is ‘bleah’ and it’s ok. And if you’re having such days, or even worse, you’re not alone.”

Postscript: I want to add, if you haven’t, check out Steve Jones blog, he’s been daily posting a bunch of coping suggestions. I don’t read them every day, and I suspect Steve would agree with me that take what works for you and ignore the ones that don’t is the way to go. In part his posts helped inspire this one.

Changing Technologies – T-SQL Tuesday

Posted on by
Reply

Select <columns> from Some_Table where Condition=’Some Value’

T-SQL Tuesday Topic

The above statement is pretty much the basis of what started my current career. Of course it actually goes back further than that. I have a Computer Science Degree from RPI. So I’ve done programming, learned hardware and more. I even took an Intro to Databases course while at RPI. I still recall the professor talking about IBM and something called Structured Query Language. The book had a line that went something like “while not the most popular database technology, its use may grow in the future.” Boy did it.

When I first started working with SQL Server, it was 4.21 and for a startup. I had a lot to learn. Back then, a lot was by experience. Sometimes I made mistakes. But I learned.

When I started at that startup, if one could write basic queries and backup and restore a database, one was a half-way decent DBA. Knowing how to tune indices was a definite bonus, as was knowing things like how to set up log-shipping and replication.

Back then, besides experience, I learned new stuff two ways: SQL Server Magazine and the SQL Connections conference. Work paid for both. It was worth it. But honestly, there wasn’t too much to learn. But there also weren’t as nearly as many resources as there were today.

Fast forward 30+ years and here I’ve written a book, worked for several startups, regularly write about databases and database related topics, and often presented at User Groups, SQL Saturdays and at the now defunct PASS Summit. Today as a consultant I regularly touch the SQL Server Query Engine, SSAS, SSRS, SSIS, use PowerShell, write the occasional C# and VB.Net, sometimes do work on a Linux machine or VM and more. A lot has changed.

Obviously the technology has changed. So how have I responded? By doing what I said above. This may sound like a tautology or even circular reasoning but it’s true. When I would go to a SQL Saturday, I’d often attend 3-5 different topics. I’d learn something. But then I started presenting. And that forced me to learn. As much as I may like to think I know about a topic, when I go to present about it, I like to ensure I know even more. This forces me to read white papers, other articles and perhaps attend other sessions.

When I’ve written an article, I’ve often had to do a lot of research for it.

So strangely, I would say a bit part of keeping my skills up to date is not just learning from others, but from teaching. Teaching forces me to keep my skills up.

In summation, I’ve responded by learning from others, but also forcing myself to teach myself before I taught others. It’s a feedback loop. The more technology changes, the more I reach out and learn and the more learn, the more I do outreach.

The impetus for this week’s blog was Andy Leonard’s call for a T-SQL Tuesday topic.

This Post is Free!

Posted on by
Reply

Yes, seriously, other than a bit of your time, it will cost you nothing to read this post. And you might gain something from it. That can be a good value.

As I’ve mentioned in the past, one of things I do when I’m not doing SQL Server is perform training for those interested in Cave Rescue. I also sometimes blog about it. I have also mentioned that this year I’m organizing the National Cave Rescue Commission‘s national weeklong training class. In addition, since apparently I’m not enough of a masochist I’m also organizing a regional Level 1 only weeklong training class.

Due to generous contributions the NCRC is able to offer scholarships. For the regional weeklong, we are able to offer 4 scholarships of a value of up to $375 each. This covers 1/2 the cost of training. Applications were due Saturday. Now, we’re hoping for 12-20 students, so this means if everyone applied, they’d have between a 1/3-1/5 chance of getting scholarship. Can you guess how many had applied as of Saturday?

Before I answer that, I’ll note my wife used to work as a financial aid director at a local nursing school. They too sometimes offered scholarships. There was one worth I believe $500 that often went unclaimed. Yes, it required a one page essay to be judged to apply. That one page apparently was too high of a barrier for many folks and as a result sometimes it was never awarded. Quite literally a person could have written. “I would like to apply for the scholarship” as their essay and gotten it.

The same thing happened with our regional scholarships. Out of 11 students so far, none applied. This was literally free money sitting on the table. We have decided to extend the scholarship application process until April 23rd and reminded folks they could apply.

Now, some of the students probably can NOT apply, because they are employees of government agencies that sometimes have rules on what outside funds or gifts can be accepted. This actually increases the odds for the other students. And some may feel that their economic status is good enough that they don’t need to and fear they’d take a scholarship away from someone who has more of a need for it. And that’s a position I can definitely appreciate. But my advice to them, “let the scholarship committee make that decision.” If they determine someone is more needing the money, or your need is not enough, they will let you know. And if they do give you a scholarship and you feel guilty, pay it forward. Donate to the fund later on, or give the money you saved to other causes.

Besides essentially free money at the NCRC, I got thinking about the amount of free training I’ve received in the SQL Server community. Yes, I’ve paid for PASS Summit a few times, but even if I had never gone to that, the amount of knowledge I’ve gained for free over the past several years has been amazing. Between SQL Saturdays and User Group meetings, the body of knowledge I’ve been exposed to has been absolutely amazing.

And yet, I know folks who shun such activities. I’m not talking about folks who say, “I can’t make it this month because it’s my kid’s birthday”. I’m talking about folks who claim they never learn anything. I don’t understand how that’s possible given the HUGE range of topics I’ve seen at SQL Saturdays and oh so many other free events. Some folks seem to think only the paid events are worth it. And while PASS Summit had certain unique advantages, the truth is, you can listen to almost all the presenters at various free events too.

Yes, time is not free, and I recognize that. But overall, it still amazes me at the number of folks who overlook the value of free events, or easy to gain scholarships to events. Don’t turn your nose up at free. It can be valuable.

P.S. – for the parents of college bound kids out there, one thing I did in college which netted me a bit of free money. A few days after the semester began, I’d stop by the financial aid office and ask if there was any unclaimed scholarship money I was eligible for. I never netted much, but I did net a few hundred dollars over the years. For 15 minutes of my time, that’s a pretty decent ROI.

SQL Community

Posted on by
1

First, I want to thank Rie Irish for giving me cause to blog a second time this week. Normally this time would be sent writing up another article for Redgate (yes Kathi I’ve got one more in the works).

Second, I want to add, that up until now I had decided to refrain from writing about the fall of PASS. I knew eventually I probably would, but some good news last night has accelerated that process.

Last night Rie posted to Twitter an announcement about a new initiative by Microsoft to provide a space and tools for the former PASS User Groups. I was thrilled when I saw this and I’ll explain why.

In the past few days there has been a LOT of efforts put forth by various members of the #SQLFamily to create new spaces for the former members of PASS, both individually, and as groups. I’ll admit, I was both heartened by this, but also a little concerned. I was obviously heartened, because as I knew would happen, the members of #SQLFamily have stepped up and tried to fill various needs. This is a great volunteer community! I want to emphasis that. Even weeks ago when I had suggestions forwarded to me that PASS was about to close shop, I felt that the community would go on.

However, my concern was that it would fracture, that various little domains and fiefdoms would develop. Now, this may not necessarily be the worst thing that could happen. A decentralized community might actually be a good idea. For example if we separate the concept of Saturday events from User groups, that might spur innovation and might encourage new ideas to come forth. But, it might also inhibit things for folks who have organized both if they end up having to maintain two mailing lists, two sites, etc. So it’s a mixed bag. That said, if nothing else had happened, I’d take that over having the community completely falling apart.

And even if nothing else had happened, I know my User Group has speakers scheduled out through May of 2021 (and the only reason I haven’t scheduled beyond that is because I’m hoping by June to know if we can do in-person again and if so when). I know that Monica Rathbun has the Hampton Roads SQL Server User Group scheduled out through all of 2021. This is the case with a number of other User Groups. So, no matter what, User Groups would continue.

And there are still SQL Saturdays in the works, by that name or others. So, the community will continue.

But, as I said, my concern was the community might fracture into fiefdoms.

I think the announcement from Microsoft goes a LONG ways to allaying my fears. Yes, it’s just a press announcement with details to be worked out, but it has several things going for it. The biggest is the name behind it: Microsoft. Let’s be honest, the one thing the #SQLFamily has in common is we all work on the Microsoft Data Platform. So, to me, it makes sense that Microsoft be a central focus. Another is it appears this platform will end up providing a lot of the tools community leaders will need, and all in one place. These two facts should help keep the community from fracturing.

Now, I already know there is going to be one huge objection from some: “But it’s Microsoft, they can dictate what we do! We want something independent like PASS was!”

Well, first let me point out, for all its independence, PASS is no more. So independence is no guarantee of perpetual success.

Secondly, please read the release with an open mind. It’s NOT an attempt to recreate PASS. There’s no talk of a Board of Directors, there’s no talk of a main event. It’s very clear, at this stage what it is: a set of centralized resources to sustain the community. Additionally I’ve spoken further with Rie that has given me further confidence in the plan. We will see more over time how the winds blow, but I am comfortable recommending moving forward with this path. And you know what, if it turns out the Microsoft suddenly wants to take things in another direction, #SQLFamily will again do what it needs to for its members.

So, this is NOT “PASS Version II”. It doesn’t attempt to be. Perhaps PASS Version II will come to pass someday. I sort of hope it does. I look forward to another Summit. But for now, I think this is an excellent step forward. I will end by pulling a quote from the release:

Although Microsoft built SQL Server, it’s clear that the passion and dedication from each of you is what makes it thrive.

And I think this is as true today as it was 2 weeks ago.

Has PASS Passed? Does it Really Matter?

Posted on by
1

The last week or two of the Twittersphere and blogosphere has left me unsettled. Three members of the PASS Board have resigned in protest: Hamish Watson, Melody Zacharias, Mindy Curnutt. These are three people I’ve had the honor of working with and in Hamish’s case, even sharing the stage (albeit virtual) with. They’re great, hard-working, dedicted people. Rumors are that the Board is consulting with lawyers, presumably to see what is required for an orderly and legal dissolution of PASS as we know it.

Yesterday, a friend posted on my Facebook timeline that she hoped to see me again in a year when I came back out to Seattle for Summit. I had to say, it wasn’t clear there would be a Summit next year.

These things sadden me. Winter, at least here in the Northern Hemisphere is a time of literal darkness, but the situation with PASS, on top of our time of Covid and our bitter partisan divide brings darkness to other parts of my life.

But, I’m reminded of the good things too. Sitting on my kitchen butcherblock are 6 bags of cookies, plus a pile more for ourselves. Tonight is the 6th night of Hanukkah, where again my family and I will gather to light candles to remind ourselves of hope and joy among a dark time millennia ago when evil was vanquished. In a few days, Jupiter and Saturn will be in conjunction and create a single bright “star”. This will happen on the darkest, longest night of the year and then light will start to return and a new year will begin. A vaccine is out and being distributed and hope for 2021 builds.

And last night, I was reminded that PASS itself may be an organization, and I don’t know its future but an organization is made up of the people in it. It’s more than just the founding papers and bylaws and NDAs. To quote Shakespeare, “O brave new world, that has such people in it!”

What exactly do I mean? Well in more normal years, last night would have been our holiday party for the Capital Area SQL Server User Group. This means we would have gathered at a local restaurant, in person and shared stories and memories over food and drink. Months ago it became apparent that this could not happen this year. I struggled with several ideas to do instead. For one, we could have cancelled, but that just seemed too depressing. I could have found yet another remote speaker, but that just seemed boring. I can’t recall exactly where the idea came from, but I decided to do a version of “3 Truths and a Lie”. It turned out to be 4 Truths and a Lie. For those who aren’t familiar with the idea, or who do not listen to NPRs “Wait Wait, Don’t Tell Me” which has a version they call “Bluff the Listener”, the idea is some number of people (in my case 4) tell a true story, perhaps a bit outlandish. One additional person tells a lie. The others in the group then cast their votes for whose story is made-up. It can be quite fun.

I struggled a bit with who to ask to be guest speakers. I wanted folks that I knew could tell a good tale and that had probably some quite unusual stories. So I reached out and very quickly got back positive responses from everyone I asked. THIS is the #SQLFamily I’ve grown to know and love, always willing to help out and if it involves a good story, all the better. One of them, David Klee was positively giddy with excitement. And then it happened: several of the others had to drop out for personal reasons. They all reached out to me and apologized for having to drop out. I understood. Life happens and I know none of them did so without some anguish. But fear not, I had others to ask and other contacts of mine helped suggest names. Originally I was going to go with 4 total story tellers, but because time was now short, I reached out to at least one extra person to ensure if someone said no, I’d still have enough folks. Amazingly, all the folks I asked said yes. Now I had a total of 5 and that was fine, I decided to run with it. So, besides David, I ended up with Kellyn Pot’Vin-Gorman, Ed Leighton-Dick, Rick Lowe, and Amy Herold all weaving tales; of upgrades that included a Cheshire cat, the coworker who thought you had to sit and watch SQL jobs run to completion before going home, a trigger that would routinely update 63,000 rows, JBwelding USB ports in the name of security, and upgrading a server to something 31% slower for the low low cost of only $4M.

Unfortunately, the actual turnout for my group, despite the sign-ups on Meetup, was about 1/2 of what I had expected, but everyone had a great time. Surprisingly, no one guessed which of the above stories was made up (and I’m not giving it away). But we had plenty of prizes so everyone will be going away with something.

The one thing I went away with, was the confirmation that while I have no idea what the future of PASS is (ok, I have some thoughts, perhaps for another time), I do know that it’s far more than just the organization, it’s really the people, the demonyms of PASS that are the #SQLFamily I’ve come to know and love. In this season of darkness, knowing that there are such people out there fills me with hope.

So thanks to the folks named above and to all my other #SQLFamily members, and fellow CASSUG folks, including Ed Pollack and Ray Kim for your help over the past year.

One a finale note: for my birthday this year, I’ve added a link on my Facebook page to the local foodbank. I already exceeded two early goals and have added a third, stretch goal. Watching a segment on hunger and food drives on The Today Show this morning I am again reminded of how much I have and how lucky my family is. I would ask, if you can, donate, either to your local food bank, to the link on my Facebook page or to a charity of your choice.

Thank you and to all, a Merry Christmas, a Happy Hanukkah, and happy holidays for other holidays that you may celebrate.