Tag presenting

Introduction to Riak … TONIGHT!

I’ll be speaking at the Columbus Ruby Brigade and giving an introduction to Riak tonight at 6:30PM!

There will be pizza and soda and Ruby and me. You can even stick around afterwards while we all go next door for drinks (you can buy my Diet Cokes all night if you really like the presentation).

Riak: An Overview

This presentation will lead you through an overview of Riak: a flexible, decentralized key-value store. Riak was designed to provide a friendly HTTP/JSON interface and provide a database that’s well suited for reliable web applications.

Add it to your calendar!

SQL Saturday 60 Resources

SQL Saturday 60 was a week ago and I completely failed to post resources from the presentation in a timely manner.

The SQL Server Internals resources have been available for a while: http://facility9.com/resources/sql-server-internals… You just had to know to look for them.

The Modeling Muddy Data talk is available on GitHub: https://github.com/peschkaj/Muddy-Data. This presentation is released under a Creative Commons Attribution-ShareAlike license which means that we can all make things better by collaborating on the presentation materials. I’ll slowly be adding more information to the write up of the talk that is in the README.

SQL Saturday #61

SQL Saturday #61 is right around the corner in Washington, D.C. It’s really Reston, VA but nobody knows where that is, right?

Anyway, I’m going to be in attendance as well as speaking about SQL Server internals. This isn’t a deep dive into any single part of SQL Server, but it is a nice whirlwind tour of what’s going on inside SQL Server. Yes, it’s an early session but I promise you that if wake up in time I will keep things entertaining.

What if you don’t want to learn about SQL Server internals at 8:30 in the morning on a Saturday? You’re in luck! There are a variety of other things you could be learning about SQL Server. I’m not going to go over all of the sessions, you can do that for yourself. I will encourage you to head out to SQL Saturday #61 on December 4th. Hope to see you there!

Upcoming Talks – Next Week

Next week I’ll be in the San Francisco Bay area. More specifically, I’ll be giving three lightning talks at three separate Cloud Camps. It’s the same talk each time, I’ll be giving a general intro to NoSQL and cloud databases.

Silicon Valley Cloud Camp in Santa Clara, CA.
Cloud Camp Santa Clara also in Santa Clara, CA.
Cloud Camp SF @ QCon in San Francisco, CA.

All of these events start at 6:30PM, the Lightning Talks start at 6:45PM, and I have no idea when I’m going to take the stage, but it promises to be good. If you’re in the area and would like to hang out, hit me up in the comments and we can arrange a time to talk.

Upcoming Presentations!

So, it’s only the one presentation, but it is still a presentation.

On October 26th, I’ll be presenting for the Application Development Virtual Chapter. If you weren’t able to attend the Columbus Code Camp, October 26th will be your lucky day! I’ll be revisiting my presentation, Refactoring SQL. Live Meeting will be the only way you can get a hold of this gem, so make sure you’re ready to rock and roll. The party starts at 12PM Eastern, so make sure you’re there on time.

Also, if you’re going to be in the San Francisco Bay area for the first week in November, look me up. I’ll be speaking at three cloud camps out there. Good times.

Talking Is Good, Where Can I Do More?

We can’t all just pick a street corner and start spouting off about whatever strikes our fancy. That’s not how things work, unless you’re a crazy street preacher. Very few people down at the local university will appreciate you getting on a soap box with a megaphone and ranting about normalization. Trust me on this one.

A few days ago, Jen McCown (blog | twitter) put up a blog post about Breaking Into SQL Showbiz. It’s a great post and Jen encouraged speakers to get started with their local user group. Which I wholeheartedly encourage, btw.

What happens next? Let’s say that you’ve given your first presentation at your local user group or for your co-workers and everything went well. Where do you go from there?

Other User Groups

Find other user groups in your area. You can find them through a few websites:

  • PASS – The Professional Association for SQL Server maintains a list and interactive map of SQL Server user groups.
  • INETA – INETA is a bunch of .NET focused user groups. They have an interactive map as well as a traditional location based search.
  • Meetup.com – Meetup.com is a great place to find people who are interested in talking about the same things that you are.

Conferences

When you’ve decided that it’s time to move beyond user group meetings, or you want a bigger thrill, where do you go? Conferences, of course. For a long time I had a problem finding about conferences. It’s not as much of a problem these days.

  • SpeakNET This is an aggregation of other user groups, code camps, and local/regional conferences that are looking for speakers.
  • SQLSaturday There are so many great local SQL Server events that it’s hard to keep track. SQL Saturday does that for me.
  • Community Megaphone This is an aggregator built by a Microsoft Developer Evangelist. It makes it easy to find events to attend or speak at. There’s even an RSS feed.
  • O’Reilly Media O’Reilly produce some mighty fine books. They also put on some mighty fine conferences. If you’re interested in mingling with the not-so-Microsoft crowd, this is a great place to find events to attend and speak at.

You can also find a list of conferences and speaking events on twitter http://twitter.com/peschkaj/conferences.

They See Things Differently

Every once in a while, I’ll be talking with a friend about presentations and they mention that they really like the visual flow or the artwork or something about the presentation. After I get over being flattered (trust me, it’s easy to do), we’ll start talking about how I came up with the material in the presentation. I’d love to say that the photographs are mine, but they aren’t. There are a few techniques I use to help me make presentations that work well.

Tell Me a Story

When I’m giving a presentation, I try to be acutely aware about how the material flows. I don’t want to take the audience on a wild ride across a bunch of topics. It’s difficult enough to sit still for 60+ minutes and listen to a single topic. But sitting still for over 60 minutes and listening to a variety of topics? That’s nearly impossible.

Instead of trying to cover a bunch of topics, I cover one topic. I break the topic down and I find a logical beginning, middle, and end. Sometimes this part is easy, sometimes it isn’t. The point of the exercise, though, it to find a good way to teach a topic. Kevin Kline (blog | twitter) has a great presentation about the SQL Server internals where he visualizes the presentation from the perspective of a query traveling through SQL Server.

Telling a story makes the presentation more than a series of facts. Telling a story takes a series of facts and gives them a personal connection. Rather than list a bunch of facts, tell your audience how you got somewhere. In a presentation I give on dynamic SQL, I share with the audience how I learned to write good dynamic SQL by showing them examples of bad dynamic SQL. It’s a technique that works well because we’re sharing our embarrassment at the bad code we’ve written and then we learn how to get better. Buck Woody’s (blog | twitter) presentations are so popular because he peppers them with anecdotes. (It probably helps that Buck knows what he’s doing, but let me stick to only one point, okay?) The anecdotes do the same thing – they break make the material relatable.

Let’s Play Word Association

I do a lot of word association when I’m working on presentations. This isn’t some kind of goofy improv theater troupe exercise; it’s how I find great images for my presentations. I’ve been known to spend a lot of time agonizing over a single image to get the message just right.

Symbols are the instruments which convert raw intelligence into culture. Without them, explained Lewis Mumfor, ‘man’s life would be one of immediate appetites, immediate sensations, limited to a past shorter than his own lifetime, at the mercy of a future he could never anticipate, never prepare for. In such a world, out of hearing would be out of reach and out of sight would be out of mind.’

Alan Fletcher – The Art of Looking Sideways

Finding the right symbol to trigger a memory is difficult. There are many different ways to convey an idea, but only one will bring the idea to life. How do you find the image that brings an idea to life? Searching.

In my presentation on SQL Server internals, I use this image to help describe row and index operations. The linear form of the building kind of looks like a table with rows and columns. It doesn’t look exactly like a table might look (you could call that Excel), but it is an image that we’re all familiar with.

Finding Inspiration

The obvious question is “How do you come up with this stuff?”

The unfortunate answer is “I don’t know.”

I spend a decent amount of time looking at art – be it photos, drawings, paintings, whatever. I really enjoy visual communication in all of its forms, so I try to partake every chance I get. I think that has influence the way I find images to use in presentations.

When I’m looking for images, I go through a process of searching through flickr. I don’t necessarily search for funny pictures or pictures with any specific word association. Sometimes I just watch the flickr panda and hope that something interesting and creative commons licensed pops up. This can be a good way to find interesting pictures that set a mood or a tone. Or maybe the image will just continue on whatever theme I’m using through the slide deck. It’s not always important that I pick the right image for any single slide, but that the image fits the presentation as a whole.

Sometimes I’ll even watch the panda when I’m not creating a presentation. I’ll have it up in the background and I’ll save off interesting pictures that I’ve found. The key when I’m doing that is to make sure I have some way to capture the photo’s metadata so I can give credit later. Sometimes it’s easiest to save a text file with the same name as the photo so you know exactly what metadata belongs to each photo. It doesn’t matter how you do it, just make sure you can give credit where credit is due.

Another way I find inspiration is to read a lot of magazines. I don’t necessarily subscribe to them, but I look through them. Advertising is something that we normally bypass when we’re searching for an article we want to read. Advertisers, on the other hand, are trying to get your attention and convey a message with a single image and as few words as possible. Take a look at how advertisers are trying to get your attention. There are a lot of techniques that you can pick up from successful ads without even knowing what you’re doing – composition, layout, the amount of text to use.

There’s inspiration everywhere. Find it and use it.

Speaking at SQL Saturday Nashville

- or -

It’s Going to be a Busy Week

