Chalk Talk 2010 – It’s not your Senior DBA’s Chalk Talk

I don’t know if you’re familiar with the Chalk Talk sessions at the PASS Community Summit. These sessions are shorter, 40 minute sessions, and they happen in the vendor expo hall at the Summit. In the past, this has been a Microsoft sponsored event with Microsoft sponsored speakers. These were discussion focused sessions – a combination of presentation and Q&A session.

Guess what? It is a Microsoft exclusive event no longer!

We’re opening up the Chalk Talk sessions to community speakers. There’s a catch, though.

  • You are currently attending the PASS Community Summit.
  • You are not speaking at the PASS Community Summit.
  • You submitted a session to the PASS Community Summit that was not accepted.

That’s pretty stringent requirements. So, what do you get in return? Unfortunately, we can’t offer comp codes for this. But we’ve got something special in store.

Lightning Talks

Yeah, that’s right: Lightning Talks. We’re doing them at the Summit this year. Just in case you don’t know, a lightning talk is a short, prepared talk. We’re going to aim for 5 minute talks. That should keep things moving quickly.

We like this idea so much that we’ve dedicated one session every day to nothing but lightning talks!

All of the details aren’t finalized yet, but we’ll keep you posted.

How Does This Help You?

If you’re not going to get a comp code (BOO!), how does giving a Chalk Talk help you?

1) You get exposure – You can put on your speaker resume that you spoke at the PASS Summit.
2) You get exposure – You’ll be presenting a lightning talk with other speakers and it will be witnessed by a boatload of people.
3) You get exposure – see points 1 & 2

Should I Submit the Same Abstract?

I would say “probably not.” Chalk Talks are a different format than a standard 75 minute session. They’re shorter (only 40 minutes) and they involve more audience participation (a lot more). Feel free to submit similar topics, but be prepared for a different audience and delivery.

We’ll be pushing out an official announcement soon. Stay tuned!

Things I Read This Week – 2010.08.03

Just in case you want to live vicariously through my reading choices, here are some of the things that I found interesting this week when I should have been doing my job.

Data

An Illustrated Guide to the PostgreSQL Buffer Cache – Just in case you were wondering how a buffer cache works in a database. Because, you know… it’s cool. For you SQL Server people out there, this is conceptually identical to how buffer pool scans work in SQL Server. I suspect this is the same everywhere and probably based on an obscure academic paper.

Inside the Optimizer: Plan Costing – The SQL Server optimizer is an interesting creature. You can’t see what it’s doing directly because it’s full of patents and secrets (and probably dragons). Paul White (blog | twitter) has been doing a phenomenal job recently of taking apart the optimizer step by step and showing how it works.

The problems with ACID and how to fix them without going NoSQL – You know all of those reasons your developers are giving you to abandon SQL Server for a NoSQL database? This guy claims to have the answer. It boils down to using stronger ACID compliance and sounds suspiciously like Postgre-XC. If you don’t want to read several lengthy academic papers (really? you don’t want to?), the basic premise is that we should use stronger ACID controls by strengthening isolation levels and making the database deterministic such that the outcome of three transactions (A, B, and C) on all nodes will be the same regardless of execution order.

Using Riak’s map/reduce for sorting – Many NoSQL databases use something similar to MapReduce instead of SQL. The magic of map/reduce isn’t always apparent (it isn’t always apparent to me, that’s for sure). This article gives a well-commented example of the code you would use to write an ORDER BY date DESC query.

Configuring Mongo Replica Sets – Kristina Chodorow covers how you would set up Replica Sets to eliminate any single point of failure in MongoDB. Good to know ;)

10 things you should know about about NoSQL databases

Code

RubyDoc.info – I haven’t really been reading this one so much as I am amazed by it. RubyDoc.info combs the Ruby source code in a few locations and dynamically generates up to the second documentation based on the current stable versions of libraries. Go go magic clouds!

TextMate’s Missing Drawer – Mac fiends, take note! I’ve always thought TextMate’s project drawer was a bit lacking. This really improves on the built in drawer and integrates it a lot better into the application. (Found via The Hidden Magic of TextMate.)

Other Stuff

The Importance of a Mentor – My good friend, and long time unknowing mentor, Jonathan Kehayias talks about the importance of having a mentor. Take some time and thank the people who have mentored you throughout your career.

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.

Turtles All The Way Down

This has nothing to do with turtles. Just in case you didn’t figure it out, I wanted to make that clear. However, I am really excited to announce that I’m joining Quest Software as a Database Expert. My official job title is still up in the air, but let’s talk a little bit about what I’m going to be doing.

I’m going to stay involved in the community. That’s a big one right there. I’m still going to be on the Board of Directors for PASS. I’m still going to run my local user group (until we have elections and I’m voted off the island). I’m still going to speak at SQL Saturdays and the like. I’m still going to blog about all the crazy messed up things that I do with data. (Have I mentioned that I really like data?)

I’m going to keep solving problems. One of the things that I enjoyed the most about the last two years at Cass Information Systems is that I wasn’t just a DBA. I worked with a great team of developers to solve a variety of problems. Some days I sat in on meetings with them to just give advice based on prior experience. Some days I would be tuning T-SQL. Some days I would be working to help design the optimal solution to a problem using a combination of C# and T-SQL. Solving problems is something that I love. I never want to stop doing it. In fact, I made things change because of the problems that I would be able to solve; these are problems that have been running through my head for a long time.

I love code. I really mean it – I love writing code. There’s nothing like opening up an editor and whipping up some code to solve a problem. I wanted to download a bunch of PDFs, I figured out how. This new position means that I’ll have the opportunity to combine the things that I love – community, problem solving, code, and data – to do some really cool things.

I should stop bolding the first sentence of every paragraph, shouldn’t I?

Let’s make this a bit freaky for you: I’m not going to be working exclusively with SQL Server. In fact, I’m not even going to be working exclusively with RDBMSes.

Did you guess it yet? That’s right: I’m going to be working with cloud databases and NoSQL.

Since you’re reading this right now, you’ve probably noticed that I’ve been writing a lot about MongoDB, other NoSQL databases, as well as PostgreSQL lately. I’m exploring the world around me and writing about what I’m finding out. This is an amazing time to be looking at different ways to store data. I’m incredibly excited by all of this new technology. People notice that.

You too can have fabulous prizes. A lot of people have said it before. Hell, I’m going to be saying it this Saturday in Nashville: show your passion. People notice it. Even if that passion leads you away from the fold, follow it. When you write and speak with passion, people will take notice. When you share what you’ve learned with passion, people will take notice.

I didn’t respond to an ad on craigslist. I’d like to think that this opportunity came about because of the time I spend with you, the community, the time I spend blogging, and the time I spend presenting. These are all things that I love doing and now I’m going to be paid to do them. I’m not sure it gets any better than this….

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.