Take 5 Minutes

This weekend I had the pleasure of moderating Brandon Leach‘s session at Data Saturday Southwest. The topic was “A DBA’s Guide to the Proper Handling of Corruption”. There were some great takeaways and if you get a chance, I recommend you catch it the next time he presents it.

But there was one thing that stood out that he mentioned that I wanted to write about: taking 5 minutes in an emergency. The idea is that sometimes the best thing you can do in an emergency is take 5 minutes. Doing this can save a lot of time and effort down the road.

Now, obviously, there are times when you can’t take 5 minutes. If you’re in an airplane and you lose both engines on takeoff while departing La Guardia, you don’t have 5 minutes. If your office is on fire, I would not suggest taking 5 minutes before deciding to leave the building. But other than the immediate life-threatening emergencies, I’m a huge fan of taking 5 minutes. Or as I’ve put it, “make yourself a cup of tea.” (note I don’t drink tea!) Or have a cookie!

Years ago, when the web was young (and I was younger) I wrote sort of a first-aid quiz web-page. Nothing fancy or formal, just a bunch of questions with hyperlinks to the bottom. It was self-graded. I don’t recall the exact wording of one of the questions but it was something along the lines of “You’re hiking and someone stumbles and breaks their leg, how long should you wait before you run off to get help.” The answer was basically “after you make some tea.”

This came about after hearing a talk from Dr. Frank Hubbell, the founder of SOLO talk about an incident in the White Mountains of New Hampshire where the leader of a Boy Scout troop passed out during breakfast. Immediately two scouts started to run down the trail to get help. While doing so, one slipped and fell off a bridge and broke his leg. Turns out the leader simply had passed out from low blood sugar and once he woke up and had some breakfast was fine. The pour scout with the broken leg though wasn’t quite so fine. If they had waited 5 minutes, the outcome would have been different.

The above is an example of what some call “Go Fever”. Our adrenaline starts pumping and we feel like we have to do something. Sitting still can feel very unnatural. This can happen even when we know rationally it’s NOT an emergency. Years ago during a mock cave rescue training exercise, a student was so pumped up that he started to back up and ran his car into another student’s motorcycle. There was zero reason to rush, and yet he had let go fever hit him.

Taking the extra 5 minutes has a number of benefits. It gives you the opportunity to catch your breath and organize the thoughts in your head. It gives you time to collect more data. It also sometimes gives the situation itself time to resolve.

But, and Brandon touched upon this a bit, and I’ve talked about it in my own talk “Who’s Flying the Plane”, often for this, you need strong support from management. Management obviously wants problems fixed, as quickly as possible. This often means management puts pressure on us IT folks to jump into action. This can lead to bad outcomes. I once had a manager who told my team (without me realizing it at the time) to reboot a SQL Server because it was acting very slowly. This was while I was in the middle of remotely trying to diagnosis it. Not only did this not solve the problem, it made things worse because a rebooting server is exactly 100% not responsive, but even when it comes up, it has to load a lot of pages into cache and will have a slow response after reboot. And in this case, as I was pretty sure would happen, the reboot didn’t solve the problem (we were hitting a flaw in our code that was resulting in huge table scans). While non-fatal, taking an extra 5 minutes would have eliminated that outage and gotten us that much closer to solving the problem.

Brandon also gave a great example of a corrupted index and how easy it can be to solve. If your boss is pressuring you for a solution NOW and you don’t have the opportunity to take those 5 minutes, you might make a poor decision that leads to a larger issue.

My take away for today is three fold:

  1. Be prepared to take 5 minutes in an emergency
  2. Take 5 minutes today, to talk to your manager about taking 5 minutes in an emergency. Let them know NOW that you plan on taking those 5 minutes to calm down, regroup, maybe discuss with others what’s going on and THEN you will respond. This isn’t you being a slacker or ignoring the impact on the business, but you being proactive to ensure you don’t make a hasty decision that has a larger impact. It’s far easier to have this conversation today, than in the middle of a crisis.
  3. If you’re a manager, tell your reports, that you expect them to take 5 minutes in an emergency.

Changing Technologies – T-SQL Tuesday

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!

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.

Reasons I Attend WIT Events

