October 2009
Mon Tue Wed Thu Fri Sat Sun
« Sep   Nov »
 1234
567891011
12131415161718
19202122232425
262728293031  

Month October 2009

PASS Board Platform – Detailed Hoopla

PASS elections are just a few days away (from October 14th to October 20th). By now I hope that you’ve taken the time to read my, rather broad, position or Brent Ozar’s interview with me. If you haven’t, take a minute. I’ll still be here when you get back.

Now that you’ve read all of that, let’s move forward. A lot of that is pretty vague. One of my user group members pressed me for more details about what I would do if elected. Let’s just say that he was very insistent that I put my views online before the election.

My views boil down to three things: Knowledge. Growth. Connecting.

Knowledge

A Digression About Certifications in General

First off, let me say that I don’t think that PASS should get involved in the certification game. In the early days of the 21st century there were a number of Linux certifications available. Nobody knew which one was going to be the de facto certification at the time, so nobody got a Linux certification (well, nobody I knew got one). As a result of this cluttered marketplace, no certification had any value. Microsoft already produces certifications – they solicit feedback on how to make the process better. Rather than dilute certification market we should work with them to provide helpful, constructive feedback to make the certification process better.

That was all a sidebar. I’m not here to debate the merits and flaws of the Microsoft certification process. What I really feel strongly about is learning. More importantly, I feel that lasting learning is incredibly important.

Certification Guides

When I went out and took the exams for the MCITP: Database Developer certification, I used a certification guide. But what I found as I studied is that the guide taught me how to pass the exam. It wasn’t teaching me how to apply the exam concepts to the real world. Throughout the certification process, I ended up using the exam guide to guide my learning. I read Books Online about three times as much as I read the certification guide just to shore up the key points.

Most certification guides just prepare you for the exam. Frequently, they aren’t even useful as a reference once you’ve taken the exam. This isn’t to knock certification guides. They serve a purpose – to help you pass an exam. But what I’m getting at is that PASS is in a phenomenal position to create certification guides that meet the needs of database professionals – certification guides that teach the fundamental concepts in a real world context while they prepare you for the exam.

Training

How about training? How do you know that the person training you has any real world experience? How do you know that the person who wrote the training material has any real world experience? I’ve attended C++ programming classes taught by DB2 DBAs who were looking for some extra walking around money. There’s nothing wrong with that. But when you’re investing in your career, or the career of your employees, you want to make sure that there is some real world expertise behind that trainer and his training manual.

Building off of the certification guide idea, I would like to see PASS creating training material that is immediately valuable to community members. Training based on real world situations that has been written in direct response to community needs. If I want to know about the SQL CLR, I know who I would ask via email, IM, or twitter. But those people only have so much free time to answer questions before they’re overwhelmed. Now, if their combined wisdom were put into a training course based on real world usage of the SQL CLR that would do a much better job of training and educating community members than multiple email threads.

Growth

I’d love to see PASS grow. More importantly, though, I want to see the members of PASS grow. Personal and professional growth are key to being happy. How does PASS fit into this?

Speaking & Writing Mentors

PASS is full of the brightest database professionals in the industry. Every time I speak to a PASS member about SQL Server, I learn something new. They’ll smile and laugh while talking shop, but as soon as I ask them to share their ideas as an article or presentation a look of absolute horror crosses their face. Speaking and writing aren’t scary things, but many people are terrified to even try.

I want to create a group of speaking and writing mentors within PASS to work with people who want to get started sharing their expertise with the public. Of course, this isn’t just for people who have never written or presented before. Anyone who wants to improve their speaking and writing should feel free to take part and also to give back. We all have a great deal to offer each other why not take advantage of our collective skills?

Connecting

I’ve said it before and I will say it again – PASS is far more than just the Summit. PASS is a vibrant, global, organization with a wealth of knowledge and it is a shame that many of us only get a chance to share with our local community while we’re socializing at a meeting. Even then, we rarely get a chance to share with other people in our region unless we make a concerted effort to seek them out.

Local Conferences

I believe that it’s important to remember that PASS is more than a yearly international conference. It’s two yearly international conferences. No, that’s not right. PASS is a huge community. Even when you look at my home state of Ohio, there are three PASS chapters in state. That’s more than enough people to put on a regional conference and invite participants and speakers from the neighboring states.

PASS in a wonderful, vibrant community, but we need to build stronger connections locally and regionally if we want to increase the health of PASS as a global organization. Local and regional conferences will also help us grow personally and professionally. PASS members will have more opportunities to hone their speaking skills, network, and increase their knowledge and understanding of SQL Server. We will be able to attract members from the other technology communities and increase collaboration across industries.

