Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

The Cost of Employee Turnover

Sometime during the first 3-4 months of the pandemic, after offices all over the world closed, I thought that a lot of businesses would try to hold on to existing employees and minimize turnover. I also thought many employees would be nervous about changing jobs amid all the uncertainty.

That wasn't the case everywhere, and I was surprised at how much employee turnover occurred in many companies during 2020 and 2021. We had the Great Resignation, where talented employees (and some not-so-talented) found new employment with lots of remove flexibility. We typically have low turnover at Redgate, but more surprising to me was the number of people we've hired in the last two years.

Our gains come from losses elsewhere. It seems a lot of companies have had a bit of turnover, more than they liked.  The costs of replacing a staffer has climbed to an average of USD$57k, according to a recent poll of hiring managers. I'm sure this is a combination of the time and money spent on recruiters and interviews as well the lost productivity of having less people around.

For many of us working in technology, we realize that losing good people is a problem. Often we lose undocumented knowledge about our systems,  those shortcuts, checks, small tasks, not-so-obvious fixes, and more that make life easier. We can feel more stressed about additional work, or even the anticipated unknown challenges we might face. Moral, productivity, and motivation decrease, which creates a snowball effect. Everyone gets less done, which costs the organization more. Either lower revenue, more costs, or perhaps fewer services for those government or non-profit concerns.

With large tech companies letting lots of talented people go, I wonder if we'll see more competition in the employment market. For quite a few years there have been fewer workers than there are jobs. Perhaps that changes a bit in the future, though I still think there are not nearly enough talented workers for the positions open. Good for talented workers as they may have more choices, but also good for less talented workers when companies feel pressure to hire anyone.

Except, what I've seen in a lot of companies is that they don't want to hire anyone. Having a degree or cert isn't enough. Companies aren't going to hire you because you are Azure/AWS/etc. certified. They want tech skills and at least a few soft ones. That creates an even higher cost to fill positions, so maybe that USD$57k isn't a bad number.

To me, what this really means is that organizations ought to look at poor management, both middle and upper, and replace those people. That's the problem in many places, one that isn't easily fixed. Poor culture, micromanagement, lack of support, little-to-no psychological safety, and more contribute to poor retention.

Culture is important and building it is hard. While not everyone will have a great culture, many organizations can avoid a poor one by treating people fairly and ensuring management understands how to do that. If for no other reason than to avoid the high costs of replacing staff.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Dealing with Mutually Dependent Databases in Flyway

How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS.

Dealing with Cross-Server Database Dependencies in Flyway Projects

How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.

Introducing the MySQL common table expression

This article is part of Robert Sheldon's continuing series on Learning MySQL. To see all 11 items in the series, click here.

Azure Function and User Assigned Managed Identities

Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.

Administration of SQL Server

Considerations for Updated Statistics

From Callihan Data

Up-to-date statistics makes life easier for SQL Se...

Lesson Learned #265: Deadlock due to Non-Optimized Queries

From Azure Database Support Blog

Today, I worked on a performance case where our cu...

Lesson Learned #266: Avoiding duplicate statistics

From Azure Database Support Blog

Today, I worked on a service request that our cust...

SQL Server Errors 823, 824, or 825

From Steve Stedman

Errors 823, 834, and 825 are all related to I/O er...

Identify Unused Indexes across all Databases

From SQLServerCentral Blogs

I had a request regarding how to identify unused i...

Understanding SQL Server Hardware: Parallelism and CPU

From Erik Darling Data

+OK

Help! My tempdb is full and I can’t access SQL Server!

From SQLServerCentral Blogs

I got a call saying the database server is inacces...

Lesson Learned #268:Error occurred during the pre-login handshake-The semaphore timeout period

From Azure Database Support Blog

 

Azure Databricks, Spark and Snowflake

Somehow I like Snowflake more and more

From Sherpa of Data

It’s no secret that I like Snowflake. When I say like, I mean that I like some of the different ways that I can find data within other data....

Azure SQL Managed Instance

Setting up Row Level Security (RLS) on an Azure SQL DB/SQL MI by utilizing Azure AD groups

From Azure Database Support Blog

