No matter what you celebrate today, I hope you have a wonderful day.
Author: way0utwest
-
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
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! 
- Windows Media Podcast – 20.7MB WMV
- iPod Video Podcast – 21.7MB MP4
- MP3 Audio Podcast – 4.3MB
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.
- Windows Media Podcast – 20.7MB WMV
-
Quick Tips – SQL Prompt with SSF
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of the ways in which it can help you. This is a quick look at one of the ways I use SQL Prompt.
SSF
I probably type SSF more than any other character combination in SMSS. With SQL Prompt installed, I usually quickly type “SSF” and hit “tab” and get this:
SQL Prompt has expanded my “SSF” into “Select * From” and then popped up a list of tables in this database. I could down arrow to select one, or use the cursor, or start typing.
This is a quick way to get data from a table back to your SSMS client without worrying about the columns or rows you need from a table. I use this constantly, though I’ve edited this command to return the top 10 rows only. Here’s how I do that:
Snippet Manager
There’s a dialog for managing these snippets of code, called the Snippet Manager. You can access that from the SQL Prompt menu
Once you select this, you get a dialog that shows all the snippets installed on your system. I scrolled down to the “SSF” snippet that I often use.
If I click the Edit button, then I get a small editor where I can paste in code or edit what’s there. In this case, I add the “TOP 10” keywords, and I also reformat the code slightly. I like my code formatted, so I ensure it’s formatted here.
Once that’s done, I click “Save” and then “close” for the Snippet Manager. Then the next time I type “SSF” and tab, I get this:
Note that there is an st100 snippet that does the same thing I edited with 100 rows, but I find ssf easier to type, so I just edit this snippet.
I’d encourage you to play around with snippets, and also adopt this in your daily work. If you don’t have a copy of SQL Prompt, download the evaluation and I’m sure you’ll realize it’s worth the cost of the tool in time savings quickly.
-
Android is better than iOS
Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are a few things I do think.
If you’re slightly lost, I’ve written on Android v iOS after moving to a G4, my move back to iOS, and why I left. The other posts in this series are:
It’s been a couple weeks that I’ve been back on iOS. It’s an adjustment, partially because it’s iOS7, and partially that things work differently. I made a few notes of the places where I find myself wishing that iOS had adopted a few things from Android.
Keyboard
The number one complaint I’ve had with iOS is the keyboard. Actually, I bet my wife would consider iOS again if the keyboard was replaceable. The iOS keyboard isn’t a great format, it isn’t customizable, and there’s no Swype. I could forgive the former, but the latter is handy, especially when you’re working one-handed, which I often am. I’m not sure if Apple will get Swype/SwiftKey/etc ever, but that ought to be a priority.
I will say that as I’ve moved to Chrome on iOS, I do appreciate the app showing the “:”, “.”, “-“, “.com” buttons above the keyboard. I wish that more apps might consider adding the “@” and “#” buttons to their keyboards. I use those often.
Update: I noticed the Echofon Twitter app does this.
Back
The back button, which was annoying and inconsistent at times in Android, was still useful. Often I find that I need to change a setting, or I click a link over to some other app and want to return to the previous application.
For example, I hit maps, enter an address, and it tells me I don’t have Location Services on (because that kills my battery). I click settings to turn on LS, and then I need to double click home and pick the previous application. I find myself looking for a back button. The same thing occurs if an email opens a browser link.
As much as the soft back button was a pain in Android, not having one is slightly a pain in iOS. Not a huge one, but it feels like an ommission.
GPS
I don’t use the GPS or Location Services often, mostly because it seems that iOS 7 has a battery drain issue with this. I have to say that having the ability in Android to turn this on/off from the notification window was really, really handy. While I have wi-fi, bluetooth, etc. in iOS, I don’t have GPS.
Android wins here.
Screen
I had a new Android, the Galaxy S4. The screen was amazing, and large. After a day with the S4, I thought the device was big. After a month, I never noticed it. In fact, when I looked at other phones, their screens were small. Going back to the iPhone 4S I was surprised, and still am, by how small the screen is. I’ve looked at a few other old phones I have and the iPhone has a larger screen, but after having the S4, I miss the larger screen. If the iPhone 6 does a wider screen, even if it’s the same height as the 5 series, I’ll upgrade ASAP. I would like a larger screen.
There are so many Android choices here with my kids having LG and HTC devices, that I feel a little left behind. Even my daughter’s 8X with WP8 is larger and nicer.
I know this isn’t an Android OS thing, but the choice and variety of the platform make it a reason I like Android more.
Networking
I don’t know if this is an iPhone issue, an iOS7 issue, or Android is better, but networking seems flakier. Both wi-fi and cellular find some gaps/pauses in how the device works. Coverage was better on Android for me, but that was newer hardware and the cellular radios are always improving. It isn’t horrible, but a few times a week it’s noticeable. I wish I hadn’t upgraded from iOS 6 to 7 as I’d like to know what the issue here is.
That’s It
I haven’t anything else that stands out. I wrote about a few of the reasons I switched and they’re still valid. Music is world class (including iTunes), the camera just works quicker and better. App quality is better overall, and I don’t have crashes. The lock screen runs fast, and I can search the phone instantly.
I have learned in iOS 7 I need to kill some apps at times, and that means the Task Manager and booting a few to protect my battery life at times, but I had to do that on Android.
Overall, I’m glad I switched back, though I do wish I had newer/faster/larger hardware running the OS.