Summary

As I said earlier, my views boil down to three things: Knowledge. Growth. Connecting. I believe we have a very strong community right now and that we can take PASS from simply being a great community to being the de facto source of SQL Server knowledge, training, and community.

Links for the Week of 2009.10.09

SQL Server

Why I prefer surrogate keys instead of natural keys in database design Mladen Prajdic put together a great article about using surrogate keys in database design. The best part is that a lot of bright people sounded off in the comments.

Donald Farmer Discusses the Benefits of Managed Self-Service BI I spoke with Donald Farmer about this topic when I was at the Richmond Code Camp last weekend. This is an incredible topic that has a lot of promise for the future of Business Intelligence.

Development

Mastering CSS Coding: Getting Started CSS is difficult to master. Very difficult to master. However, once you understand how CSS works it is a very powerful tool.

Multiple View Engines with MVC Turbine One of the coolest things about ASP.NET MVC is the flexibility it brings to ASP.NET web development. Javier Lozano demonstrates how it is possible to use multiple view engines within the same page.

Stuff & Things

9 Ways to Make Your Writing More Compelling 9 great tips for dramatically improving your writing.

Freelance Contracts: Dos and Don’ts If you’re looking to freelance, it’s important to make sure that your contracts are in order. This can cause no end of pain, trouble, and difficulty if your contracts are ambiguous. Smashing Magazine has some great information to make sure your contracts are in good working order.

Cyanide & Happiness

Pragmatic Thinking & Learning Reviewed

From the moment I started reading this book, I had a hard time putting it down. I read it far into the night. I read it waiting for oil changes, tattoos, and computer reboots. I re-read parts of it while I was still reading it. Needless to say, I thoroughly enjoyed this book and I took a lot away from it.

Overview

First of all, what is this book all about? After all, we all should know how to think and learn by now, right? Well, that’s the big kicker, as it turns out. A lot of the things we were taught about learning might have worked growing up. And a lot of that was wrong, too.

There are a lot of websites, blogs, books, magazines, articles, and wags out there who claim to have the secret to make you a more effective person if only you follow these ten guidelines. Pragmatic Thinking & Learning isn’t one of those books. It’s not a how to book. It’s not a tutorial or instruction manual. It’s a reference manual.

How Does it Work?

This book is endorsed by cheesy DBAs everywhere.

This book is endorsed by cheesy DBAs everywhere.

Pragmatic Thinking & Learning is based on copious amounts of research on learning backed up by real world results. This is more than one lone programmer’s ideas on how we should learn. It’s based on research across a number of fields – from nursing to the cognitive sciences – and references are provided to all of the source material. If you were so inclined, this would be a great introduction to a variety of theories.

One of the most important things that Pragmatic Thinking & Learning stresses is that, just like programming, we need to constantly be refactoring our thought processes. Instead of focusing on something that works, Andy Hunt stresses the importance of looking at how something works, why it works, and what could be going better. As much of the process of effective learning comes from unlearning bad habits while learning good ones. While many authors leave it at that and let the reader decide how to unlearn, Andy provides strategies, backed by research, to make change possible. He stresses the importance of engaging the whole brain and provides ways to do so. This book is chock full of exercises that are designed to get the reader geared up and refactoring their thought processes in no time.

Verdict

Pragmatic Thinking & Learning is a great book. It’s going on my shelf next to Getting Things Done and I plan on re-reading both books in six months to see what I’m doing wrong, what I’m doing right, and what I can be doing better. This book will be a distinct asset to re-working my process. I would recommend this book to anyone who wants to rethink how they’re doing things and thinks that there is a better way.

The First Ever Log Reader Awards

Starting today, and ending on Friday, October 16th, you can submit a blog post, or series of blog posts, to the 2009 Log Reader Awards.

What is it?

You’re probably asking yourself “What’s a Log Reader Award?” Well, dear reader, a Log Reader Award is an award created by bloggers (myself, Andy Warren, and Brent Ozar) to recognize other bloggers for their excellence in writing across a number of metrics including style and technical knowledge. (Ability to recognize an Oxford comma is a plus, but not required.) We realize that it’s important to recognize people of all skill levels and that what makes a great introduction to a topic is not the same thing that makes up a deep dive into a single feature of SQL Server.

To make this easier, there are multiple categories: Book Review, Business Intelligence, CLR, New Blog (less than one year old, at least one post a month), Professional Development, Series (Multiple Posts), Server Management & Automation, T-SQL, and Unusual (it’s great, you love it, but it doesn’t belong in a previous category).