Scenario: We have 2 Azure AD groups (RLS_11 & ...

How to move Azure SQL managed instance cross subscriptions

From Azure Database Support Blog

We have recently received a few service requests f...

Career, Employment, and Certifications

Recommended certifications for Azure Databricks enthusiasts

From Kevin Chant

Reading Time: 3 minutes Since this is my first po...

Common DBA Interview Questions

From Steve Stedman

There are many different DBA (database administrat...

AZ-700 Designing and Implementing Microsoft Azure Networking Solutions

From The SQL Herald (Joey D'Antoni)

One of the fun parts of working for a small-ish Microsoft Partner is that you have to take a lot of exams. Some of which aren’t in your direct...

Announcing the 2023 Data Professional Salary Survey Results.

From Brent Ozar Unlimited

 

Computing in the Cloud (Azure, Google, AWS)

Azure SQL VM: Azure Backup & restore for SQL Server on Azure Virtual Machines [Ep.10] | Data Exposed

From Azure SQL

In the next episode in the Azure SQL VM series, jo...

DevOps and Continuous Delivery (CI/CD)

Database DevOps and Code management with PostgreSQL

From Software and Booz

For PGSQL Phriday #004, Hettie Dombrovskaya challe...

HA/DR/Always On/Clustering

Clusters Do Not Replace a Proper Backup and Restore Strategy

From SQLHA -- Allan Hirt

Features are great until they aren't. Understand w...

MDX/DAX

Why DAX Window Functions Are Important For Performance In Power BI DirectQuery Mode

From Chris Webb's BI Blog

DAX window functions can result in simpler, more e...

(Livestream Replay) [DAX] Window Functions & Tabular Editor 3 - with Daniel Otykier

From Havens Consulting

ABSTRACT The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX...

PowerPivot/PowerQuery/PowerBI

Introduction to Using URLs for Reports in Power BI!

From Havens Consulting

Video by: Reid HavensLearn how to add either dynam...

How to handle Aggregation tables with Averages in Power BI

From Guy in a Cube

Using Aggregation Tables in Power BI? Average calc...

Power Automate: Sending Emails As A Different User

From SQLServerCentral Blogs

A common frustration when sending emails from Powe...

Using Cognitive service for Translation in Power BI

From RADACAD

There is a possibility to call cognitive service f...

Power BI Licensing Ultimate Guide

From RADACAD

Licensing in Power BI comes with many options. Und...

Wait! Using a Power BI Date slicer, what are my dates when using between?

From Guy in a Cube

Struggling to get dates when using a between date ...

Normalize Repeated Data in Power BI reports and Charts with Power Query

From MSSQL Tips

Learn how to unpivot repeated data columns in a da...

Product Reviews and Articles

Installing Flyway Community on Windows

From SQLServerCentral Blogs

One of the things I’ve been trying to do is dig ...

Product Upgrades and Releases

SQL Server Diagnostic Information Queries for January 2023

From Glenn Berry

Introduction These are my SQL Server Diagnostic Information Queries for January 2023, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration...

R Language

Little useless-useful R functions – Mandelbrot set

From TomazTsql

The Mandelbrot set is a set of complex numbers �...

SQL Server News

Microsoft R Application Network retirement

From MS SQL Server Blog

 

SQL Server Security and Auditing

Setting up TDE

From SQLServerCentral Blogs

Transparent Data Encryption (TDE) is one of the ea...

Security News and Issues

CircleCI: Rotate Stored Secrets ASAP

From Dark Reading: Dark Reading News Analysis

DevOps platform warns customers of a "security inc...

Remote Vulnerabilities in Automobiles

From Schneier on Security

This group has found a ton of remote vulnerabilities in all sorts of automobiles. It’s enough to make you want to buy a car that is not Internet-connected. Unfortunately, that...

Software Development

Can your application handle all BIGINT values?

From Michael J. Swart

In the past I’ve written about monitoring identi...

T-SQL and Query Languages

Overview of the SQL Median function

From SQLShack

In this article, we will learn how to implement th...

How to Find Missing Rows in a Table

From Brent Ozar Unlimited

When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:...

Tech News

Amazon to Slash More Than 18,000 Jobs in Escalation of Cuts

From IT Pro - Microsoft Windows Information, Solutions, Tools

The cuts, which were previously thought to affect ...

Tools for Dev (SSMS, ADS, VS, etc.)

Troubleshooting Azure Data Studio

From Deb the DBA

The TL;DR version of what you’re about to read i...

 
RSS FeedTwitter
This email has been sent to {email}. 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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -