Category Speaking

Stir Trek: Thor Edition (the Aftermath)

I spent the weekend at Stir Trek: Thor Edition in Columbus, OH. While I had a blast speaking about databases, I had even more fun attending and learning.

Programming the Cloud with HTTP/REST

I knew about REST before I attended this talk and I’ve done a bit of REST programming (right before I decided to nerd out on data), but Mike Amundsen did a great job of convincing me why I should care about REST as a programming paradigm for web developers. I’m not going to go out and start writing code to build my own REST services, but I have a better grasp of how I can work with developers to build robust data driven services and applications and do some incredibly cool things in the process.

CSS 3: Something for Everyone

John Keyes delivered a presentation about the basics of CSS 3. I knew there were some great features of CSS 3, but I also knew that the spec is incredibly broad. I was a bit worried that John’s presentation was going to be a whirlwind tour with very little depth. Instead of a shallow romp through CSS 3, John delivered a solid presentation that worked through some core features of CSS 3 in a practical manner and built up on them to demonstrate new techniques with real world value. Except for maybe the demo that made a rectangle swirl into a circle, that was just cool.

John gets mad props for filling his slide deck with Jurassic Park references. I had some laughs while I got my learn on, and that’s a good thing. I’ve worked with John on presentations in the past and he’s become a phenomenal presenter, programmer, and web developer in the time that I’ve known him.

Real World jQuery

Matt Nowack had the difficult job of speaking right after lunch. He gave a great talk about jQuery 1.5 and 1.6. It turns out that Matt wrote the talk for jQuery 1.5 and did a great job of introducing some of the newest features of my favorite JavaScript library. jQuery 1.6 came out recently and it made parts of Matt’s talk irrelevant. Matt took it in stride and wrote new content earlier in the week and delivered a top notch presentation that was educational and entertaining. I overheard one attendee say that they were rushing off to Matt’s presentation because it was bound to be good. They were right and I was also right to pay them 15 bucks and a box of Milk Duds to yell it at the top of their lungs. Good job, Matt.

The Rest of My Time

I spent the rest of my time preparing and giving my talk The Database is Dead, Long Live the Database. If you attended, the resources page will always be online at http://brentozar.com/stir-trek-thor-edition. If you missed it and you wanted to see it, you’ll be able to catch it on June 28th at 8:00 PM Eastern through the PASS Application Development Virtual Chapter.

I was incredibly flattered when Matt Casto asked me to speak at this event, way back at Code Mash. I’m glad that he was clearly drunk and thought I would make a great speaker. You can’t imagine how happy I am that he accepted the bribes I sent his way, just in case he sobered up and didn’t remember asking me to speak. Luckily, most of that’s a lie. I did, however, have an awesome time in Columbus hanging out with old friends, hopefully making a few new ones, and only telling one STD joke during my presentation; nice try, guy in row three!

In summation: thanks Matt, thanks Stir Trek, and thanks Columbus!

I’m Presenting at SQL Saturday 67

No, this isn’t a re-run! I’ll be presenting about Refacatoring SQL at SQL Saturday 67 in Chicago this coming Saturday.

I’m really excited about this opportunity. I had a blast presenting in Chicago last year and I’m looking forward to doing it again this year. There’s a great line up of speakers. If you’re in the Chicago area and want to get your learn on, I suggest you swing on by the DeVry Addison campus and check it out.

Here’s the title and abstract:

Refactoring SQL

Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.

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.

Columbus Code Camp Slides and Round Up

This weekend I attended the Columbus Code Camp. This was the first code camp to be held in Columbus, and I think it was a success.

There were two tracks of speakers talking about a variety of different topics – Clojure, automated testing, SQL, Ruby, and phone development. The local turn out was good and the sponsor turn out was great as well. Sponsors donated a lot of prizes, swag, and offered their support in a variety of ways. All in all, I would say it was a great event.

I gave a talk about Refactoring SQL. It was the first time I’d presented it and I was polishing the slides until 1:00AM the night before. Lucky for you guys, the slides are now up on SlideShare: Refactoring SQL

.

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.

Presenting for the PASS Professional Development Virtual Chapter

Wednesday, June 16th, I will be presenting for the PASS Professional Development Virtual Chapter.

The Live Meeting starts at 1PM EST and will last for around an hour. You can click on this glorious link to attend.

Title: Taking Control of Your Career

Abstract: 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.

In this session I will show you:

  • How to set achievable goals
  • The importance of planning your career
  • Methods for recording and communicating your accomplishments

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