Get Inspired – SQL Inspire 2011 New York

Coming up next week is the SQL Inspire 2011 event in New York City. It’s an event with a number of SQL Server community speakers that are here to inspire you in your career, your life, and with SQL Server. The talks cover a variety of topics, and they look interesting. I am very excited to attend the event, and give my talk as well.

The event is from SQL People, the brainchild of Andy Leonard and Brian Moran, designed to build a stronger community by having us inspire each other. This event is based on the TED events, which are inspirational and informative talks that look to explore new ideas in a variety of topic areas. I have loved watching many of the talks, and while I’m not sure I’m up to the same level of presenting as many of these people, I’m going to try.

Please come if you are in New York on the 12th of November. It will be a lot of fun, and hopefully a very motivational event.

It’s Your Career

It’s your career. It’s something you have to take ownership of and work on. I know that life is busy, and training budgets are tight. That’s one reason we started SQL Saturday; it’s a way to bring a training event and a conference experience to many people.


I posted this tweet almost a year ago, seeing Brent in a class somewhere, learning and taking notes during some session. It was in humor, but I’m a little serious here. We all have more to learn, and while you don’t need to cram it all in this year, you should be taking advantage of your user group, local events, conferences, classes, even reading something in a newsletter on a regular basis.

Many of us are out here to help. I’ve spoken at 12 events this year, 10 of them free, and will be at another free event this week (SQL in the City – LA). However, you’ve got to make the effort to improve yourself. I , and many others, will try to help you, teach you, but you’ve got to do some work yourself.

Pace yourself, learn at a reasonable rate given the other responsibilities in your life, but don’t ignore this aspect of your career.

PS – If you’re in the LA area, there’s still time to register for SQL in the City and get a free day of training. I’ll also be at DevConnections next week and SQLInspire the week after that.

Build Your Own Event at the PASS Summit

There’s a bunch of stuff scheduled for the PASS Summit next week. You can see some of the events on the After Hours page, but there are a few other events happening during the week as well. Most are private, which is fine for the people that get invited, but what about everyone else?

There are well over 1,000 people coming to the Summit, and the majority of them won’t get invited to private vendor parties, or many other events. However outside of the Gameworks party on Thur night, I have a feeling many of them will end up being “that guy”, spending the evenings alone or even working.

Andy Warren and I have started a few events that are relatively open to anyone. We have our Monday Night Networking event, which is full right because of capacity limits. We also started the SQLServerCentral party, which I run and is open if you have a ticket.

However we think you can start your own event. If you want to go see a band in Seattle, then wouldn’t you want to see if anyone else wants to go with you? Maybe share a cab? Perhaps you’re interested in a workout at a local dojo, or you want to attend the Underground Tour (which is very cool).

If you want to do something, and would like to network, have a little company from people that similar interests, we’d like you to do two things:

  1. Create an event at EventBrite. It’s free if you aren’t charging. Just tell people what you event will cost and let them pay their own way. Put a limit on the number of guests, if it’s appropriate.
  2. Post your event at MVP/MCM Denny Cherry (blog | @mrdenny) has set up the site to track what’s happening at the Summit.


That’s it. Post your event and let people sign up.

If you are looking for something to do, check out the page at and see if there’s something you’re interested in. The site will tweet your event, but feel free to publicize it around.

A week at a conference should be a lot of fun, packed with plenty of events for everyone. I hope we can get people to build their own get togethers, for anything from tasting beer at the Tap House to dinner at The Cheesecake Factory to taking a tour of the Museum of Flight.

Whatever interests you, set something up or look for people that have a similar interest at

An Awesome Job

Life is awesome and if you can't see it, read this book.

I recently watched The 3 As of Awesome with my daughter and loved it. It’s a short talk (17 min) from Neil Pasricha, the author of the 1000 awesome things blog. The talk goes through a roller coaster of emotions, at least for me, with a pleasant start, a sad middle, and a positive end. There’s some humor in it, and I highly recommend you watch it.

When we finished, my daughter and I talked about what awesome thing had happened to each of us that day. She said that me giving her 5 extra minutes to play with a friend before we left was great. I told her the crazy, illegal, solo, 5 hit volleyball return I made at her practice that made everyone laugh was the highlight of my day. We challenged the rest of the family to find an awesome thing from that day, and everyone enjoyed it. Since then we’ve made it a point to regular ask what awesome thing happened to each other.

The philosophy espoused in the talk is one I try to follow. I stop and appreciate the cool, little things in my life. A refill of my drink when I’m flying economy class makes me smile. I get a good feeling when I can stop and hold the door for someone behind me. I appreciate the health I have, and the fact I can run regularly. A good cup of coffee, the cat wanting to snuggle up when I’m typing in bed, or the chance to step away from my desk and give my wife a kiss during the day are awesome and amazing things in my life.

Work isn’t always awesome, but I’d like to think that you find little things you can appreciate on a regular basis. Maybe it’s code you write that works. Maybe it’s the knowledge that you saved someone else time because of something you did. Maybe it’s that second monitor that lets the work flow a little smoother. Maybe it’s that burst of bandwidth that made a download smoother. Maybe it’s the comment someone made on SQLServerCentral or on Twitter that grew a smile on your face.