Last Friday, I took time out of my day to attend the Data Platform WIT Day. Hosted on Redgate’s Zoom, it was a series of webinars that started with Rie Merritt’s excellent Keynote Lifting as we Climb and concluded with Stepping Stones from Diversity Learning to Equitable Actions with Cindy Gross. The full list of sessions is available at YouTube here.

I highly recommend you take some time out and check out the sessions that may appeal to you. The keynote is 30 minutes and the follow-on sessions are roughly an hour each. Because of other events on my schedule I wasn’t able to attend all of them, for example I could only jump into Cindy’s about half-way through, but very much enjoyed what I watched and learned quite a bit.

Afterwards, one of the organizers, Mala Mahadevan tweeted the following:

https://twitter.com/sqlmal/status/1367951596227854340

I was caught a bit off-guard by the call-out, but not in an unpleasant way. I’m proud to support WIT. And it prompted me to write this post on my usual Tuesday, just a day after International Women’s Day.

I attended for two reasons: one was for learning and the second was honestly to be supportive.

The first reason should be obvious. There’s some good information in these webinars. Tracy Boggiano gave a great presentation on dbatools and dbachecks, tools that I definitely need to learn more about. The panel on mentoring with Leslie Andrews, Shabnam Watson, Deborah Melkin, Gilda Alvarez, and Deepthi Goguri was a great learning experience for me. I gained further insight into how mentoring can work, especially for those who have a different experience than mine. And while the panel focused more on the experience and value of mentoring for women, I gained several great takeaways. So it wasn’t just a “women for women” type event.

But quite honestly, I attended in part for the same reason I’ve often started using my pronouns in various places (him/his for those who aren’t aware): to normalize the practice. I think it’s important for those who don’t identify as women, and especially for those who identify as men to attend such events. While the focus of a WIT event is for women, it does not mean men can’t learn from it. It doesn’t mean we’re not welcome. I had heard much of Rie’s talk before, since she adopted it from other talks she’s given. It’s primary focus is of course on how women can help women grow in their professional careers. But there are tips that men can learn, such as not interrupting the women they work with, amplifying their voices, and more. I tell the story that the first time I heard Rie speak, I was one of two men in the room, and the other was a friend she had apparently asked to attend in order to give her feedback. I was a bit saddened there were not more men there, as we need to learn a lot of what she has spoken about. I suspect some men felt “oh I don’t need to go” or “there’s nothing there for me.” But they’re wrong and I want to continue to normalize attending such event for those who present as men. And I attended of course because I want my women colleagues to know they have support, that I value their contributions and experiences.

Now that said, I will add that events such as last Friday’s are “Women in Technology” events. The focus is in the name. While welcome, men should avoid any attempts, conscious or subconscious to center them on their own experiences. What do I mean? For one, during the Q&A parts, if you feel tempted to say “I have more of a comment than a question…” just stop. Nope. It’s a Q&A period, not “I want to hijack the discussion and talk about myself period.” This is not to say questions aren’t welcome. But make sure they’re actually relevant to the topic at hand, e.g. “Tracy, I think I missed something, am I correct in understanding that the latest version of dbachecks has a problem with the latest version of Pester?”

So my advice, do your best to be an ally by your actions, not your claims.

And that said, for those who are inevitably going to ask: When it International Men’s Day?

What’s for Dinner?

“Food!” is my usual answer. Yes it’s my dad joke answer. I can’t help it.

The truth is, I generally don’t have a well planned menu in advance and sometimes what I plan on making for dinner will change after I step in the supermarket and something catches my eye. Sometimes I won’t even have an idea until I go into the supermarket. That said, I still have sort of a routine, one my family is familiar with and perhaps at times tired of. (That said, they still eat what I make, so I guess they’re not that tired of it).

  • Monday – Usually a chicken dish. Last night was Pad Thai (but I’ll let you in on a secret, the noodles were woefully underdone. I was afraid they’d turn to mush and took them out too early!)
  • Tuesday – Usually something centered around ground beef/turkey, tacos, sloppy joes or shaved steak for Philly Cheese steaks. I’m not sure about tonight’s dinner, but since I did tacos last week, I can guarantee it won’t be Taco Tuesday tonight. I don’t like repeats. 🙂
  • Wednesday – Up in the air. Sometimes a grilled sausage, onion and pepper on a bun.
  • Thursday – Often store bought ravioli or tortellini. They’re simple and quick.
  • Friday – I get more creative, often some crab cakes, maybe scallops, or something good.
  • Saturday – At least once a month, pizza with homemade crust (and occasionally homemade mozzarella).
  • Sunday – Take out. Previously 90%+ of the time it was Lee Lin, a Chinese food place I’ve been ordering from for decades (literally since college) but now we vary it up with other take out places.

