Freedom House

A little over two weeks ago I was leaving the ED after a 12 hour shift. It had been a particularly grueling one. The drive home is often a time I’ll put on the radio for background noise and get lost in my thoughts. This drive started the same way but very quickly I started to listen more intently. I had heard the words Freedom House.

Now as some of my friends, and perhaps some of my readers know, I’ve had a keen interest in the history of paramedicine. I had watched Emergency! growing up and loved it. It wasn’t until years later I started to learn some of the history of it and how it mirrored the development of paramedicine in general. Later I learned of what’s know as “The White Paper“. This was a landmark 1967 report that among other things concluded a soldier in Vietnam who was shot was more likely to survive than someone shot in a city inside the United State.

Back then the idea of an ambulance was often the local police, or even the undertaker, simply transporting the patients to the hospital as fast as they can. (An undertaker may seem like a strange choice until you realize they had vehicles designed to onload and unload people in horizontal positions, such as tied to a stretcher.). Actual treatment until hospital arrival was often a quickly tied bandage at best. If the patient was lucky someone on the ambulance might have had a first aid course, but that was it. There were no standards and a definite lack of equipment. Beyond that, it was a matter of how fast they could get the patient to the hospital. And to say that what little quality in service did exist was very likely based on the area of the city lived in would be an understatement.

This was the state of emergency medicine on the streets in most places until an interesting confluence of events in 1967 happened in Pittsburgh Pennsylvania.

There a doctor, Dr. Peter Safar, the father of CPR, Phil Hallen, the head of The Falk Fund, which among its goals had one to create employment opportunities for African-Americans in Pittsburgh, and Jim McCoy, the head of Freedom House, a grass roots organization in the Hill District that among other things delivered food to locals, were all in the right place and the right time. Initially Hallen approached McCoy with the idea of a basic ambulance service similar to what was in existence elsewhere at the time, but this one run and controlled entirely by folks from the neighborhood. Basically an African-American run ambulance service for African-Americans. But, when they collaborated with Dr. Safar he had far bigger plans. Combined with a grant from the DOT of all places (because of their interest in reducing deaths due to highway accidents) they started with two ambulances and a 300 hour training program. Thus began Freedom House Ambulance Service, the first real modern paramedic program in the United States.

I had known they were “among the first” I didn’t realize they basically were the first. And I didn’t realize in how many ways they were first. Dr. Safar literally designed the first modern ambulances as a current EMT/Paramedic would recognize them and created the first training program. And these men (the first few trainees were all men) were the first paramedics.

The NPR radio program I was listening to was an interview with Kevin Hazzard who was talking about his book, American Sirens. I knew I had to order the book as soon as I got home. In fact, I ordered two copies, one for myself and one for a close friend who is a paramedic. I started reading it as soon as I got a copy.

The focus of the book is on several of the key players, the ones mentioned above as well as Paramedic John Moon who started in the program after a few years and survived the end of the program and Dr. Nancy Caroline, who literally wrote the textbook on paramedic training: Emergency Care in the Streets.

American Sirens is well written and easily accessible by anyone. You don’t need a medical background to appreciate it. It also answered a question I had had about Freedom House since I had heard about it; namely what happened to it?

I’d love to say it was still around and thriving and that it had a strong name recognition among modern paramedics and EMTs. Sadly that’s not the case. From its start it faced opposition from the local police and politicians. In 1975 it was facing a complete shutdown due to underfunding when Dr. Safar convinced the mayor to fund it one more year and brought in Dr. Caroline. But the writing was on the wall. Within the year, it was replaced by a city-run, city-wide ambulance service staffed almost exclusively by white paramedics, all who had far less experience than the Freedom House Ambulance Service paramedics and who had taken classes developed by Drs. Safar and Caroline. Dr. Caroline was initially brought over as Medical Director with the understanding that all Freedom House paramedics would be brought over and given jobs. And initially they were, but very quickly racism raised its ugly head and they literally were often left holding the bags while their much less experienced team members took over.