We spend a lot of time at work, and it’s often work. I hope you enjoy your job overall, but even when it’s not the job for you, hopefully you can find and appreciate some little thing that occurs every week that shows the universe likes you.

Steve Jones

The Voice of the DBA Podcasts

Networking for your career

The more I learn about building a better career, and the more I talk to people that get new jobs or have success in business, the more I believe that networking is one of the most important things you can do for your career. It just seems to work better, be more reliable, and more effective than any other career improvement strategy. Even blogging, which I think really helps, isn’t as effective as having someone that’s willing to recommend you.

I never really knew how to go about networking, but a few years ago I attended Don Gabor’s seminar at the PASS Summit and it was well worth my money. I learned a lot and have practiced some of his techniques since then. I’ve even purchased a few of his books, which contain even more information on how to better network and work with others.

If you’re attending the 2011 PASS Summit, you can see Don’s Networking to Build Business Contacts seminar on Tuesday, Oct 11, from 3-5pm. It doesn’t interfere with the other pre-cons, and if you’re going to be in town, take this seminar. You will learn some practical tips and exercises you can use to build more contacts, grow your network, and hopefully use it to advance your career at some point. Even if you don’t need a job, at some point you will and the time to build a network is before you need it. If you’ve already registered, call PASS to add this seminar to your registration, or do it on site.

Don has become a friend over the last few years, and was helpful in working on The Mentoring Experiment with me. I find him very insightful and experienced in the world of business and interpersonal interactions and a very interesting person. If you get the chance to sit and talk with Don, take it.

How do you learn the advanced stuff?

Advanced Study is hard, but worth it when you want to get better at something

I was talking with someone recently about features in SQL Server and they mentioned that partitioning was something DBAs should know. It’s only available in the Enterprise and Data Center editions for production use, but my friend noted that it works in Developer edition and felt there was no excuse for a DBA not being familiar with a feature that’s been out since SQL Server 2005, nearly four versions removed from its introduction.

I can understand that, but if you don’t have the ability to actually tune large data sets and see the impact of partitioning in a larger, production environment, it’s easy to dismiss this as a feature that doesn’t provide many benefits in a smaller situation. The same could be said for clustering, SSIS imports, or any number of features that aren’t often used. So how do you actually learn to get some experience with these features?

The first thing you need to do is get a copy of SQL Server Developer Edition and install it as a virtual machine on your primary computer. I use VMWare, but you could use Virtual PC, Hyper-V, or VirtualBox as well. The important thing to do is have a sandbox to play in and a machine you can easily copy, clone, or destroy as needed. I would recommend a base install of Windows and SQL Server DE, and then copy that for a machine you can experiment with.

One way to learn is duplicate the work that someone else has done. Make a copy of your virtual machine and then implement partitioning as described in an article. See if you can duplicate the way the author used the feature and get the same results. If you can’t, find out why, and if you can, experiment with the feature and try to improve the author’s implementation. The SQLServerCentral Stairway Series is a great way to do this in SSIS, SSRS, or other features that you may never have seen. Set aside an hour or two a week to learn some feature. After a month or two, you might be surprised what you’ve learned.

The most important is to understand how a feature works and gain some experience in using it. You might not become an expert, but being able to talk about the feature, and explain how you might use it in a situation comes from practice. That ability  might get you the project or job that allows you to become an expert over time.

Steve Jones

The Voice of the DBA Podcasts

Big Gaps

Emacs was my favorite editor in college

I saw this piece on Learning Unix from Miguel  de Icaza that brought back memories. Michael is a well known developer that is working an open source implementation of .NET called Mono. He worked at Microsoft and continues to bring .NET to other platforms, but he primarily works on Unix based systems. The post laments the lack of basic Unix knowledge and tricks from many of the developers he meets. His recommendation is a few books and tutorials to learn shell commands, emacs, and more.

Those bring back memories for me since I learned to use emacs early in college. I went through tutorial and enjoyed the editor much more than vi and learned to take advantage of shell commands for quick scripts or tools that would make my programming tasks easier. Those skills helped me when I moved to the DOS/Windows world and scripted many tasks, and even helped in SQL Server with the scripting tasks is SSIS and SQLCMD. As I look over PowerShell scripts these days, I find myself seeing the same constructs as I saw in Korn shell, but with different syntax.

As I read the piece, I asked myself a question over and over, which I couldn’t answer completely. I did, however think it would make a good Friday poll and decided to ask the rest of you for your opinion:

What basics do you find many data professionals lacking and what do you recommend to help them?

I know people need to learn how to back up a database, and they should learn T-SQL to some extent, but what basic skills would you point people towards? What books or resources would you recommend?

I know we have some great basic articles here at SQLServerCentral that everyone should read, like Managing Transaction Logs. I think we’ve tried to address the basics with the Stairway series on various topics. However I’m sure there are holes in our catalog as well as some very common things that many of you would like to recommend to every DBA or developer. You have your chance today to help compile a list.

Steve Jones