So yeah If you happen to show up at my house (post-pandemic please) you’ve got an idea of what you’ll end up with depending on what night you show up. Maybe. I might change my mind.

I really enjoy cooking. I love the idea of creation and the idea of nourishing body and soul. I like the fact that food can bring joy to people.

During the time of Covid, there have been times when cooking has been a real drudgery, but other times I’ve really enjoyed it or had the chance to try new things. For example, like many Americans I’ve dabbled with making Sourdough.

Image is of  full loaf (on the left) and a half loaf of homemade sourdough bread.
Fresh Sourdough, an early attempt.
A roast beef sandwich with lettuce and tomato and mayo on a plate. In the background is a keyboard.
Roast Beef Sandwich with homemade sourdough bread!

Of course I mentioned pizzas?

An image of two pizzas from above, resting on a butcher block.
The one on the left is a pepperoni pizza. The one on the right is a white pizza with sundried tomatoes. 
Both have fresh basil from my garden on them.
Two sourdough pizzas with home grown herbs.
Image of two pizzas looking from above. On top of a butcher block.
Top one has fried onions, Granny Smith apple, bacon, sundried tomatoes.

Bottom one is white pizza with home made pesto.
Two more: the top is bacon, sundried tomato, Granny Smith Apple, fried onions! The bottom a white pizza with homemade pesto and some sundried tomatoes
“Breakfast Pizza” with cheddar cheese, bacon, black pepper and a pair of eggs cracked on top near the end.

For Thanksgiving I tried something new:

An experiment for Thanksgiving dessert - apple sharlotka. It was a success!
An experiment for Thanksgiving dessert – apple sharlotka. It was a success!

And of course one has to have sweets!

Gingersnap cookies
LOTS of sugar and carbs!
Bags of Christmas Cheer
A smattering of gingerbread men!
A smattering of gingerbread men!

But of course, the question is “what’s for dinner?

My French-Canadian grandmother’s recipe for baked kibbeh taught to her by her Lebanese mother-in-law. BTW, this is 1/2 the amount she’d normally make for family gatherings! This is over 3 lbs of meat plus bulgur wheat and onions! It’s a LOT of food and oh so delicious.
I actually bought my air fryer BEFORE the pandemic, but love it and use it a lot and find it makes great wings. (And the cinnamon cap has nothing to do with the wings.)
Air fried General Tso’s Chicken, finished in the pan. Thanks to #SQLFamily fellow DBA Rie Shewbart Merritt for the recipe!
Technically “Cottage Pie” because it’s made with beef instead of lamb, but still delicious, and one of Randi’s favorites!
A Friday dinner with steak and potato (and yes, I’m a heathen who likes a bit of ketchup with my steak, but that sauce is delicious too!)
Perogies that close family friend Christine Dzakowic Walsh had made, but fresh herbs from my garden.
Another Friday dinner. That’s my burger on the right, with the works, grilled onions, bacon, bleu cheese, lettuce, tomato, garlic-parm fries!
Can I interesting you in mini-beef wraps with mashed potatoes with a wine-sauce reduction? I think I got this one from close friend Sarah Lawrence.
Chorizo street tacos anyone?
Homemade Falafel and homemade hummus with a peanut sauce and veggies and homemade pita. I need to make this again soon I think.
Of course latkes are a must in this house come Hanukkah! (toss in some curry powder, trust me on that one!)
Homemade pasta with homemade pesto and Presto… delicious dinner!
My most recent experiment, homemade dumplings! Delicious but need some work!
Some homemade chili with yes.. sourdough bread!
Coquille St Jacques – delicious! My mom introduced me to this dish when I was about 10.

And besides dinner, there’s breakfast

French toast with lots of cinnamon!
Sourdough waffles with a variety of toppings (including homemade whipped cream!)
Sourdough pancakes!
Yes, I put ketchup on my eggs. Deal with it. And yes, that’s my initial. It’s my egg. I can do that!
My latest attempt at homemade bagels. I think I nailed it this time. More in the future!

