| A community of more than 1,600,000 database professionals and growing |
| | Hiring Guitarists This editorial was originally published on July 1, 2013. It is being re-run as Steve is on vacation. 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. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free |
| | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | | Additional Articles from MSSQLTips.com Although most of what you read tells you to stay away from dynamic SQL, the reality is there are places where writing T-SQL code dynamically just makes sense. The one downside to dynamic SQL is that if it is not written correctly the code will fail. Eli Leiba shares a function that he created to help determine if the dynamic code is OK prior to execution. More » |
| Usually, when coding SQL, you will want to go along with the coding style of the team you are working with. This article shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease. More » |
| Guy Glantser from SQLServerCentral Blogs Today (July 26) I presented an online session with the title “Working with Very Large Tables Like a Pro in... More » |
| Vivek Johari from SQLServerCentral Blogs Introduction In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large... More » |
|
|
| | Today's Question (by Steve Jones): I want to run a script with SQLCMD against my instance. However, I want the output to include the script commands being run. What command should I use? |
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: SQLCMD. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
ADVERTISEMENT | The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I want to determine if ANSI PADDING is turned on or off in my database. Which code should I run? Answer: SELECT DatabasePropertyex(DB_NAME(), 'IsAnsiPaddingEnabled') Explanation: The DatabasePropertyEX() function is used, and must include the database name (db_name() gets the current database) and the property value to check is "IsAnsiPaddingEnabled". Ref: DatabasePropertyEX() - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| |
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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. | This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|