The Voice of the DBA Podcasts

Free as in Beer

My Favorite Beer

This editorial was originally published on Feb 7, 2006.

It’s amazing to me that someone can take the words from another and publish them as their own. I guess that’s why sites such as And why other sites like have sprung up to help combat that type of behavior. Actually if you want to get a great Christmas Present for your kid’s high school, get parents to raise money to subscribe to some plagiarism prevention service.

Actually a Google search on “essay help” turned up entirely too many places where you can get an essay written. Amazing how many of these tout their essays as “100% non plagiarized”. I guess if you hire writers to write something, but that’s a small step away from stealing someone else’s work for profit or gain. It’s just plain wrong to hire someone to do your work, as is starting to happen on Rent a Coder, where people are paying to get computer science assignments completed for them. There was a great Wall Street Journal article on this very topic.

And unfortunately, another article today from me on the same topic.

This is a great quote from the WSJ:

“This is a fairly simple program,” wrote “Goradia” of Sammamish, Wash. “It is my homework, but since I am busy, I want someone to do this for me.”

If it’s so simple, just do it. It’s your work, you are paying (in college) to learn, or investing in yourself in high school. Just do the work and accept the grade for your work. I cannot fathom why people do not want to earn their own accomplishments. I guess there always will be people that cheat, but it’s still amazing to me.

The only things you have in life are those that you earn and the mistakes you make. Enjoy them, relish them, learn from them, accept your failures and work to do better.

The Apprentice

Vader's Apprentice: Hope tech work isn't this hard.

It used to be that most serious developers went to college and studied CS. Those people that wanted to make a living programming computers became grounded in theory, struggled through assembler class, and understood the classic waterfall development technique. They could write bubble sorts and quick sorts, and could create and destroy pointers in thin air. At least in theory.

As computer science curriculums evolved, they became more practical. Students no longer had to learn C or emacs (a shame, IMHO), but learned Java and .NET, working in nicely crafted IDEs like the ones they would use in the corporate world. Practical programming classes allowed students to build more rich and interesting applications, instead of just building virtual linked lists that  weren’t visualized outside of one’s imagination.

At the same time, I’ve found that a larger and larger percentage of developers haven’t gone to college for a CS degree. Some have gotten other degrees, some just learned to program outside of school, and in both cases, they aren’t necessarily any better or worse than those developers with CS degrees. That leads me to this week’s question:

Should we move to vocational developer training?

We’ve asked the question before about whether a degree is required for a technology career, and I think most people agree it’s nice, but not necessary. However I’m wondering today if you think we ought to build better training for those people who are interested in computers, but don’t want to go to college (or can’t afford to). Should there be vocational schools that teach programming, maybe including apprenticeships with experienced professionals in the field.

I think there is a place for some formal training in development, preferably including some C programming, but I’m not sure that I think a four year college degree is needed. I’d like to see a more practical, more affordable way for people to get bootstrapped into technology and begin a career, preferably with some apprenticeships that might build practical experience and good habits among younger coders and DBAs.

Steve Jones

The Voice of the DBA Podcasts

Prepping for Certification

Having prepped for, taken, and then failed the MCM exam this year, perhaps I’m not the best person to give you advice for certification preparation. However the MCM is a hard test, I did better than I expected, and I was close. Lots of people haven’t passed it on their first try, including a couple people that work with SQL Server every day to build solutions that must work in the real world. A few of them passed on their second try, though I’m not sure if I’ll take it again anytime soon.

Recently I ran across this preparation post from Susan Ibach on MSDN. I think it’s good advice and if you follow it, you’ll be prepared for the exam. At least you’ll have a good idea on which general areas the exams focus on since there are %s given for each area. I’ve shown part of the SQL Server exam 70-450:


Note that this section, which includes security for the instance, database, schema, and encryption, is 15%. Since the exam is supposed to be around 50-60 questions, this means that you should get about 10 questions on security. You might get 8, you might get 12, but I wouldn’t expect to get 20.

I know most of you would like a step by step list of things to do for the exam. However these exams are going to test a wide variety of skills, and since 50 questions isn’t a lot, the exam can’t specify tightly which questions will be asked.

Sidebar: Personally I’d like to see more specific exams, perhaps as specific as security, replication, SSIS, etc., but lots of people don’t want to certify in all those areas. Plus it changes the profits for MS since they have more exams to administer. We’ll see if this changes in the future.

As a result you need to study a wide variety of materials. For example, for the security section above, you ought to tackle this in 5 sessions. Build yourself a short list of skills to have in each area. I’ll do section one for you. Here is what I’d go read about in BOL and practice in SSMS.

If you can explain each of these things to someone else, and perform the skills, you should be fine. I would recommend you blog or write about these, because that helps you to learn and remember this stuff. If you blog about them, ask a friend to look at your blog and see if you have correctly described things.

Once you think you’re OK with all the sections, not perfect and a guru, but you understand these areas, take the exam. If you want extra practice, get a MeasureUp or other practice test.

There’s no guarantee and you shouldn’t expect one. Go through the material, explain it back to yourself or someone else and you should be able to pass the test.