A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

College Degrees Shouldn't Be Required for Tech Jobs

Today we have a guest editorial as Steve is out of the office.

The job and recruiting site, Glassdoor, recently compiled a list of companies that no longer require college degrees. The list includes Google, Apple, and IBM.

Some people feel that this shows a trend of companies lowering their hiring standards. I believe the opposite: this is a trend of companies improving, and potentially raising, their hiring standards.

I once consulted for a small company who had an open Senior Database Administrator position. They wanted to hire a non-remote worker in a region with a high cost of living, and they required several years of experience with a niche technology. Company policy required all full-time employees to hold a four-year degree, which could be in any subject area. The position had been open for six months. The hiring manager was frustrated that they couldn't find experienced candidates who met the other criteria. The manager eventually lowered their requirement regarding technical experience to fill the position.

The problem with this company's hiring model is that "having a degree" is an overly simplistic standard. It doesn't measure communication skills, critical thinking, and problem-solving skills. Having a degree may be an indication of a candidate's ability to complete a long-term project, but it gives little indication of how they worked with others, and if the experience bears any relationship to the job.

If a company wants to hire great people, it's in their interest to develop more sophisticated techniques in evaluating candidates. The company should document the skills they expect candidates to gain from earning a degree, then define ways to test for these skills and measure them. This empowers hiring teams be more granular about the exact traits that they are looking for, and to be fair about measuring candidates against these skills. It also helps a company maintain high standards for hiring without applying simplistic filters to the pool of talent.

Kendar from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

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

Database DevOps Demo Webinar

Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now

Featured Contents

Configuring Service Broker Architecture

Valerij Urban from SQLServerCentral.com

Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture. More »

Learn from DevOps experts at Redgate’s SQL in the City Summits this October

Make a plan to register for one of Redgate’s SQL in the City Summit’s this October, whether you choose to come to the bright lights of New York City, or want to be among the high rises in Canary Wharf, London, or overlooking the Millennium Park in Chicago. Now’s your time to make the step towards gaining the know-how you need to help you fully adopt DevOps in your organization. More »

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Additional Articles from Brent Ozar Unlimited Blog

Erik Darling dusts off his favorite archival-quality bloggers and books. More »

From the SQLServerCentral Blogs - FizzBuzz and Multiple Recursive Member CTEs

Bert Wagner from SQLServerCentral Blogs

Watch this week’s episode on YouTube. Last week I needed to write a recursive common table expression. I’ve written them before,... More »

From the SQLServerCentral Blogs - Rant: There Is No NoSQL Data Storage Engine

Grant Fritchey from SQLServerCentral Blogs

Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or... More »

Question of the Day

Today's Question (by kiran diamond):

I have this following code to check the given string a numeric value,

 DECLARE @STRING VARCHAR(20)  = ' 1234 ' SELECT CASE WHEN ISNUMERIC(@STRING) = 1 THEN 'NUMERIC' ELSE 'NON NUMERIC' END AS TEST

What is returned when we run the above query?

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.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

Prepare for Microsoft Exam 70-774 and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Get your copy today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Evgeny Garaev):

I want to create an index on a computed column so I will be able to query the orders using a predicate how many days ago they were placed. The OrderDate is the datetime type column. Can I create a following index in order to improve my query performance?

 ALTER TABLE dbo.Orders ADD DaysFromOrder AS datediff(dd, OrderDate, getdate()) PERSISTED; GO CREATE INDEX OrdersIX_DaysFromOrder ON dbo.Orders (DaysFromOrder);

Answer: Computed column 'DaysFromOrder' in table 'Orders' cannot be persisted

Explanation:

It will throw the error:

Computed column 'DaysFromOrder' in table 'Orders' cannot be persisted because the column is non-deterministic.

Ref: Indexes on Computed Columns - 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.

SQL Server 2017 : SQL Server 2017 - Administration

SQL Migration - I have a SQL Cluster with Multiple databases. some small and large spanning multiple NDF Files. My question is this. I...

SQL Server 2017 : SQL Server 2017 - Development

Automate date to always show current Tuesday - Hi Guys, At the moment I have to run the a query and manually change the date every Tuesday. So every...

SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation. - HI, I have an SSIS Package which goes to a website using http connection and gets a zip file and loads...

SQL Server 2016 : SQL Server 2016 - Administration

SQL 2016 SSRS Native Mode - Report Loading Time - We are running SQL 2016 SSRS in native mode using the web portal. If a user is part of the...

SSRS - There is a problem with this website's security certificate - I ran into issues when using the SSL Certificate for SSRS. The certificate is valid and have been issued by...

Hide schema from all users (except people with SA access) - Hi all I need to create a schema to store a set of tables but I don't want anyone (including those...

Mirroring Failover - I have question, Server A is mirrored to Server B when the failover is done server B would be principal and...

Always on Install - Hi I am following these notes for always on install and have some basic queries: http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/ For step 9 Click the Add… button

AlwaysOn Listener registering 2 DNS records - Hello We have a situation where we need to setup AlwaysOn configuration on 2 data centers When I create a Listener providing...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Query Layout - Could somebody check the uploaded photo of a screen print of a report I need to make? I've never made something...

DATALENGTH and LEN difference between NUMERIC(16,6) and NUMERIC(18,2) - Due to one of our customers request in the past, we used to keep financial information across our product in...

When is too many columns too many columns? - I know you can have some insane number of columns in SQL server... but just because you could, doesn't mean...

SQL Server 2014 : Administration - SQL Server 2014

Mirroring - Working on setting up SQL Server mirroring. Following are the steps I am thinking to do.. Take Full Backup and Transaction...

SQL Server 2012 : SQL 2012 - General

SQL jobs interfering with eachother - I have 2 sql jobs running daily (nightly) on the server. These are scheduled 1:30 hr/min apart. Both these jobs have...

Dilemma when refreshing UAT from Prod - Hi all, We have an automated job that kills all connections to a DB on UAT, restores a full backup...

Separating SSIS Datetime - Hi Experts, I have a text file to load to a database.The file has a column Datetime 2013-07-16 15:05:43 and in...

SQL Server 2012 : SQL Server 2012 - T-SQL

How to update a field with the result from a Query - Hi all! I have this query: SELECT Per.per_personal_id,EMP.vacation_model FROM dbo.personal PER JOIN dbo.employment EMP ON EMP.EmployeeID = PER.per_personal_id WHERE EMP.DATEFROM <= 79508 AND (EMP.DATETO = 0...

SQL Server 2008 : SQL Server 2008 - General

remove Identity from a column - Hi Dudes, I have a Table Which has a column that is set to identity by mistake and it is on...

Data Warehousing : Integration Services

Lookup Transformation NCHAR - Hi, I have this table CREATE

SQL Server 2005 : Development

Date formatting in a text string. - Hi All, I am not sure if I have put this in the correct section as am new to the...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

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.