Snacking is important too!

Homemade Pita (roll it very thing and place in a very hot oven!) with homemade Hummus!

Now, that’s not to say it’s all fun and games. Sometimes one does have to collect data on how to make things better. Recently I had been reading up on chocolate chip cookies (research of course) and learned that the original recipe called for letting the dough sit for 36 hours before baking. Now, I’m never one to take a detail like that at face value, so I had to of course experiment. I also decided to test the baking time for my white whole wheat chocolate chip cookies to see if 10 or 11 minutes was better.

Baked right after mixing
Baked after being chilled 24 hours
After being chilled 38 hours (I slept in that morning).

So, I think more research is necessary, but I would say that chilling does appear to help the flavor and I think initially 11 minute baking is better, but the next day, it’s hard to tell if it or the 10 minutes is better.

I probably have a dozen or so more pictures of various meals, but I think I’ll stop here. I’m getting hungry and it’s not even lunch time yet!

Seriously though, besides the biking and caving and other things to keep me busy, I’ve enjoyed cooking (most of the time) in the last year. I hope you enjoyed my trip through my kitchen in the last year. I’d love to see what you’ve been making or baking!

Food Experiments

There’s an old joke: “what’s the difference between a chef and a cook?”

“A cook cleans up kitchen when they’re done.” If that’s the definition, then I am definitely a cook, not a chef.

That’s ok, because I really do love to cook. There’s something creative and powerful about taking a bunch of ingredients and turning it into a meal that’s ideally nourishing and enjoyable. That said, sometimes I end up with meals that are more nourishing than they are enjoyable.

A recent Facebook exchange with a pair of #SQLFamily members and others reminded me of that. About once a month I will make homemade pizza. I’m a big fan of this since I can experiment with toppings. I generally use King Arthur Flour recipe (though somehow I was able to print mine by mass of ingredients, not volume) or, as in this past weekend the Sourdough version. For me, the way I knead it and let it rise, I’ll end up with a fairly fluffy crust, so if you want a thin crust, you’ll have to try something else.

Now, generally I end up making 2 pizzas (unless I’m in non-covid times baking for a larger group in which case I’ll double the recipe). Almost always one of those is a typical pepperoni pizza. If I’m feeling healthy, I’ll use the turkey pepperoni, but more often lately I’ve been using real pepperoni I’ll slice myself. I almost always use store bought mozzarella, but if I have the time and the motivation, I’ll make my own.

Two sourdough pizzas with home grown herbs.

The second pizza can vary. Above is a white pizza I made this summer with some basil from the garden.

But, why stop there? My personal favorite is a “Thai chicken” pizza with Thai seasoned chicken, peanut sauce, snow peas, and red onions.

Or one with bacon, sautéed onions, sliced Granny Smith Apple, and some sun-dried tomatoes. That has a nice mix of flavors. I think it’s my wife’s favorite and the favorite of a friend of mine.

Or cheddar cheese with bacon, black pepper and towards the end 1-2 eggs cracked over the top. I call this my breakfast pizza.

Or a BBQ pizza.

Or… well you get the idea. I like to get creative.

Some homemade pizza with a bit of sourdough mixed in.

But this weekend I wasn’t feeling particularly creative and decided to try something different. I had heard about folks who have air-fried pizzas, so I decided to take a crack at it. I took the 2nd half of the dough and divided it into 4ths and told each member of the family it was up to them to create their own pizza. I par-cooked the crusts a bit first in the air-fryer before they topped them. I also setup a “toppings bar” for them to pick from (nothing super creative this time though).

Now, let me stop by saying, no experiment is truly a failure. As a friend of mine who worked on the InSight Lander made a point of saying, even the fact that drill head got stuck and did not complete it’s original goal, we learned something about the soil of Mars.

While these were far from my best pizzas, I learned something about making them in the air-fryer. They came out a bit dryer than I might prefer, but I wasn’t really surprised, I did kind of expect that.

I still far prefer a really hot oven and pizza stone (huge hint: give the stone a good 30 minutes or more to come up to temp, otherwise it will actually end up insulating the bottom of your pizza and it won’t cook well). But, I’ll probably try again, perhaps with a moister dough and drizzling the edges with garlic butter or olive oil (hey, any excuse to use those, right?)

