I “speak” Oracle. Can I go to SQL Saturday?

I’ve been involved with SQL Saturday for a while — since 2010, to be exact — and have worked with SQL Server for even longer than that. However, I currently work in an Oracle environment. This likely begs the question: if I work in Oracle, is SQL Saturday still worth my while?

The short answer: yes, absolutely!

The longer answer: there is more to SQL Saturday than just SQL Server.

Although Oracle and SQL Server are different platforms, they are both relational databases. Granted, there are differences between the two — having worked with SQL Server for so long, I’m still trying to grasp some of the concepts of Oracle. However, many of the concepts between the two relational databases are the same. Both databases share the same SQL language — albeit with some differences (akin to, say, differences between American and British English). Table structures are largely the same (again, there are differences, but they share enough similarities that knowing one allows you to grasp the other).

While differences persist between the two environments, cross-pollination between them is not necessarily a bad thing. Understanding their differences can often lead to a better understanding as to how they work.

On top of that, SQL Saturday is more than just the technologies. Speakers, myself included, present on a variety of topics that aren’t limited to just SQL Server. A number of speakers present on BI topics (some SQL Saturdays, in fact, are BI-specific; look for any event labeled “BI Edition”). Other topics include strategy, architecture, disaster recovery, and professional development. (As I’ve stated time and again, my own presentations are all professional development talks; they have nothing to do with SQL Server.)

And SQL Saturday isn’t just about attending presentations and learning. SQL Saturday is a huge opportunity for networking, which is essential for surviving today’s professional market. I’ve written and presented extensively about the importance of networking. A number of other people have also presented on the importance of networking; for PASS events, I highly recommend Matt Cushing‘s presentation about getting ready for a SQL event!

And if that’s not enough, SQL Saturday is just plain fun! I always have a blast at every event I attend!

So even if you work with Oracle, or NoSQL, or Access, or whatever your database of choice, SQL Saturday likely has something for you. Find an event near you, and come join us in the community!

Monthly CASSUG Meeting — September 2019

Greetings, data enthusiasts!

Our September speaker is our own Greg Moore! He will do his presentation titled: “Pocket-sized Server: SQL Server for under $200!” For additional information and to RSVP, go to our Meetup event page at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/264169963/­

Thanks to our sponsors, Datto, Capital Tech Search, and CommerceHub, for making this event possible!

Hope to see you there!

Coming up with presentation ideas

As a followup to yesterday’s article, I thought it might be fitting to talk about presentation ideas.

Despite the fact that I speak regularly at SQL Saturday, none of my presentations (up to this point) have anything to do with SQL Server or even anything data-related. My topics revolve mostly around documentation and communication. So how do I go about coming up with presentation topics?

To answer this, I suppose I should go back to the beginning, and (re-)tell the tale as to how I got involved.

Back when I was primarily a SQL Saturday attendee, I knew I wanted to get involved. The question was, how? At the time, I looked around at the people attending the event, and I said to myself, “these people probably know more about SQL Server than I do. What can I present that these people would find interesting?”

In the early days of our user group (I was one of the original co-founders and members), we sought out speakers to present. I thought about data-related topics. I even took a turn one meeting where we were encouraged to bring up SQL-related issues as discussion topics. But when it came to ideas for data-related topics, I kept coming up empty.

I thought about a time at one of my jobs where I became an accidental customer service analyst. As a developer, I was not allowed to speak with end-users, but one day, I received a phone call from a user. It turned out that he had gotten my number from someone who was not supposed to give out my number. I was able to walk him through and satisfactorily resolve his issue. In fact, I did such a good job with it that, from that point forward, I became one of the few developer/analysts who was allowed to talk to customers. It made me realize that I had a knack of being able to discuss technology with end-users without being condescending to them.

During one user group meeting, I jotted some notes down. By the end of the meeting, I had come up with enough material for a presentation. I ran my idea past my fellow user group attendees, all of whom said, “that would make a great presentation!”

I worked on the presentation and presented it at a user group meeting.

Four years later, I will be giving that same presentation at PASS Summit! I’ve come a long way!

While that ended up being a good presentation, I’ve tried not to rest on my laurels. I still try to come up with new presentation ideas. I’ve come up with several since then, and I’m still trying to come up with more.

When I think about presentation ideas, I generally keep these thoughts in mind.

  • Is it a topic that attendees will find interesting?
  • Is it unique?
  • Is it something about which I’m knowledgeable, and I feel comfortable talking about?
  • Is it something I can present within an hour? And do I need to cut it back to an hour, or do I need to fill it in to an hour?

I still remember a piece of advice that Chris Bell, a DBA and fellow SQL Saturday speaker, once told me: “an expert is someone who knows something that you don’t.” That was profound advice, and I’ve never forgotten it. So far, it’s served me well in my speaking endeavors.