Meanwhile, in Los Angeles, in 1972, Jack Webb (also of Adam-12 and Dragnet history) had created the show Emergency! which was a fairly fictionalized, but also fairly accurate, portrayal of the development of the EMS/paramedic program in Los Angeles. One can’t underestimate the impact this show had on popularizing EMS in America. I know a number of folks who got into paramedicine because they watched this show. It deservedly has a place in the history of EMS in the US. However it’s just one part of the history. Sadly a key part literally has been white-washed. As of the late 90s, 98% of the paramedics in Pittsburgh were white.

I wrote a few days ago that I wanted to read more this year. Well this book is the first.

For anyone interested in a more complete understanding of the history of paramedicine in the United States, including the racism if faced, I highly recommend this book.

Fair and Equal Medical Treatment

Today is International Women’s Day. I was reminded of this from a semi-unrelated post by a fellow #SQLFamily member, but this post is an intersection of a variety of Facebook posts and discussions I’ve had over the past week that touched upon women’s health. In the interests of privacy and protection I am going to anonymize a bit what happened. I’ve mentioned in past posts how we as DBAs have to take into consideration topics such as gender and more. We’re here to describe the world, not to prescribe it. But, if my hoped for career change to become a Physician’s Assistant passes, topics of women’s health will become even more important for me to take into account.

Let me start with the first discussion I had: menopause and Nuvaring. A friend mentioned she’s going through menopause and her physician had suggested the Nuvarin as a form of hormone replacement to help reduce the effects such as hot-flashes. She looked into what her insurance covered and found out that it would cost I believe $360 for 3 months of coverage. But, Viagra was free. That’s health insurance in America. Want to get an erection, if you have good health insurance, it’s free. Want to avoid feeling like you need to rip off your clothes in public because you’ve gone from cold to sweating hot in seconds, sorry that’ll cost you $120/month! Perhaps it’s time to rethink how we allocate some of our funds.

The other discussion that came up was someone that I know more vaguely, but who is a trans-woman. She mentioned how doctors have turned her away. Pharmacies have refused to fulfill prescriptions for her that they routinely fill for cis-women. In general, because in their minds her physical presentation doesn’t match their expectations, they treat her as an outcast. Let me be simple and blunt: I’m offended and angry. She deserves access to the same treatment as any of the cis-women around her (and as the above discussion suggests, women in general deserve better treatment).

Writing this, I realized, I lied a bit, unintentionally. The above paragraph was prompted by a particular post, but I know several women to whom it could apply. So no need to try to guess who she is among my friends. She could be and is in fact a compilation of several.

Before I close, I want to recommend a Youtube channel I spend some time on: Dr. Momma Jones. While I don’t think my specialty will involve Ob/Gyn (I’m more interested in emergency medicine), I love watching her posts because I learn a lot, both medically and about gender bias and topics that I’m generally less familiar with.

That said, in closing, if I become a PA, I will work at treating all my patients equally and equitably and to the best of my abilities, regardless of their identity. Even if I don’t become a PA, I will continue to work to fight for the rights of all and to treat all equally and equitably .

So on International Women’s Day, let’s celebrate and remember all women.

P.S. and in the meantime, let’s fight against the rules put in place in Texas regarding medical treatment and discussion around trans-children and against the “Don’t Say Gay” law being voted on in Florida. I will say right now: children will die because of these rules. They will commit suicide.

Impact and Legacy

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.

#YesAllMen

For over two years I’ve been wanting to put together a speaking topic using the above as a title or as a subtitle. The reason is because the alternative, #NotAllMen is NOT a good thing to use.

Yesterday I came across an article that said it better than I could. I would recommend you read it first: Buzzfeed Article.

It brings up several great points, including ones I had not given much thought to. Look, I know when a friend of yours is upset that a guy just made a pass at her in a professional setting, one of your first instincts is to think “I’d never do that” and are tempted to say “#notallmen” you’re not being helpful. In fact, you’ve just made it about yourself. Just don’t. That’s not what is needed.

