Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Is Your Time "Free"?

We do a lot of research at Redgate Software, often contacting customers or Ambassadors and asking questions, getting feedback, and listening to their challenges or criticisms. We take that information and it helps guide us when we build the tools that help you in your job.

Recently, I watched a call with a customer who uses our famous Toolbelt in their job and has for years. In this case, the call was about the value of Flyway and how that might fit in their organization. The person performed a lot of manual work to deploy code changes, and could see the way in which Flyway helps, but wasn't interested in saving time.

They saw their time as free. I assume their employer felt that way as well.

In my three decades of working in technology, I've seen a lot of employees and their management think of their time as free. Management has been happy to have tech workers stay longer at their desk to get things done. How many of you have had to deploy code on nights or weekends?

Perhaps a better question is how many of you have been happy to work nights or weekends? I've seen no shortage of IT people volunteer their efforts to work longer or out of hours to get something done. It's a point of pride or a badge of honor to spend lots of hours working. I know I've felt that way in the past. I'm both proud of working 100 hours a week to support a system (for multiple weeks) and saddened that I did that.

I did learn that wanting to overwork myself was a poor idea after spending a year with a blanket and pillow in my desk. I worked overnight or late into the night too many times across a year and eventually decided to look for a new job when I realized that neither my employer nor I was valuing my time.

Many tech people are on salary, which makes it very easy for management to request (or demand) extra hours spent to meet a deadline or minimize the impact on other users who work "normal" hours. This happens to other professionals (doctors, lawyers, etc.), but I'm not sure that's a good thing.

Working long hours, especially during stressful situations, can teach you a lot. It's an opportunity to grow and improve your career, but it has lots of downsides. Burnout, mistakes, unhappiness and other negative factors can impact your life and work over time. You ought to value your time, and your employer ought to as well. I learned this when a coworker told our boss he was working the problem until 5 and then needed to leave for a family event. He could work later or come in early the next day, but not everyone needed to stay all evening tonight, and he wasn't going to do so.

Learn to be more efficient, whether that's in the work you do, or the people you manage. Learning to save time, use tools, share knowledge, and smooth your processes will build a stronger team over time. People will be more focused, more knowledgeable, and able to get more done in less time.

Invest in things that save time. It's the one resource we can't get more of, no matter how much we push on people.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Using PostgreSQL as a NoSQL Store and a Search Engine

sabyda from SQLServerCentral

Introduction We mostly get inclined to use/introduce MongoDB for JSON storing/processing in our database system and Elasticsearch for searching operations in JSON data. However, what we often tend to overlook is that in reality, PostgreSQL can actually act as both NoSQL store and a powerful search engine too. It also comes with ACID guarantees, transactions, […]

External Article

What’s New in SSIS 2025?

Additional Articles from MSSQLTips.com

There’s a new version of SQL Server released and we’re mainly an on-premises SQL Server shop. We’ve been using Integration Services (SSIS) for years now for all our ETL and data integration needs. With Microsoft’s focus on cloud (Azure and Fabric), does it make sense to upgrade our SSIS packages? Are there any new features?

Blog Post

From the SQL Server Central Blogs - EightKB 2026

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

EightKB is back again for 2026! The biggest online SQL Server internals conference is back…it’s all happening on August the 20th! We’ve open our call for speakers, you can...

Blog Post

From the SQL Server Central Blogs - AI: Blog a Day – Day 6: Embeddings – How AI Understands

Vinay Thankur from Vinay Thakur

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now Day 6 is inside of AI , how AI understand us, as computer do not...

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Site Owners from SQLServerCentral

A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Identities and Sequences II

In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Historical Data Tracking

If I want to track historical data values, which mechanism should I use?

Answer: Only Change Data Capture (CDC) does this

Explanation: Only CDC does this. Ref: CDC And CT Feature Differences - https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server?view=sql-server-ver17

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 2019 - Development
String_agg not working as needed - I'm trying to get this string_agg to put all the 'comments' into one result field like instead of: 433    2018-11-06 11:08:12.793     Customer called 433     2018-11-06 11:08:12.793     Customer left message This is needed: 433    2018-11-06 11:08:12.793     Customer called, Customer left message Any ideas?: WITH MaxCommentCTE AS ( SELECT DISTINCT client_id […]
query to track time spent on individual tasks in SSIS - Hi everyone I am looking at building a query to determine how much time is being spent on each task in SSIS.  My SSIS package has a few containers and within each container there are tasks.  Once one container finishes processing then the next container gets processed.  I have never done this before so I […]
Editorials
Doing the Little Things - Comments posted to this topic are about the item Doing the Little Things
Everything is the right question away - Comments posted to this topic are about the item Everything is the right question away
Hidden Heroes - Comments posted to this topic are about the item Hidden Heroes
Changing Data Types - Comments posted to this topic are about the item Changing Data Types
Article Discussions by Author
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform - Comments posted to this topic are about the item Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform - Comments posted to this topic are about the item Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Historical Data Tracking - Comments posted to this topic are about the item Historical Data Tracking
Vectors in SQL Server 2025 - Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences - Comments posted to this topic are about the item Odd Sequences
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database - Comments posted to this topic are about the item SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Identities and Sequences I - Comments posted to this topic are about the item Identities and Sequences I
Fun with JSON II - Comments posted to this topic are about the item Fun with JSON II
SQL Server 2022 - Development
VS Code, Unresolved References. - Hi all, I just started using VS Code to work with DB projects.  I have a work-in-progress DB, meaning some of the objects are broken.  But, for those that are not broken, when I run dotnet build I get many unresolved reference errors that have no problem existing on the server or in SSMS.  The […]
 

 

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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