Support your local public library

I remember when I was a kid, Tuesday was my favorite day of the week. That was because that was library day. One of my parents would take me and my siblings to the local public library where we would check out books and magazines, take them home to read, and bring them back next week to do it over again. Back in those days, you were only allowed to keep books for a week (unless, of course, you renewed them).

Now that I’m much older, I still enjoy going to the library, although I don’t go as much as I used to (usually, time commitments keep me from going as much as I’d like). Nevertheless, I have a library card, and I enjoy going whenever I have the chance.

I was thinking about this earlier this evening while I was researching meeting venues. There are plenty of them that charge an arm and a leg, but why do that if a local library has meeting facilities? (I was also considering firehouses — which usually has meeting space — as well, but that’s another post for another time.)

The library is a great place. Not only can you check out books, you can also check out music, do some research (this was especially true in the days before the internet), attend talks and other events, and maybe even meet people. It’s a great public resource, and it’s free (assuming you don’t have to pay any overdue fees)! If a person doesn’t have access to a computer or the internet, (s)he can usually book computer time at a library.

I really think the public library is an underutilized resource these days, especially with the advent of electronic and online resources. Even when I’m giving my presentations, one resource that I nearly always cite is to “go check out your local library.” It’s a neat place to hang out, and there’s always something to be said about wandering around stacks of books. Even in this day and age of the internet and online resources, your local public library is still relevant.

Advertisement

New old presentations

As I mentioned earlier, I have a few speaking gigs coming up, including one in Hartford, CT in March. I’m actually doing two presentations for Hartford: my job hunt presentation (which seems to be one of my best sellers; I’ve done this presentation several times, and I will also be doing it for STC Summit), and my presentation on technical writing. So, I downloaded the WE Local PowerPoint templates from their speaker’s resource page so that I could apply them to my presentations.

I haven’t yet applied it to my job search presentation. To be honest, I’m not terribly worried about it. It’s mainly a matter of transferring my material to the new template, so it shouldn’t be a big deal.

The tech writing one, however, was another story. When I looked at my slides, I realized just how much it needed to be overhauled. It wasn’t very well organized, it was out of date, and I’ve grown considerably in my profession since I last gave that presentation (the last time I presented it was in New York in 2019). The presentation badly needed to be rewritten. So I spent my entire afternoon this past Sunday putting it into the WE Local template.

When I was finished, what I had was practically (though not exactly) a brand-new presentation. It is better organized, more clear, and I included points that I did not address before I restructured it. I think the new (old?) presentation is much better than it was. Not only am I looking forward to giving it in a couple of months, I’m also looking forward to submitting it to more events.

Likewise, I also plan to revamp my presentation about — well — presenting. I’ve only given this presentation once, and quite frankly, not only is it not very good, it’s also narrowly focused, and like my old tech writing presentation, it’s also not very well organized. Although I haven’t started yet, I essentially plan to pull a This Old House on it, completely tearing it down, and rebuilding it. I already have an idea in the back of my head as to how I’m going to do it, and I’ve already rebranded it (in fact, I even submitted it to SQL Saturday NYC in May).

I’ve been trying to come up with new presentation ideas. I’ve mentioned to people that I’ve reached the point where I’m starting to recycle submissions to PASS Summit and other conferences. I might still work on some new ones (stay tuned). But in the meantime, it’s worth my time to take some of my older presentations and give them new life.

The zen of the New Year

Why do we celebrate the New Year? All it is, after all, is a turn of a calendar, when December rolls into January. January 1 isn’t much different than December 31. So what’s the big deal?

As I write this, it’s January 3, three days into 2023. I’m glad 2022 is behind me, as it was a very trying year (as I mentioned earlier), and I’m looking forward to what 2023 has in store. I already have two speaking engagements lined up, and I’m sure I’ll have more fairly soon. I’m getting ready to go back to work (even as I write this, I’m getting ready to head into the office), and I feel like it’s a fresh start.

That’s what it’s all about. Any issues you dealt with in the past year is now in the rearview mirror, and you’re starting with a fresh slate, sure as you go to bed at night and wake up refreshed the next day. A new year might not, on reflection, seem like a “new year,” but at the same time, it’s a reawakening from a busy period of time.

So as most of us return to work on this third day of 2023, let’s make it better than last year!

Make goals, not resolutions

This is an article I wrote three years ago, and it’s just as applicable now as it was when I first wrote it. Now that we’re two days into the new year, I figured it was worth reposting again.

Welcome to Ray Kim's 'blog

My previous post got me thinking about setting goals. I mentioned in my previous article that I hate setting New Year’s “resolutions.” I didn’t want to get into why in that article.

Well, in this article, I want to get into exactly why.

How many of you have made New Year’s resolutions? How many of you made them in years past? How many resolutions did you keep?

If I had to guess, probably not many, if any.

This is why I hate resolutions. They’re almost guaranteed to fail. Case in point: for those of you who go to a gym and work out, how packed is the gym in January? In all likelihood, it’s packed with people who resolved to go to the gym and work out this year.

Now, how many of these people are still at the gym by the end of the year? Or by July? Or…

View original post 574 more words

January Monthly CASSUG Meeting — @CASSUG_Albany #SQLUserGroup #Networking

Greetings, data enthusiasts, and welcome to 2023!

Our January meeting is scheduled for Monday, January 9, at 5:30 pm! We will meet in person at Datto, 33 Tech Valley Drive, East Greenbush, NY.

For more information and to RSVP, go to our Meetup event page at https://www.meetup.com/capital-area-sql-server-user-group/events/290677447/

Our meeting schedule is usually as follows:

  • 5:30 PM: Food, soft drinks, and networking
  • 6:15 PM: Chapter news and announcements
  • 6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

Thanks to Datto for sponsoring our event!

Our guest speaker for the month is Taiob Ali!

Topic: What the heck is a checkpoint, and why should I care?
An 8K page is the fundamental unit of data storage in SQL Server. SQL Server performs every data modification operation in memory (buffer pool) for performance reasons and does not immediately write it back to disk.

This is where checkpoint comes into play. The Database Engine periodically issues a checkpoint on each database. A checkpoint writes the current in-memory modified pages (known as dirty pages) and transaction log information from memory to disk. It also records this information in the transaction log.

This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, and changes made with checkpoint settings in SQL 2014 and SQL 2016+.

Taiob Ali

Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 17 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare.

Taiob is currently working at “GMO LLC” as a Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of the New England SQL Server User Group, founder of ‘Database Professionals Virtual Meetup Group’, and organizer of Boston SQL Saturday.