| A community of more than 1,600,000 database professionals and growing |
| | | Hiring Heterogeneously This editorial was originally published on Jul 22, 2013. It is being re-run as Steve is on vacation. I wrote recently about tech interviews and hiring, and even on an interesting interviewing technique for senior people. However we need to hire more than just senior people. We need to hire junior people, and intermediate people. Those roles are important for both growing the experience of your staff, and not getting caught with a "" as a bottleneck or single point of failure. No, that's not Brent Ozar, though someone with his talent might be the single point of failure in many organizations. Not everyone can be a superstar-expert-architect that decides how the system is built. Not all architects should spend time coding basic insert/update/delete code or adding clustered indexes to tables. We need a variety of talent levels that can get complete different types of tasks. There is tedious administrative work, supporting roles, necessary, though unexciting work like reviewing security, logs, audits, and more. While you can automate much of this busy work, there are still tasks that we must assign to people. There's another consideration as well in hiring that all too often people overlook. Hiring too many people that are too similar, who may think alike, who may view problems the same way can lead to an environment that doesn't grow and expand, that loses it's creativity over time. There's a great quote that says "Where all men think alike, no one thinks very much" (Walter Lippmann). It's important to have a diversity of opinions, and when you hire new people, you should consider this. You want talented people, and people that get along, but not necessarily all thinking about problems in the same way. The world is a richer place for the diversity we have, and varying opinions, thoughts and ideas. We don't all get along, but many of us can work together with mutual respect, considering each others' viewpoints as we work to build solutions to the problems we face. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | | | | Additional Articles from Brent Ozar Unlimited Blog Having already shown how to corrupt a database, and then how nonclustered indexes can be corrupted independently, in this post Brent Ozar explains how you can detect corruption. More » |
| | Steve Jones from SQLServerCentral Blogs I was building some code the other day and kept getting problems in my deployment for a change. The deployment... More » |
| | Cláudio Silva from SQLServerCentral Blogs On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the... More » |
|
|
| | | Today's Question (by Steve Jones): The EXTRACT expression has three different parts, designed to help you move data from unstructured data into some sort of schema. What comes first in this statement? |
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: U-SQL. 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 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?
Answer: sqlcmd -S .\SQL2016 -i test.sql -e Explanation: The -e parameter in SQLCMD will echo the input script to the output. This will work if you send output to the screen or a file (with either > or -o) Ref: SQLCMD - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Unable to connect to SQL 2008 Servers from SSMS 2017 - Servers are running on SQL 2008 on Windows 2003. Client from where I am trying to connect to those servers... SQL Server Multiple Databases Management Solution - Hi Senior DBA's. Do you know of a way to automate the below requirement to create a daily report ( on a... Evaluating use of InMemory tables... Why is it slower than temp tables? - I created a table like this CREATE TABLE blahblahblah( LeafLevelDatasetId INT NOT NULL IDENTITY(1, 1), DateKey INT NOT NULL, SafeRegionKey ... Difference in row-size between what was expected and what was — can anyone explain please? - Hi everybody, I am creating a table that will be the basis of a fact table for a cube. I... 70-461 exam - I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has nearly all the material... Replication subscriber log continuously growing - Hello SSC, I have a replication process running which is having problems with the Subscriber's log file (continues to grow non-stop). Setup/notes: -... Transaction log full error - The database is in simple mode and when I try to shrink the log USE db1 Login failed password did not match for SQL loin - Hi , I am getting error when i login SQL Server 2012 ' Login failed password did not match" buit i can... Trigger/Function - Hi, Im working in a small VB NET 2017 application with SQL Express 2012 database that will have max 5 users... Query performance tuning - taking more than 9 minutes - Below is one of the reporting query that is taking almost like more than 9 minutes to complete and as... Time increments - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00... Log file just doesn't shrink - Hi Everybody, Log file of one of our databases grows very high (now over 200 GB) . I have been shrinking it... 'Actual Rows' missing in query plans... - Hi Everyone, I extracted query plans for the currently running sessions , along with their wait types , SP's/Code/wait resource etc. The query plans... Partitioning Basics - Hi there I have a table with 33,112,015 rows, the main indexes are built on Year and Week, performance atm is... Combinations question with a twist - Hi all, Consider the data below, I need every combination that totals 130. So, 130, 55 + 75; 65 + 55 + 10, etc... Yes I... BCP upload from a txt file - Hi Guys, I an trying to do a simple upload from a txt file to a table. I know it should... Subroutines in TSQL - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should... (The device is not ready.) to SQL Server during a read at offset 0x00001573c00000 in file - Good morning Experts, Today morning when i came to office, i saw that a job failed because a database went to... How to get store procedure name from trigger - Hello. is possible to get the store procedure name from trigger when a update operation was performed? I need to... How to give Parameter value to the function - Input parameter is EmpID, it will be inserted from C# application. I am not sure on how to pass the paramter... |
|
| 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] |
|
|