Look, I’m pretty confident that all my male readers are pretty decent guys. I work with many of you professionally, some of you in volunteer positions, some are simply friends, and some readers, I suspect I don’t know, but you’re probably ok too. None of you are outright sexist or racist. If you were, I wouldn’t be associating with you. But all of us are still a product of our environments. We make the off-handed comment without thinking about it. Or someone around us makes a comment and we don’t react. This is also why I suggest when it comes to calling yourself an ally, just don’t.

Several years ago I helped organize and then participated in a Women in Tech panel for our local SQL Server User Group. I was the only man on the panel and expected to be asked what was the best thing I thought we, as men could do. The answer was of course somewhat ironic: “Sit down and shut up.” I of course expanded upon this. No, we can’t nor should we ever completely shut up. That wasn’t my point of course. My point was to make sure not to center the discussion about us. When a friend complains about a sexist incident, replying #NotAllMen is doing just that. Centering the discussion on us. Sorry, that’s a time to shut up and listen.

But when others make sexist comments, that’s a time when it may be appropriate to say something. And if someone calls you out, take it in stride. We make mistakes. And if someone takes you aside and says something (I’ve now heard that called a “call-in”) thank them. It means they think well enough of you to help you be a better person.

At the end of the day guys, we’re all still part of the problem, even when we do our best. That doesn’t make us evil. It simply means we have space to grow into. Let’s do that. Let’s grow.

The Value of Paper vs Convenience of Digital

About 35 years ago in the fall, a housemate of mine got a phone call, “hey, I’m a caver who’s passing through your area this weekend and found your name in the NSS Members’ Manual, I was hoping maybe you could hook me up with a caving trip.” Well it just so turns out that the RPI Outing Club traditionally does Friday night caving. (Why night you might ask? Well it’s always dark in the caves, so going at night leaves time on Saturday and Sunday to hike, rock-climbing, canoe, etc.) My housemate invited the guy along and he joined us caving (I think in Knox Cave).

I mention this story because it’s an example of how the NSS Members’ Manual has often been used over the years. Talk to enough old-time caves (especially those who recognize the smell of carbide in the morning) and many will mention how they’ve been in a strange area and looked up a fellow caver. Usually the lookup was to find someone to go caving with, but it might also be help with a broken vehicle, looking for crash space for a night or even more esoteric reasons. Many cavers kept a copy in their vehicles so they’d always have it with them.

Well, this past weekend (March 13th to be precise) the Board of Governors of the NSS voted to stop publishing the Members’ Manual. There was a lot of debate on the topic during the meeting and later online on Facebook (and I assume other spaces) and I wanted to discuss a bit of it here.

There were several rationales for this decision and I don’t think any specific one can be pointed at and said, “this is the reason.”

Conservation was certainly mentioned. The NSS is after all a group who has a primary charge of conservation and while this primarily pertains to underground resources, I think arguably not wasting trees falls into this purview. I’ll leave the debate about the size of the actual impact to others.

Convenience was another one mentioned. Many argued the online members manual which allows for searching to be more convenient than flipping through pages. I’d agree there’s some merit to this argument, but as others countered, that doesn’t mean much if you’re outside cell range and that many caves just happen to be outside cell range. A printed manual is always available, never runs out of batteries and never goes offline. I think there’s merit to both sides of the argument and a lot depends on one’s use case.

But there was an argument I had not given much thought to before and as it continued I started to notice that it was perhaps more demographically split than the others. This argument was about data privacy.

While the argument about the convenience of a printed manual did tend to skew towards the older cavers, that wasn’t strictly true. Even many of the older cavers admitted they hadn’t opened the printed manual in years and preferred to use the online manual.

But the argument about data privacy definitely appeared (in a very non-scientific look) to have two skews: younger and by gender.

At least one, and I believe two of the younger folks advocating for dropping the printed manual expressed shock when they first received their copy of the Members’ Manual and found what they considered personal information, including their home address printed therein. And pretty much all the objections to such easily available information came from women. This gave me cause to think. There’s been a lot of discussion among some NSS members about Diversity, Equity, and Inclusion. Many (and it’s almost always older white men by the way) will argue, “oh anyone is welcome caving!” And while that’s true, I will argue many are ignorant of some of the barriers that might exist. I’ll admit, I had always looked at the Manual as a great way to get in touch with a fellow caver. I mean after all, why not? I’m a good, decent guy. Pretty much most of the cavers I know are. Why would it be a big deal if some random caver wanted to get in touch with me? This discussion about privacy has made me rethink that. My assumptions do not necessarily hold true for those who don’t look like me.

