A community of more than 1,600,000 database professionals and growing
The Voice of the DBA
Hiring good people is hard, though in some cases it might not matter as much as others. If I am hiring entry level developers or DBAs, I have a lot of candidates, I'm not investing a lot, and I shouldn't be too concerned if I have to let someone go and find a new employee. Given the fact that the people are often unproven in this case by definition (they're junior levels), I should be prepared as a manager to make more mistakes at this level.
However at the senior level, hiring needs to be done more carefully. The high costs, the limited number of candidates, the responsibilities I give senior people, along with the trust I need to bestow upon them means that I can't afford to make the same percentage of mistakes at the senior level. Most importantly, I don't want to hire expert beginners instead of experts at this level.
I ran across a post on a way to hire senior developers that I thought was very interesting. In particular, I was struck by the analogy of hiring a guitar player. For the most part, I'd agree that if I wanted an experienced guitar player, I'd want the expert, not the expert beginner. If for no other reason than I don't want to argue with an employee that does things my way, including making the same mistakes I'd make, and then explaining to me this is how I had specified things to be. I want a senior people to warn me, and influence me to do better.
I'm not sure how I'd devise a similar level of test for a senior level DBA, though I do like the idea of giving them some scenario or simulation that has flaws or problems and seeing if they'd correct them, point them out, or leave them in place as they moved on to "play" the scenario. I'm sure there's a way to do this, and a balance between how to evaluate the responses.
Ultimately I want senior people to fix things, make them better, and provide a smooth path to increase quality. I want them to point out flaws, and warn me about issues. If I insist on making poor choices, I want their support, but if they can influence me to do better, I'd prefer they did. That's one mark of a senior person.
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.
Have you got your 5GB free hosted storage yet?
Back up your SQL databases to the cloud using SQL Backup Pro. You’ll get your first 5GB of storage free. Try it now
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.
Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.
- Hi friends,
Our database server(windows 2008R2 4GB 64-bit) goes up to 98% physical memory and about 3.5G from sqlservr.exe. Max...
linked server issue
Can anybody advise on the following error :
[quote]OLE DB provider "SQLNCLI10" for linked server "server1" returned message "The partner transaction...
Updating SQL table using SSRS
- Hi everyone
I have the following table in sql server:
CREATE TABLE [DBO].[SHIFTS]
[WEEK_ENDING] DATETIME NULL
,[FORENAME] VARCHAR(50) NOT NULL
,[SURNAME] VARCHAR(50) NOT...
How to update Flag for maximum amount in a a group
Create Table #Temp
Pk_Id Int Identity(1,1),
Insert Into #Temp(Lnno,Amount)
Select * from #Temp
My requirement is,I want to update Flag...
Has anyone ever had to reverse engineer a schema diagram from a database before? If so, what tool did...
- i would like to find the above details
DB names, last backup finished date , backup size of all the databases...
Need a Subquery to delete the previous dates
- I have created one table like below
create table Verification(id int,date datetime)
inserted values like
insert into Verification values(1,'2013-07-10 03:12:05.397')
insert into Verification values(1,'2013-07-09...
Sorting based on user input..
I have one requirement and need help.
I have a table:
CREATE TABLE MiscItems(ID INT, Description VARCHAR(50), DisplayOrder SMALLINT)
INSERT INTO MiscItems(ID,Description,DisplayOrder)
- Hi everyone,
I have problem with rounding. There is a table
CREATE TABLE [dbo].[Fin3PaymentDisb](
[PaymentID] [bigint] NOT NULL,
[Currency] [char](3) NOT NULL,
[Amount] [money] NOT...
What was erroe in my code?
- Hai friends,
i ve the table like
create table users
users_id varchar(10) primarykey,
insert into users('001','A','ra@123')
We've all seen it ...
- OK folks. You've seen me (and many others) use Tally tables often enough.
You generate a ROW_NUMBER() and you don't care...
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.