This editorial was originally published on May 11, 2009. It is being re-run as Steve is on vacation.
How can you measure someone's skills? Is there a good way to actually assess how well a DBA or developer will do in your company? If you have one, there is some money to be made by passing the information along.
Traditional interviews where you ask lots of questions typically haven't necessarily proven to be a great way to do this. Some people give tests, but they often are thrown together, and might contain multiple choice answers to make them easy to grade. However the other day someone posted a technique they used that I liked.
This person suggested that a VM be configured with Windows and SQL Server and then with a certain number of things wrong with the install. Or at least things that would be seen as wrong in that particular environment. You then give it to a candidate and ask them to tell you what's wrong. You could let them work through it in a stream of consciousness way, telling you what was wrong as they found it. You could also give them some time, say an hour, and then come back and let them explain what is wrong.
Actually I'd recommend you give the candidate the choice since some people work better alone.
I've thought about asking them to accomplish certain tasks before, but after considering this technique, I like it a bit more. Just asking them "what's wrong?" or "what would you change?" is a good way to see how people think. Interacting with them, getting them to dig into a real system, is a great way to assess not only technical skills, but also some interaction. See how they debate, argue, or question a co-worker is important, at least it's important to me.
Is this is a better way to interview people and assess skills? Would you like to be interviewed like this? Maybe this would even be a fun competition at somewhere like the PASS Summit.
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.
I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.
Hate explaining your database in meetings?
SQL Doc quickly documents your entire database schema so that you can easily present it to others. "This tool is embarrassingly easy to use." David Hayden, DavidHayden.com. Download a free trial now.
Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…
The seven tools in the SQL DBA Bundle support your core SQL Server database administration tasks.
Understanding indexes and how they work can be complicated enough for a Jr. DBA, but throw in all the different options and properties and an index can soon be overwhelming. Brady Upton takes an introductory look at creating an index in SQL Server using SQL Server Management Studio. He explains what each index property is meant for and the various options presented. More »
Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter
Over the past few months, I’ve been doing a lot of work... More »
Question of the Day
Today's Question (by Ford Fairlane):
True or False: In SQL Server 2014 you have the ability to set the following off.
SET ANSI_NULLS OFF and ANSI_NULLS OFF database option
SET ANSI_PADDING OFF and ANSI_PADDING OFF database option
SET CONCAT_NULL_YIELDS_NULL OFF and CONCAT_NULL_YIELDS_NULL OFF database option
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: SQL Server 2014.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
Pick up your copy of this great book from MVP Glenn Berry at Amazon today.
Yesterday's Question of the Day
(by Steve Jacobs):
What is the resultset from the query below?
CREATE TABLE #temp ( a CHAR(1), b VARCHAR(10) );
INSERT INTO #temp
FROM ( SELECT a
) AS t1 PIVOT ( MAX(b) FOR b IN ( #temp ) ) AS t2
ORDER BY CASE WHEN a IS NULL THEN 1
DROP TABLE #temp;
This is a very simple example of "PIVOTING." I'm only selecting column a as my returned resultset and is in ascending order (by default) and of course, the pivot on the table itself via column 'b' (finding MAX 'b' value) to perform the aggregate. Please note the way I am ordering my NULL values.
Every time Microsoft releases an important security OS patch I have to apply the same to some 16 clusters (32 nodes), even thouhg I have order list to patch the servers it becomes somehow complex to log on each node and failover/failback the nodes or the cluster resource groups.
So that I wrote this script to interactively move the resource between cluster nodes, this has added the value of logging each step and also confirmation of what pieces need to go where.
This is how to do it:
1.- Create a file list called "clusterlist.txt" and place it in the same folder as the script is. This file should contain the clusters virtual names to work on.
2.- Please enable delegation execution by using the following command :
See screenshot below of illustrative issue when the previous feature is not enabled.
3.- Once CreSSP is enabled execute the script from powershell like:
powershell.exe -command ".\clustermove.ps1"
4.- It will read the list of clusters from the file, if this does not exists, will read the cluster list from the active directory. You need to have read permissios to browse cluster names, from your AD or network.
5.- Follow interactive instructions on moving resource groups between nodes.
Note : When the options of "move all resource groups at once", they will be moved to the next available node. When choosing a particular group, you will get the list of nodes available so that you can select where to put the resource.
- Can you please let me know what would be the right answer for the following?
1. What should be strategy...
Breaking 3NF to save a join - should I do it?
I have the following situation for my new Data Warehouse:
A table called ENTITY
CREATE TABLE Entity
ID int identity(1,1),
EntityType int not null,
Auditing Database usage
- I have a request to audit database usage. Database usage is defined as anytime someone accesses a database for anything,...
Problem with my procedure
- Hi Professional.
I have a procedure which creates a file with column headings like so
alter procedure [dbo].[extractnewheadings]
Declare @sCmd varchar(256)
Need to parse values from XML type into SQL View
I have a table (JatinApplication) which has a field (properties type NTEXT), which contains string like this:
<ResourceGroupSpec xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.municipalsoftware.com/AppSpec" version="0"...
i have a trandate and tranvalue,customer,product now i need to poulate a table with trandate,tranvalue(sales amount),customer,product,py_tranvalue and i need...
Expression --need 2 digit not 4
- I am trying to create an expression in ssis as follows:
"capp"+(DT_STR,4,1252) DatePart("yy",getdate()) +
Right("0" + (DT_STR,2,1252) DatePart("m",getdate()),2) +
Right("0" + (DT_STR,2,1252) DatePart("d",getdate()),2) + ".txt"
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.