Now, two notes: First, I’m fairly positive, but I can’t be sure and will admit I haven’t looked closely, one has always been able to opt-out of what info went into the printed Manual. I could be wrong. Second, the online method I know positively has that option. And here’s one area where the online manual is superior. It can be constantly updated. This means not only is address info potentially more current, but a member can at any point go in and add, or more importantly, REMOVE their personal information if they so wish. Once the printed Manual goes out, such information is there forever. This presents a risk some members don’t want to have.

Now, I’m going to make a slightly contradictory argument before I come to my final words. As a data professional, on one hand I’m a fan of “make all things digital!” There are definitely benefits, many of which are outlined above. The ability to dynamically update information and access it in many different ways is arguably a huge plus.

BUT, I’m also well aware that while we say, “once it’s on the Internet, it’s there forever” the reality is far more complex and nuanced. Anyone seen their Geocities pages lately? And while it’s not true that NASA has lost the Saturn V plans, the reality is, there are computer tapes, especially from the earlier planetary missions that are either hard or even impossible to read. This is partly due to the fact that the magnetic media has decayed but also due to the fact that the hardware has disappeared. This happens in our own lives. How many of my readers have games or other items on floppy disk and no way to read it with a computer in their house?

I mention this because among other things, the NSS is a research organization. This means it’s quite possible that 10, 20 or 50 years from now, someone may come along and want to do research on the membership of the organization. They might want to explore where cavers are from, the type of members, how long folks were members, or for other goals we can’t imagine at this time. While inconvenient to do such research from printed form, I can guarantee that the printed manuals will be readable 50 years from now. And each one will be an annual snapshot. I’m not so sure that the current membership database will be readable 50 years from now (how many folks for example can read a dBase III database?) and I’m even less convinced that annual snapshots will be easily available (that said I’m not privy to how the membership is stored and if it’s always dynamic or if there’s annual snapshots or what).

So in my final words I’d say “there’s no perfect answers” here. I think the arguments for and against a printed manual have merit and both sides need consideration. My preference is a compromise:

  1. Charge members who want the printed Manual an upcharge to help cover costs. Make this opt-IN (i.e you don’t automatically get a manual unless you ask)
  2. In addition, a certain number of Manuals should be archived at research libraries around the country. While all this data is stored at the headquarters, disasters such as fires, water leaks, etc can happen. I think the NSS needs to ensure that data, such as a history of its membership needs to be preserved.
  3. When members join or renew, other than their name and membership number, make all PII data opt-IN for printing and for on-line. Nothing will show in either place unless they specifically allow it. This is the modern world and all members should have the right and ability to control what information of theirs is made public. This is among other things a DEI issue.
  4. Drop any form of on-line PDF (I can’t find one, but several people mentioned they had found one). Ironically this is perhaps the biggest risk in my mind of breach of privacy data; PDFs are easily scraped for data. In addition, do NOT allow a “global” search of the on-line Members’ Manual where all members can be looked up at once. Both this and if there’s an inline PDF make scraping far too easy.
  5. Take into account current data privacy laws (such as in the EU and California) that have a direct impact on the retention of online data.

Basically I’d prefer, if not the best of both worlds, the best we can get: the convenience and permanency of a printed manual as well as the convenience and dynamism of an online manual. Both I feel have their place. But as far as either goes, I think the growing awareness of data privacy practices and the fact that the NSS needs to be aware that for some, this IS a DEI issue, means that the status quo has to change. I’ve said before, “the times they are a changing” and this is an example of that.

Another Case for Diversity

I’ve spoken in the past about why I think diversity is important. For example, understanding genders helps us design better databases and interfaces. But this past weekend another argument for diversity was presented to me. I was reminded that experiences many of us take for granted are often experienced differently by other people.