I’ve also bought some King Arthur 00 Pizza Flour and will start to experiment with that. My first attempt I made some mistakes, but I’m looking forward to another attempt, especially this summer when I can use fresh basil and tomatoes.

In the meantime, I’ll keep experimenting with the air-fryer.

Now, I will say, air-frying wings DOES work well and is my preferred method now. Still moist and very tasty, but far fewer calories and in theory a bit healthier.

I’ve determined getting decent steak fries isn’t worth it (too thick and bulky to get the inside cooked without overcooking the outside), but I’m honing in on getting pretty decent shoestring fries out of it.

And putting a final crisp on our veggie burritos is often quite pleasing.

In any event, before I get too hungry I’m going to stop now. But I’ll encourage everyone to experiment in the kitchen. It can be fun and who knows, you may even enjoy it!

2020 in Review

Yes, I’m joining the chorus of so many others who are publishing a lookback on the previous year. This has become a tradition for me. And I of course followed last year’s review with a preview for 2020. I made the obligatory dad joke then and I’ll make one now, that I can’t wait until 20/20 is truly hindsight!

2020 I think upset everyone’s goals, and mine were no different. But I figured I’d start with my goals from last year and then try to end on an actual up-note.

  • I had a goal of blogging at least once a week. I think I missed 1 this year, but a few weeks I blogged more than once, so, including this post, I will have 56 posts this year. Not to shabby. And my overall page count is up. So that’s good.
  • I vowed to write more for Red-Gate and I did. But not as much as I’d like. I do blame this partly on Covid. I lost some of my enthusiasm. But I am working on another article. I was hoping to have it done this week, but lost motivation. I did learn one of my articles there is one of their top read articles. I’m quite proud of that!
  • I did read more this past year, that’s for sure.
  • One goal I had was to keep speaking at more SQL Saturdays. Well, that didn’t quite go as planned. I did speak at the Albany event, but that was about it. This one I 100% blame on Covid. On the other hand, I finally attended the Portland Oregon SQL Saturday, albeit virtually.
  • Speak at SQL Summit: well I did achieve this one, sort of. It was virtual, but I was selected and that was a HUGE highlight. And in fact I ended up being part of two presentations, the 2nd a live one that I ended up doing from my car while waiting for something else. And my presentation on PowerShell for Beginners apparently was very popular. So, I can at least say I went out on a high note.
  • On one hand, we postponed our NCRC Weeklong Cave Rescue Seminar here in NY to 2021. On the other hand, I was able to work out a Modular Level 1 Seminar here in September, the first of its kind in my region ever. And we did it safely and effectively.
  • Started to use git on a far more regular basis, including from the command line (previously I had limited myself to the GUI in Visual Studio).
  • I did read more! – including:
    • The Power Broker, I biography of Robert Moses
    • Station Eleven, though in retrospect, reading a book about the world after a global pandemic was NOT a great way to start the year!

So, overall, I did accomplish a number of my goal. I had some generic ones that included caving more, biking more, and hiking more. More on those in a moment.

Overall, the year was a bummer in many ways. I really missed travelling. I really missed seeing friends and family (I think we saw my mom in person twice during the entire year). I missed my seeing my #SQLFamily in person. I missed my NCRC Family. I missed having our normal annual pool party.

I missed, normalcy.

But…

You know what, for me personally, 2020 was actually a year of some ups. I’ve been very fortunate and I was able to do things I had not done as much as in the past.

  • For one I accomplished my first overnight hike in perhaps over a decade, a nice 18 miles on the Appalachian Trail. Due to scheduling I couldn’t quite get in a 2nd hike that would have completed a gap in Massachusetts, but perhaps next year. I did find I needed some new equipment, which I purchased in anticipation for next year.
  • As for biking, I definitely did a LOT more this year. I biked over 1300 miles this year (I can’t recall the last time, if ever, I did as much) including my first century ride (100 miles in one day) since my senior year of high school. I’m really proud of that one. Who knows, maybe I’ll do another in 2021.
  • Despite a contentious election season, America voted the Orange One out.
  • Spent more time with my family! We did several walks around the area including some paths we had not explored in the 20+ years my wife and I have lived in the house.
  • I fixed the dryer that had been making a horrible rumbling sound for years.
  • I made a bunch of sourdough bread, pancakes, waffles and even a pizza crust or two. And I’m back to making sourdough again.
  • I finished binge-watching Haven, a quirky fun show based on a Stephen King story.
  • I rewatched (and for my family, they watched for the first time) the entire Prisoner series. Yes, everyone still wonders what the hell the final episode is still about.
  • We’re binge-watching Schitt$ Creek and wondering why we didn’t watch it sooner.