This week is going to be an incredibly busy one. On Saturday I’m very honored to be presenting twice at SQL Saturday Nashville.

Fundamentals of SQL Server Internals: Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.

Taking Control of Your Career: Raises, promotions, and job offers don’t happen by accident; you need a plan. Through careful planning you can create and reach impressive goals. But what’s the point of reaching your goals if nobody notices? “If you build it, they will come” doesn’t apply when you’re building your career.

“But Jeremiah,” you say, “you are clearly a slacker. Getting ready for two presentations can’t be that difficult for someone with as much ego as you!” And you would be correct; getting ready for two presentations isn’t difficult (mainly because I’m amazing). This week I am also travelling to beautiful Nashville for the PASS Board of Directors meeting.

The BoD meetings are always a good time, but they can be a little tiring (as do most meetings). This meeting promises to be a good one. As best as I recall, we’re going to be talking about PASS at a much higher, strategic, level. There will be less “down in the details” discussion and more “head in the clouds” type of talk. It’s good to put aside worrying about nitty gritty details and focus on the future of an organization. Too often we don’t do that.

SQL Saturday 42 Musings

SQL Saturday 42 has been and gone. I don’t have a ton to say, but I wanted to try to post my thoughts on the event before they were completely gone from my mind.

The people who put this event on – Dave Schutz, Stuart Johnson, Marc Kuyper, Jim Stoltz, and John Jakubowski – deserve a big round of applause. They put together a very strong event and it seemed like they were incredibly well prepared.

Despite Brent Ozar suffering from incredible jet lag, and another speaker not showing up, things went off well. Allen White and I were able to cover Brent’s time slots, but not his presentations. This led to the funny moment of an attendee walking into the room and saying “You’re not Brent Ozar.” I replied, “No, I am not, but I’m talking about SQL Server Internals, it’ll be fun.” They just said, “Oh,” and walked away. So, apparently, I’m nowhere near as engaging as Brent talking about his stupid and dangerous T-SQL tricks. Clearly they don’t know that I’m just stupid and dangerous.

Outside of that, things went very well. My Dynamic SQL talk went over well, although I think I need to re-work it. I felt like I was flipping back and forth between demos and code a bit too much. It gave the entire experience a jerky feel. I suspect I’m overly critical of the presentation since I’ve given it a few times, but it’s always good to improve.

My internals presentation wasn’t well attended – this is probably due to me not being Brent Ozar. However, that didn’t stop us from having fun talking about SQL Server Internals. If anything, having a room of 6 people made the topic more fun to talk about. We were able to digress onto different topics, delve a little bit deeper than normal, and have a lot of fun watching me not trip over an extension cord.

Last but not least was my Indexes and Other Free Performance Boosts. I had a full room on this – I suspect it had something to do with the word “Free” in the presentation title. This is a really fun presentation because it’s a whirlwind tour of indexes, keys, statistics, and how they work together to coax SQL Server into giving us data faster. Once again, I think I need to smooth up the code samples, but on the whole things went really well.

I don’t have any of the evaluations, but I hope the SQL Saturday team is able to get those out to the speakers soon. From the ones I glanced at, I did a passable job. I’m looking forward to the next event in Columbus.

Free Training – SQL Saturday 42

Good news! I’m speaking at SQL Saturday 42 this Saturday. Got nothing to do? Head on down to Goodwill Columbus at 1331 Edgehill Rd, Columbus, OH. Got something to do? Cancel it.

I’m excited about the presentations I’m giving – I haven’t given the indexing presentation in a long time and it should be a lot of fun. And the Dynamic SQL presentation is one of the first in the day. It’s a nice easy way (I think) to get your day started.

A Dynamic World Demands Dynamic SQL

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.

Indexes And Other Free Performance Boosts

The database is often viewed as a major performance bottleneck. There are a number of quick, easy, painless techniques that can increase the performance of an application not just by a small amount, but by orders of magnitude. These techniques includes simple indexing techniques, T-SQL techniques, and general database application design patterns that give great gains in performance. In this session, you will learn how to look at a database to identify these problem areas and how to resolve common issues that you will encounter.

What else?

Let’s say you’re interested in something else. What should you go see? Well, Michael Swart (blog | twitter) put together a nice little blog post about How I plan to spend my weekend.

If you like business intelligence, I suggest you hit up Dave Rodabaugh’s presentations. I cannot speak highly enough of Dave’s work. Not only is he one of the brightest BI people I know, he’s also been a teacher, friend, and mentor to me for a long time.

There will be some kind of dinner/drinks/whatever going on afterwards at Barley’s Smokehouse (map). I plan on being there for a little bit. Even if you can’t make it to the event, head on over there around 6:00PM. I’ll be there.

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 401 items have been purified.