How does it work?

Well, you go to the submission form and enter your details. On October 17th, we take your list of submissions and review them. Keep in mind, though, that we’re only going to review the last two posts you submit. This is how we’re going to stop you from voting Chicago style. Only posts that you’ve written between October 15th, 2008 and October 16th, 2009 are eligible. You can’t submit your doctoral thesis on relational design that you wrote 15 years ago. We’re looking for current articles from active bloggers.

Your RSS subscription will look like this

Your RSS subscription will look like this

What do you get?

The satisfaction of a job well done.

No, seriously, what’s the reward?

In addition to the satisfaction of a job well done, you will also receive the praise and admiration of your peers. We’re working on ways for award recipients to show off that they are an amazing blogger. Oh, and we’ll be announcing the winner at PASS. In front of people. So it won’t just be me telling the coat check crew about you… everyone will get to know how great you are!

Random Thoughts for Enjoying the PASS Summit

Have as many mobile devices with connectivity available as possible.
Have a camera ready and charged.
Charge everything every night. Even if it’s at 95% charge: charge it.
Pick sessions that challenge you.
Pick sessions you know nothing about.
Make back up plans for sessions you want to see, just in case.
Don’t make plans.
Be flexible.
Don’t trust the wi-fi.
Pack light.
Don’t be afraid to ask vendors for swag.
Drink water.
Walk everywhere.
Wear good socks.
Plan to be tired.
Take a backup.
Carry a pen and paper.
Carry a pencil.
Carry business cards.
Don’t carry books – they’re heavy.
Plan on 5 nines of uptime – you can sleep during the maintenance window.
Caffeine is your friend.
Drink water.
Be open to conversation.
Don’t be afraid to start a conversation.
Introduce yourself to everyone.
Don’t loiter – stand and talk instead.
Slide decks are downloadable; conversations aren’t.
Carry snacks.
See the city.
Take time to breathe.
Take time to sit.
Don’t be afraid.
Learn.

I started this in the comments on Colin Stasiuk’s post – 4 Weeks Away from the PASS Summit and thought I would continue it here.

Links for the week – 2009.10.02

SQL Server

Developers, use Profiler to profile yourself John Sterrett goes over how to use profiler to profile your own SSMS session.

Toys and Tools Mike Hillwig put together a list of great SQL Server tools.

The ABCs of Management Studio Shortcuts Glory be to keyboard shortcuts

Development

ASP.NET MVC 2 Preview 2 New MVC hotness has been released. Yes, it’s a preview, but this contains some interesting features. Better get it while the getting is good!

Stuff & Things

Google Search Options Offer More Recent, Personal Results Ever get really frustrated searching for something that you saw online? Ever know that the blog you’re looking for was written a week ago? Google’s new search options will let you narrow down your search with some particularly specific criteria.

Why Good Writing Matters – And How You Can Improve Good writing is incredibly important. There’s a reason why I spent four years of my life studying writing: I knew that learning how to communicate effectively was important and that I could learn most skills (apart from rocket surgery) on the job.

29 ways to ingrain a behavior Forming habits is difficult. Especially when you’re trying to build new habits and get rid of old ones. 29 tips to help you change.

MVP This!

I found out this morning that I am a SQL Server MVP. Well, I’m assuming that I’m a SQL Server MVP since that’s pretty much all I blog about. I actually found out via twitter when fellow inductee Brent Ozar re-tweeted Suzanna Moran.

It's for reals, yo!

It's for reals, yo!

There’s a lot I could say about this, but most of it would be babbling. In the end, here’s what I’ve got:

The last year and a bit of my life has been phenomenal. I got my first professional certifications, attended the PASS Summit, became a full time SQL Server developer, started a local PASS chapter, took over the Application Development virtual chapter, presented at several user groups and code camps, accepted as an alternate speaker at the PASS Summit, and was asked by Jonathan Kehayias to co-author a book about SQL Server.

So, thanks to you, members of the community. You make all of this so much fun to do on a daily basis. (“This” being any value of “this” that involves helping out community but not sending bacon to members of the community.) Seriously, everyone at PASS, Microsoft, bloggers, forum people, and twitter addicts, you guys make this

Second, I want to thank both my employer, HMB Information System Developers, and my clients for your support, tolerance, and patience. I’m grateful for your support of my efforts serving the developer/DBA community, your tolerance of the occasional distraction, and being patient when I spazz out about something amazing going on in the SQL Server community. Seriously, your support makes coming to work even more fun. Thank you.

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.