All in all, it was a very mixed year. It wasn’t a normal year in many ways and some of the normalcy, I really missed. But, on the flip side, I think it encouraged and in some cases forced me out of my comfort zone and to do things I might not have had time to do otherwise.

I can’t say it was a great year. While I’ve been fortunate and have not had anyone close to me succumb to Covid, I know too many people who have had friends and family die of it. So in that aspect, it’s been a terrible year. As of the latest count, over 342,000 have died in the US and yesterday set a new record in the US for daily deaths. At this rate, by the start of next week we’ll have over 350,000 deaths and predictions are of over another 80,000 in the next three weeks. PASS has been a side casualty of this too.

Too many lives have been impacted and effected and I don’t want to minimalize those.

But, I do want to highlight that even in a dark year, at least personally, I’ve been able to find some positive things to focus on. I hope others have too. Hopefully everyone reading this has at least one thing they can look back on and say, “Yeah, that was good” or “That’s a special memory, I won’t forget.”

And to quote Colonel Potter from MASH: “Here’s to the New Year. May she be a damn sight better than the old one, and may we all be home before she’s over.”

SQL Community

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.

Twas the Night Before Deploy

Twas the night before deploy, when all through the server,
not a script was running, not with any ferver

The queries were pushed to github with care,
in hopes that St. Deployment would soon be there;

The devs were all sitting at home on couches,
while visions of good deploys proved they were no slouches;

And Mindy in her ‘cubicle and I in my car,
Had just submitted our Java in one big jar;

When out on the floor there arose such a clatter,
I sprang from my seat to see what was the matter;

Away to windows I flew with a dash,
Tore open the login only to see the OS crash.

The icon on the desktop of was blinking just so,
gave a lustre of failure to the objects below;

When what to my wonderings eyes should appear,
But a minutia of code and eight tiny beer,
With a developer so lively and quick,
I knew in a moment it must be my buddy Nick.

More rapid than eagles his fingers they flew,
and I knew more #SQLFamily was due,
Now Rie, Now Kathie, now Andy, now Hamish,
On Fritchey, on, Argenis, on Deborah, and on Klee!

To the top of the script, to the top of the code!
Now code away, code away, code away mode!

As leaves before the hurricane they fly,
When they met a debug, threw it to the sky;

So up to the keyboards the coders they flew
With their brains full of tips, and my buddy Nick too;

And then in a twinkle, I heard on the floor,
the opening and closing of every door.

As I drew in my head and was turning around,
Down the aisle my buddy Nick came with a bound.

He was dressed all in schwag, from his head to his feet,
And all his clothes were from Summit and Pass to beat;


A bundle of con gear he had to tell you the truth,
And he looked like a vendor just opening his booth.

His eyes — how they twinkled, his demos how merry,
His patter, purple prosy, his pitch too cheery!

His droll little cube was a certain new low,
And it was clear he would not win best in show;

The stump of a pen he held tight in his teeth,
and the ink circled the printout like a wreath;

He was chubby and plump, right jolly old dev,
I laughed when I saw him, as the code did rev;

A wink of his eye and a twist of his head,
Soon gave me to know I had nothing to dread;

He spoke not a word, but went straight to his work,
finding all the bugs in my code, making me feel quiet the jerk;

And laying his finger aside of his nose,
and giving a node, up the aisle he rose;

He sprang from his cube, to his team gave a whistle,
And away they all flew, quite like a missile;

But I heard him exclaim here he flew from action
Remember parametrize your queries, and to all a good closed Transaction!

– With apologies to Clement Moore (to whom I have no known translation) who apparently wrote the original (and much better) version just a few miles from where I currently sit.

From Wikipedia: The poem was first published anonymously in the Troy, New York Sentinel on 23 December 1823, having been sent there by a friend of Moore,[1] and was reprinted frequently thereafter with no name attached. It was first attributed in print to Moore in 1837.

Partly decorated tree with presents under





Has PASS Passed? Does it Really Matter?

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.