Topic: How Intelligent Query Processing improves T-SQL performance
Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019.
While IQP has benefits for both operational and development DBAs, this presentation will focus on T-SQL capabilities. We will explore how IQP impacts Table Variables, Scalar User Defined Functions, and Batch Mode for Rowstore.
When you leave, you’ll have a solid understanding of how SQL Server 2019 can improve your T-SQL code performance, potentially without a single code change!
Our online meeting schedule is as follows:
6:00: General chat, discussion, and announcements
We usually wrap up between 7:30 PM and 8:00 PM.
Please RSVP to this Meetup using the above link, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.
Thanks to our sponsor, Datto, for making this event possible!
Yesterday, a good friend of mine texted me, asking me to send him my resume. This particular friend works for a major nationwide consulting firm. I won’t say which firm, but I will say that it’s a household name. In his position, he is often in a position to hire, and he is well-connected.
After reviewing my resume, he texted me back again, saying “let’s talk. I have some ideas that might make your resume even better, and I want to make sure those changes are implemented before I pass your resume along. Do you have time to talk tomorrow?”
I got off the phone with him a little while ago, and what he had to say was eye-opening — and in our conversation, I managed to improve my resume even more.
His advice (and I’m paraphrasing here): “what projects are you the most proud of? As a hiring manager, that’s something that stands out to me. Your work experience looks good, but everything you mention is general day-to-day activities. You don’t really list much in terms of a specific project you worked on. For example, something like ‘I designed such-and-such app that helped people do their work more efficiently by whatever-it-did-to-help-them, saving the company millions of dollars’ is something that would stand out to me. What are you the most proud of? Make sure you highlight that in your resume.”
I did raise a concern. I told him, yes, there is a project that immediately pops into my head, but it goes back many years; in fact, it’s a project I worked on for a company that goes outside of the past ten years. He told me, “that doesn’t matter” (he also relayed to me a project that he was proud of that took place over twenty years ago). “I’m proud of that, and I still include that in my profile.”
I had my resume file open in front of me during our conversation. While we were talking, editing ideas started forming in the back of my head.
His suggestion was to include these projects in my work experience, but I decided to leave that section alone. Instead, I decided to rewrite the Career Summary section of my resume. I wanted to do it this way for a couple of reasons: one, this appears at the top of my resume and would be the first thing that prospective employers read, and two, rewriting the Work Experience listings would have been a lot of work, and could have potentially resulted in document restructuring issues.
In terms of projects in which I take pride, I immediately wanted to mention a server inventory database that I built years ago; whenever anyone asks me about a professional project of which I am the most proud, this is the one that I always think of immediately. I also wanted to mention my involvement with recovery efforts after 9/11 (my Disaster Documents presentation is based on this experience), so I included that on the list as well. I also wanted to include a project that was much more recent, so I included a user guide that I wrote from scratch, including developing the Word template for it (additionally, I wanted to highlight that it was for a SaaS application). Finally, I also wanted to make mention of a project in which I learned about MVC concepts (unlike the other projects, this one does appear in my Work Experience section).
There were also a few other things I wanted to do with my Career Summary section. A while back, I came up with my own personal tagline, but it did not appear in my resume. I wanted to make sure it was included. Additionally, whenever I submitted my resume, I was finding that I was experiencing confusion on the part of prospective employers. I was (and still am) targeting primarily technical writer positions, and I was often questioned, “with all this technical experience, why are you targeting tech writing jobs?” I wanted to restructure it in such a way to explain that I was drawing upon tech writing as a strength, without sacrificing the fact that I had a technical background.
Before I made my edits, the Career Summary section of my resume looked like this.
When all was said and done, this is how it came out.
Additionally, I had to make changes to other sections of my resume, entirely for formatting purposes. I wanted to ensure that it would fit on two pages. I consolidated a few sections of information that, while helpful, I didn’t think would be as important.
I made the changes, updated my resume files (Word and PDF), and resent it to my friend. As of this article, I’m still waiting to get his feedback (he texted me to say he was busy, but would look when he had the chance), but personally, I like the way these changes came out.
(Edit: I heard back from my friend; his advice was to keep the accomplishments to one line each. In his words, “make it punchier.”)
You don’t necessarily have to do this within your Career Summary section; this was how I decided to approach it. If you can incorporate these highlights into your work experience listings, then by all means, do so.
I want to mention one thing when adding “proud accomplishments” to your resume. There is a fine line between talking about accomplishments you’re proud of and bragging about things to stroke your ego. Keep in mind that the purpose of a resume is to get you a job interview. Talking about projects you did that made a difference can help with that effort. Bragging about things you did (or didn’t do) will not. Nobody cares about your ego; they care about what value you can bring to their organization.
So what are your thoughts on these changes? Feel free to comment on them, especially if you’re a recruiter or a hiring manager.
Before I get into this article, I want to make one thing extremely clear. This article has NOTHING to do with circumventing pandemic protocols or ignoring the advice of Dr. Fauci, the CDC, the WHO, or any other medical professionals. That is NOT what I’m about to write. Please, please, PLEASE keep wearing your mask, get your COVID shots, and maintain physical social distancing. Above all, be safe.
Now that that’s out of the way, let me get into what prompted this article.
Earlier today, this random thought popped into my head. I posted it to my Facebook, and I want to share it with all of you as well.
I’m sitting here thinking that possibly the thing I miss most during the pandemic is simply the ability to go out and have a drink with a friend.
Granted, the part about “having a drink” is irrelevant. I say that as a catch-all for going out for a beer, wine, coffee, soda, lunch, dinner, dessert, watching a ballgame, going to a movie, and so on. (I could also say “hanging out in your friend’s living room;” it’s within the same spirit of what I’m writing about, but it’s in a private, not public setting, which people are likely doing, anyway — hopefully, COVID-safely. But I digress.)
I don’t know whether the fact that today is St. Patrick’s Day had anything to do with this thought, but what did prompt it was an urge — and a basic desire — to pick up the phone, call a friend, and tell him or her, “let’s meet up at (some favorite local hangout) this Friday night*.”
Raise your hand if you miss getting together with friends — and I’m not talking about virtually over Zoom. Yeah, me too. The last in-person social event I remember attending was the after-party for SQL Saturday out in Rochester in February of last year. Since the pandemic began, I’ve had almost no in-person interaction with any of my friends, other than my wife (I’ve had a few, but they’re few and far-between). I would love to get together with friends to talk hours on end about world events, music, sports, family, or even about absolutely nothing. Don’t get me wrong; I love my wife, but there’s something to be said for sharing your thoughts, news, and feelings with someone whom you’re not sharing your lockdown experience 24-7 over a forum other than Zoom. Humans are mostly social animals, and interaction with other humans is therapeutic, even if you’re introverted.
(And if you do consider yourself to be introverted, don’t feel obligated to talk. Just being there is very helpful, too.)
Every now and then, I’ll get on the phone with a friend of mine, and we’ll talk for hours — sometimes, about nothing more than random thoughts that pop into our heads (if he’s reading this, you know who you are). We’re the kind of guys who can spend hours talking about “absolutely nothing.” Regardless of what we talk about, I find our conversations to be therapeutic, and I feel like a lot of stress has dissipated, even if I do have something on my mind.
So, if you’re able to do so COVID-safely, take time to hook up with your BFF. You might find the experience to be rewarding and stress-relieving, especially during this time of pandemic and social distancing.
I’m not going to lie. The mental stress of being out of a job (ten months, and counting) is affecting me in many ways. I’ll talk about the mental stress (which is what this article is mostly about) in a minute, but before I get into that, let me talk about something that has been affecting me physically.
Last year, gyms were closed down due to the pandemic. As a result, I wasn’t able to attend CrossFit classes. For me, one of the biggest benefits of CrossFit classes was that it created a routine. I tend to be a creature of habit, and as long as I stick to a routine, I’m generally okay. With the gyms closed due to the pandemic, that routine was broken. I didn’t stay active at home as I would’ve liked (although I did attempt a Couch to 5K program). I started developing issues with my back and my shoulder (which continue even as I write this), enough to require physical therapy. Now, the gyms are back open, but I’ve been dealing with physical issues that prevent me from working out as I’d like. Thankfully, PT seems to be alleviating these issues, and I’m hoping to become active again soon.
That said, the past year has affected me mentally and psychologically, and I’ve fallen into some bad habits. I haven’t been as active with my business as I should be. I’ve been moody, and I seem to have mood swings easily. The constant battle of looking for employment has been extremely taxing and frustrating. A lot of activities that I normally enjoy haven’t been giving me much pleasure as of late.
I could keep going, but the last thing I want to do is write a woe-is-me article where I feel like I’m trying to solicit sympathy. I’m not (at least I don’t think I am, anyway — maybe some of you might disagree, but I digress). Rather, I’m laying out the scenario so that I can write about coping strategies (and I’m writing this for myself as much as any of you who might be in the same boat). In my job hunt presentation, I talk about making sure that you take care of yourself. This article is about practicing what I preach.
Before I started this article, I sat in my home office, thinking about “what should I do to get back on track.” I thought about a number of things, and I’d like to share them with you.
First of all, I revisited one of my hobbies: songwriting. I’ve been working on an idea for a new song, and I opened my notation app to revisit it. I’m finding that doing so is pleasantly distracting; it gets my brain working on something productive. Doing this makes an adjustment to my mental activity which, I believe, will improve my mental and psychological state over the long run.
I was also fortunate enough to be contacted by a friend of mine who said he might have a project for me. We spoke, and I told him I’d look at it. It’s not gainful employment per se, but it’s another productive distraction to get me going again. On that same topic, I also have other projects for my clients that I need to revisit as well.
Other friends have other coping ideas as well. I highly recommend Steve Jones‘ series of articles about daily coping. His suggestions make a lot of sense, and I find that they improve my mood (I’ve even told him as such).
I need to do something physical as well. My doctor recommended that I do a minimum of five minutes of physical activity per day. At the time of the recommendation, I was in serious pain (directly related to the conditions I mentioned at the top of this article) so I wasn’t able to do this right away, but now that they’re somewhat better, I feel like I can partake. I do have an exercise bike; I will be making use of it. Additionally, I will be investing in some resistance bands and PVC pipes (to do pass-throughs).
And, if nothing else, I’m also trying to come up with ideas for ‘blog articles.
You need to take care of yourself before you can take on your responsibilities. These might sound like small moves, but small moves add up. Things like this can reinvigorate yourself and get you back on track. And once they do, you can be productive again.
Topic: Modern CPU Architecture and SQL Server Performance
Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, and instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.
Our online meeting schedule is as follows: 6:00: General chat, discussion, and announcements 6:30: Presentation We usually wrap up between 7:30 PM and 8:00 PM.
Please RSVP to this Meetup, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.
Thanks to our sponsor, Datto, for making this event possible!
It turned out to be a lot of work — much more than I expected. I already had my bio and my presentation descriptions within the application, but I discovered a number of other features that, I believe, will present me with additional opportunities to speak.
First, while Sessionize keeps track of events to which you apply through its application, I discovered that it also has the ability to enter external events not scheduled through Sessionize. Even the header on the external events page says, “Organizers love to see your talk history” (and I agree). So, I went through my presentations page to enter all my previous speaking engagements that I did not schedule through Sessionize.
Did I mention that it was a lot of work? I started speaking regularly in 2015. In that time (until now), I’ve spoken at 26 SQL Saturdays, two PASS Summits, seven in-person user group meetings, three professional development virtual meetings, and a podcast. Granted, I know people who’ve spoken at more events than I have, but still, that’s a lot of speaking engagements. I added them to my external events, including descriptions and web links (where applicable — since PASS.org is no longer active, I linked the SQL Saturday pages to the schedule PDFs that I downloaded several weeks ago, and a few other links to any YouTube presentation links I had available).
I also discovered that Sessionize has an option called “discover events” — a feature that allows you to discover potential speaking opportunities. I had gone through the Data Saturdays site to apply to speak at (virtual) events in Redmond and LA, but when I saw the “discover events” option, I got curious.
As it turned out, in order to use this option, I had to fill out sections for areas of expertise and topics, so I filled them out as best I could. Once I did so, I was able to view (and apply to) potential events. In addition to the two Data Saturday events, I also applied to the VTTA Tech Conference and Techorama 2021. (And Sessionize says that I still have an active application to speak at Albany Code Camp, where I’d applied last year, but the event was wiped out by the pandemic.) I think I have a decent shot at the Vermont tech conference, and I have my doubts about being accepted to Techorama, but I figure, you never know until you try.
So far, I do like the Sessionize application. It does a good job of keeping track of my profile and my speaking engagements, and it could potentially open up more speaking opportunities. I’ll admit that I felt some trepidation after PASS (and SQL Saturday) ceased to exist. I wanted to continue speaking at events, and I wasn’t sure how to approach it once the SQL Saturday window closed. We’ll see what speaking opportunities open up with this application.
After the demise of PASS, a common question among data enthusiasts and PASS members was, “what happens with SQL Saturday?” SQL Saturday was backed by PASS, and as such, when PASS disappeared, so did SQL Saturday.
When I submitted my sessions, I was a little surprised to see my information come up in the speaker’s profile. My initial thought was that they had exported and imported my profile and presentation info from the PASS.org site, but I don’t think this is the case. Data Saturday uses Sessionize to coordinate events, and as it turned out, I already had a Sessionize profile; I had created it last year for Albany Code Camp, where I had applied to speak last year; of course, the event was wiped out due to COVID. I did notice, on my Sessionize profile, that my submissions are in evaluation for Albany Code Camp on September 25, so I’m assuming that that event is rescheduled for that date.
We’ll see if I’m picked to speak for the Redmond event. There are a number of additional Data Saturday events listed as well; I haven’t yet decided what other events I’ll apply to speak. Even though the events are virtual (for now), they still require some work, and I’m wary of spreading myself too thin, despite my desire to speak at more events.
In any case, I’m looking forward to participating in this next endeavor. I’m looking forward to contributing toward these conferences, and, as always, I’m also looking forward to reconnecting with my #SQLFamily friends.