So if you struggle to come up with presentation ideas (like I do!), hopefully this will help you get the ball rolling. I look forward to seeing your presentation soon!

#SQLSaturday NYC — I’m speaking, I’m speaking, I’m speaking! #SQLSat912

Image result for manhattan skyline

The schedule for SQL Saturday #912 in New York City (Saturday, October 5) was released this morning, and I’m on it — not once, not twice, but three times!

I am scheduled to do the following three (!!!) presentations:

Looking at this schedule brings up a myriad of thoughts for me.

  • I don’t ever remember doing three presentations in a single day at any single event in my life. So I’m venturing into uncharted territory here!
  • Without fail, I absolutely love any SQL Saturday I attend! Also without fail, I am nearly always wiped out at the end of each one. I can only imagine how tired I’m going to be at the end of this one. At least I can sleep on the train ride home!
  • I purposely scheduled a late train home that night after the event so that I can get a decent dinner down in the City. I figure a couple of drinks during dinner might be in order that night!
  • My brother, who lives in Queens, has his birthday a few days before the event. I’m hoping to make it a birthday dinner for him that night!
  • To his credit, Thomas Grohser, who is one of the co-organizers for the event, emailed me asking if I was okay with doing three presentations. I sent him back a two-word reply: “challenge accepted!”
  • I was very happy to see that, as we requested, Matt Cushing and I have our networking sessions (titled Networking 101 and Networking 102, respectively) scheduled back-to-back! Go check out Matt’s session; it’s a good one!
  • If there’s any downside to doing three presentations, it’s that I likely won’t be able to attend other presentations that interest me. I do intend to attend Matt’s session (I need to keep my streak going, after all), and I’ll need to check the schedule to see what other sessions I want to attend (if I can).
  • Of all the SQL Saturdays I’ve ever attended, I’ve attended New York City the most often. For several years, including the first one I ever attended, I only attended NYC SQL Saturday. So for me, being chosen to selected to speak for NYC is special to me.
  • When I spoke here last year, I had an opportunity to get breakfast at Ellen’s Stardust Diner. It was right next to my hotel and right on my way to the Microsoft office (where SQL Saturday NYC is held). I managed to get there early enough to beat the tourist crowd. This year, I am once again staying in a nearby hotel (only a block away from where I stayed last year). I’m hoping to get there for breakfast again. Yes, I know it’s a tourist trap, but the singing wait staff is something else! You need to check it out at least once!

I can probably keep writing more thoughts, but at this point, work beckons! In any case, if you’re interested in attending NYC SQL Saturday on October 5, go to their web site and register for the event!

And come see me present — three times!

References and memorization

I was working on a document, and wanted to toggle the language on MS Word that was used for proofing (I downloaded the template from our UK subsidiary, so it was proofing in UK, not US, English). I couldn’t remember how to do it, so I consulted Google, found my answer, changed the setting, and went along my merry way.

For whatever reason, it got me thinking about Microsoft certification exams (it’s funny how one’s mind works sometimes). It’s been a long time since I took one. What got me thinking was that, when you take a certification exam, you are not allowed to bring any notes or references with you into the testing room (as far as I remember — I’m not sure if that’s still the case now; like I said, it’s been a long time since I took a certification exam).

In this day and age where finding information is as easy as picking up your smartphone, I really believe that memorization is overrated (and, maybe in some cases, even dangerous). I wrote as much a while back, and I still believe that now.

Back when I worked as an adjunct instructor, all my assignments, quizzes, and exams that I gave to students were open-book, open-note. I also told my students that they were allowed to help each other work toward the answers, including during an exam. They were not allowed to outright give each other answers; that constituted cheating and were grounds for failing the exam. Maybe some instructors might scoff at this approach, but my students were very good about adhering to those rules (many of them told me later that they learned more in my class than any other they’d ever taken), and there was a method to my madness.

For one thing, I told my students that the ability to look up and research information was an important skill to have. We, as imperfect human beings, are never going to remember absolutely everything, so to be able to know how find the correct answers is important. Second, when we’re in a working environment, the ability to work together as a team is critical. When you’re working within a team environment, being able to work with others to achieve a common goal is a big deal.

Finally, how many workplaces are going to tell you, “okay, put away all your books and references. You’re going to do this project entirely from memory.” I don’t know about you, but if a manager ever told me to do that, I wouldn’t be able to update and distribute my resume fast enough.

In his SQL Saturday presentation entitled “Why candidates fail the job interview in the first minute,” Thomas Grohser mentions that he does not expect any candidate to be able to know everything. If a candidate says that (s)he “does not know the answer, but here’s how I would go about finding the answer,” then that is a perfectly acceptable answer. More often than not, trying to do everything from memory is a bad and sometimes dangerous approach, and is a bad way of thinking.