I’ve spoken in the past that I’m a caver and I teach cave rescue. As a caver I’m a member of the National Speleological Society. This is a great group and it’s dedicated to cavers and those who have a personal or professional interest in caves. It recently added a section for diversity. Some of the discussion behind this occurred on Facebook and it was quite telling in the reaction.

Let me start with saying that cavers are some of the friendliest people I know. It’s far from unheard of for a caver to look in the NSS Members Manual or online and say “Hey, you don’t know me, but I’m passing through your area, can you hook me up with a local cave to visit and maybe some crash space” and it happens. So yes, cavers are quite open and hospitable.

That said the Facebook discussion was an example of many of my fellow cavers missing the mark. The one that stood out in my mind was “Of course people of color can come caving with us. They just need to ask. We never turn anyone away.” And that’s most likely true. But, there are problems there, including people of color knowing they can ask and who to ask and where.

One response I found particularly telling, was a person of color pointing out that in parts of the South, simply walking across a field to a cave was potentially unsafe to them. This was a concept the white cavers couldn’t wrap their mind around and even actively told the person his experience was wrong.

So in this area I do think it’s important for us to reach out to members of groups who might not traditionally cave and invite them to join us.

But, as I said, another reason was presented to me on the past Thursday night. The NSS Education and Diversity Committees had joined together to present a webinar by Beau D. Carroll on Cherokee Syllabary in caves in the Alabama area (the main focus was on Manitou Cave).

Now, I go caving because I think it’s cool, both literally and figuratively. Seeing how the rock changes as you move to different parts of the cave, or seeing formations, and all that is just really interesting. My experiences are shaped by that. I also enjoy taking beginners of all ages caving and seeing their reactions and their often growing enthusiasm. I can quite safely say I’ve literally taken 100s of people on their first caving trip and am proud to know that several have gone on to become great cavers, far outpacing my own experiences.

That’s my experience.

Beau talked a lot about the experiences he, as a member of the Eastern band of Cherokees experienced while exploring in Manitou Cave and other caves. For him, it was both a learning experience (he is working on a PhD in archeology) as he found and translated the Cherokee Syllabary writings in the cave and as a way to connect to his ancestors. To me, this was particularly fascinating for two reasons. The first is the history of the syllabary itself is fascinating. It was developed over a 12 year period by Sequoyah and within 5 years, it’s estimated over 90% of the tribe could read. It’s one of the few writing systems that was developed within recent memory and for which we have somewhat decent records of its development. The second reason is that the writing very much is recording the history of a people whose entire way of live was disrupted by the Trail of Tears. He’s unlocking history and we’re learning from it.

It’s also a very different way of experiencing the dark zone of a cave. It’s not just a matter of “oh this is cool” but “this is someone’s history and culture.” One example stands out to me.

At one point during the Q&A Beau talks about leaving offerings of tobacco for his ancestors inside a cave. I have to admit, initially this offended my sensibilities, especially in light of the NSS motto.

Take Nothing but Pictures, Leave Nothing but Footprints, Kill Nothing but Time

But it forced me to stop and think about my own prejudices. While it’s clear from other comments Beau makes that he and his Cherokee agree on much of the concept of cave preservation, am I right to be offended? Is my concept of “leave nothing but footprints” truly correct? For me, caving is not a spiritual experience, but for him it is. His experience is arguably as valid as mine and I think should be respected also.

In the end it made me realize that a strong reason for a diversity committee isn’t just to “bring others into the caving” but for us to realize how others experience caving. This is equally and perhaps in some ways more important. I don’t think we can truly understand caving until we understand how others experience it also.

I want to thank Bree Jameson for bringing the webinar to my attention and Devra Heyer, NSS Education Committee Chair and Leah Hill, NSS Outreach Chair and Ambassador for the Diversity Committee for putting this all together. It’s a great presentation.

Please, take an hour out of your day and listen and watch. It’s worth it!

Also, please not my latest Redgate Simple-Talk article is now online: PowerShell editors and environments part 1 is now online.