Voice of the DBA

Tag: career2

  • The Ultimate Tool List

    I’ve seen Scott Hanselman’s Ultimate Tool List a few times and adopted some of the tools in the past. He updated it for 2014 and has added quite a few new tools. I downloaded F.lux the other day and am giving it a test run right now. I’m not sure how well it works, but I like the idea of this little utility. I also used Chocolatey for my new machine after Troy Hunt blogged about the utility and thought it was amazing. AutoHotKey is the new items I’m testing.

    We are in the business of technology and using computers to work more efficiently. We manage, build, and deploy software that allows our organizations to get more work done with less resources than ever in the past. We have, or should have, utilities that automatically check our math, our spelling, that communicate quicker than in the past.

    Those of us working with computers should be using utilities, tools, and helpful software all the time. We should test it, share our thoughts and results, and help others to learn to let computers improve their lives. While there are places computers aren’t needed or aren’t appropriate, there are many more ways in which computers can help us save time and effort by tackling tasks, even simple ones, with automation.

    I’d encourage you to look at some of the tools on Scott’s list and see if they might help you work more efficiently in the new year. With the slower times that usually occur during the holidays, this is a good time to experiment with some utilities that might help you in the new year. There’s also a SQL Performance Tool collection from MSDN in this week’s newsletter.

  • It’s not the platform

    I agree with Brent. Actually, I’ve felt this way for years when I’ve been asked the SQL Server v Oracle question, or even earlier in my career when I was asked about Windows v Unix. The choice doesn’t matter that much and it’s not really the platform; it’s the people.

    Oracle is often seen as the top platform in our industry for handling relational data, but if you give a copy of Oracle 12C to many of the SQL Server staffs that read this newsletter, and it likely won’t scale too well. At least not until they learn a bit about how the platform works. The same is true of SQL Server, which is often given to many under-trained and under-qualified people with the idea that they’ll just make it work.

    We should all be aware that while platforms can be expensive, they really pale in comparison to the cost of the people that will build software on the platform. You certainly might save money with a cheaper platform if you’re buying software, but don’t forget that additional platforms do need additional training for your staff. As I told a friend recently, anyone can setup SQL Server and get it to run. Until it doesn’t.

    Education and investment in knowledge is one of the most important areas that technologies and their employers can spend time and money on. However, it takes both of them working together to ensure it pays off.

    Steve Jones

    Video and Audio versions

    Today’s podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

    Follow Steve Jones on Twitter to find links and database related items and announcements.
    Steve Jones Windows Media Video ( 13.1MB) feedMP4 iPod Video ( 15.5MB) feed

    MP3 Audio ( 3.3MB) feed

    Feeds are available at iTunes and Mevio

    To submit an article, rant or editorial,
    log in to the Contribution Center

  • How Do You Find a DBA?

    This editorial was originally published on May 11, 2009. It is being re-run as Steve is on vacation.

    You’d think it would be easy, but I saw this post about looking for a DBA and I can certainly appreciate the problem. I’ve been in the situation of looking for someone to hire and getting hundreds of resumes for a position. In that case, I hate to say it, but I’ve sometimes only looked at the first 40 or 50 resumes I receive, sending the rest to a circular file. That’s not the way to find the “best” person for the job, whatever that means, but it certainly means that the early bird has a chance at the worm.

    But where is a good place to look? That really depends on where DBAs go to look for jobs, so where do you look?

    In the past, when I was looking for a job, I used Monster and Dice, getting slightly different results from each. There were a few other sites I tried, but I’m not sure that any of these other sites do a better job of listing jobs. Since you need to have a lot of jobs and traffic to be useful, the larger the site the better. Also it seems that many consulting companies or recruiters post jobs to multiple sites (usually Monster and Dice), so I’m not sure you can find more jobs on any one site over another.

    Today, however, I think I’d take a different approach to looking for a job, using the people I know, or my network, to see what’s available. If I were hiring someone, I think I’d do the same thing. I posted in the thread that using your local user group, the people you know, contacts on LinkedIn, Facebook, etc. to post the job and let those people pre-filter for you, might be the best solution.

    Hiring someone and finding a good employee is a hit and miss affair. I’m sure most people wish they had a better process, and a better way to evaluate someone’s skills. I think by looking for recommendations from people, people that you will see again, you have a better chance of finding someone that fits the position.

    Steve Jones

    The Voice of the DBA Podcasts

    Everyday Jones

    The podcast feeds are available atsqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

    You can also follow Steve Jones on Twitter:

    Overall RSS Feed:  or now on iTunes! 

    Today’s podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Powershell in a Month – Day 6 The Pipeline

    This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

    Day 6. This is where I found the idea of Powershell getting interested. I used pipes extensively back in my Unix and DOS days, and have heard that these are important in powershell.

    The pipeline (|) essentially takes the output of the left command and sends it to the right. The first examples are with exporting data, such as:

    Get-Service | Export-CSV services.csv

    This command would run the Get-Service command to get a list of services, then send that output to the Export-CSV command, which would create a file, format the data in CSV format, and send all the data from the Get-Service command into the file. Simple, easy and it makes sense. There are also Export-CliXML, -FormatData, etc. commands. On my system I even have an Export-VM  command for Hyper-V. I can start to see possibilities.

    This is different from the redirector (>), which is essentially running the pipe to Out-File, a command to create a file. There are other Out-* commands that send data other places, like printers, the screen, etc. Why does it matter that you have these commands? Well, mainly because you might want to alter some parameters, like display width, encoding, etc. Having a real command build allows for parameters, and control, and thus, customization.

    Powershell is all about customization, and being able to repeat that process. This chapter gives the basics of controlling your flow out output, including to other commands. For example, one of the things the chapter has you do is

    Get-Process -name Notepad | Stop-Process

    A fancy way to kill a process. It does warn you not to forget the -name parameter, as that would be bad. I was tempted to try it on a VM, but I know what will happen, so I didn’t bother. For commands that might cause problems, the chapter goes over the -confirm and -whatif parameters, which, respectively, ask you questions to confirm your actions, and show you the action without performing it. The lab for the chapter has you dig into other parameters, like appending to files (noclobber) using the default regional settings (useculture) and changing the delimiter for export. I actually found these lab exercises to be slightly challenging, but also handy. I got to use the help system and proved to myself a bit that I’m learning how to use PoSh.

    Overall, no great leaps in knowledge here, but I find myself gaining some confidence that I understand how PoSh works, how to manipulate the environment a bit, and I can see the possibilities of using the pipeline to string commands together and manage more than a simple stream of output data.

    The next chapter looks at more involved strings of commands, and I’m looking forward to that one.