We are not perfect. We will never remember everything. And anyone who says that (s)he knows everything is full of crap. Rather than try to brute-force memorize anything and everything, it’s more important to develop skills that teach you how to think and how to find, verify, and process information. If I was a hiring manager, that ability would be vastly more valuable than someone who says that (s)he “knows everything.”

SQL Saturday #855, Albany — the debrief

This past weekend, we (the CASSUG user group) hosted our sixth SQL Saturday. I’ve attended dozens of SQL Saturdays, but the ones that we hold in my own backyard are always the most special to me. This is one of my favorite events of the entire year, and I look forward to it each summer.

At the speaker’s dinner on Friday night!

I’ll start by talking about my own presentations, which took place in the afternoon (I was scheduled for the last two time slots of the day). My first talk was a lightning talk about business cards. (If you want to know about what I presented, check out my ‘blog article — it pretty much outlines what I talked about.) Mine was one of seven talks, along with talks by Bryan Cafferky, Andy Yun, Deborah Melkin, Michelle Gutzait, Taiob Ali, and Paresh Motiwala. Besides my own talk, I was able to catch the first five talks (unfortunately, I had to leave to prepare for my presentation, so I missed Paresh’s — but that’s okay, because he gives a terrible talk, anyway*), and I can tell you that every one of them was an awesome presentation. I loved every single one of them.

(*ed note: I’m kidding, Paresh! You know I love you!)

I get ready to do my presentation

All kidding aside… immediately after the lightning talks session, I had my own full-length presentation to do. I debuted a brand-new presentation about ‘blogging. For the most part, it went well, but it isn’t perfect. I did get a couple of comments back saying that they were expecting more about the career aspect of ‘blogging. Apparently, they were looking for a direct link between ‘blogging and career. The idea of my presentation is that ‘blogging can enhance your professional profile and well-being, but apparently, that didn’t come across in my presentation. I’m scheduled to give this talk again in Providence next month, so I’ll have to figure out what tweaks I need to make between now and then.

Other than that, I attended two other sessions: Matt Cushing’s networking presentation, and Thomas Grohser’s interviewing presentation. I’ve attended both presentations before, and they are both great sessions; if you ever have a chance to attend either presentation, I recommended them highly! Tom asked me to attend his; when I attended his previous sessions, he liked my questions and commentary so much that he asked me to come back to ask the same questions and make the same comments — for the benefit of others in attendance. For Matt’s session, it was more a matter of personal pride. He has given the presentation (I think it’s been) six times, and I have been to all six! It’ll be seven for seven next month; he’s coming back to Albany to give his presentation at our user group meeting!

SQL Saturday isn’t possible without the help of volunteers!

I had to skip out on the second round of sessions to pick up more ice (which was especially critical, since it was the hottest day of the year so far). I didn’t just speak at Albany SQL Saturday; I also served as a volunteer. As I’ve written before, SQL Saturday is an all-volunteer event, and they wouldn’t be possible without all the volunteers who do the behind-the-scenes dirty work, such as setting up, manning the registration tables, making coffee, cleaning up, assembling attendee bags, and all the little things that help make the event go (such as picking up more ice for the coolers). Volunteers are the unsung heroes of SQL Saturday, so if you ever attend an event, make sure that you show them your appreciation!

A few of us went out for ice cream after the speaker’s dinner!

There were many other aspects of SQL Saturday that made it fun — and are among the many reasons why it is one of my favorite events of the year! I didn’t even mention the speaker’s dinner on Friday night, the after-party on Saturday after it was all over, and the great time I had with many friends whom I often only get to see at these events!

SQL Saturday is a lot of hard work and effort, but it is well worth it! It isn’t just about the data sessions and free training; it’s also about networking, talking to vendors, making friends, and having fun! If you ever get to a SQL Saturday near you, I highly recommend it!

Ransomware and DevOps

Another post by Steve Jones that I think is really important…

Voice of the DBA

Ransomware.

A scary topic and one attack that is apparently more common than I suspected. Before you go further, if you haven’t restored a database backup in the last month, stop and go verify your DR plan works. That’s one of the overconfident issues facing lots of government and businesses. While this might not help your entire organization, at least you’ll have some confidence in your process and that you can recover a database.

This is a great article from Ars Technica and worth reading: A take of two cities: Why ransomware will just get worse. I’d recommend you read it and think about a few things. First, do you have insurance because things (or substitute your own word here) happen? Second, have you really tested a DR plan for some sort of software issue like this? You might think about a way to restore systems in an air-gapped…

View original post 356 more words