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

Carrots and Sticks

Often,  we work on projects that might span a significant amount of time. Weeks, months, even years can be devoted to working on one system, or the same system. We may find that our motivation rises and wanes at different times. We get excited and motivated to get things done, and also become discouraged or distracted when challenges arise. Not all of us, or not all the time, but it is hard to maintain a high level of productivity and motivation over time.

For managers, it can be a challenge to keep a team moving over time and focused on achieving goals. Life gets in the way, people take vacations, staff changes, and other things are all issues that can distract a team. Keeping a team focused and productive can be a challenge for many managers. Perhaps especially challenging when someone hasn't received enough training on how to manage and motivate others.

As tech workers, we could be motivated in a few ways. Perhaps there are goals, achievements, or rewards that spur us on to work harder. There could also be penalties or consequences if we don't get enough done. There is always the threat of termination, but in practice, I see this as a last resort. More likely are subtle punishments such as boring assignments, more on-call work, or perhaps difficulties in getting vacation approved.

As a worker, do you want more carrots or sticks? Is the possibility of a reward or the threat of punishment a bigger motivator?

I'd like to say that carrots motivate me more, but as I think about it, I'm not sure. The carrot has to be significant to get me to change how I work. I think the stick also has to be fairly severe to force a change, but I think I'm often more motivated by the negative side of things than the positive. I'm sure that's somehow from my childhood, but if I'm honest with myself, that's what gets me moving more quickly. Though if there is too much of a stick, I'm quick to look elsewhere.

What about you? Carrots or sticks?

Steve Jones - SSC Editor

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

 
 Featured Contents
Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth

Gail Shaw from SQLServerCentral.com

This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.

Technical Article

Enable TDE for Databases in a SQL Server AlwaysOn Availability Group

Additional Articles from SQLServerCentral

A customer has a database that is already set up in a SQL Server Availability Group. Since this database hosts sensitive data, there is a need to encrypt the primary and all secondary replicas of the data. In this article, we will walk through how this can be done.

From the SQL Server Central Blogs - SQL Server 2025: Not Just a Database; A Data Engine Reimagined

Chris Yates from The SQL Professor

Let us be honest; most database upgrades feel like a patchwork of performance tweaks and security updates. But SQL Server 2025? It is not just an upgrade. It is...

Blog Post

From the SQL Server Central Blogs - From AI to JSON: What’s New in SQL Server 2025 Data Types (With Scripts)

Rohit Garg from MSSQLFUN

Introduction SQL Server 2025 is a landmark release that redefines how developers and data professionals interact with data. With the rise of AI, unstructured data, and real-time analytics,...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

 Question of the Day

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

 

Determining the Updated Columns

I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge (
 CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName VARCHAR(40)
 , Address VARCHAR(20)
 , Address2 VARCHAR(20)
 , City VARCHAR(20)
 , CountryCode CHAR(3)
 , Postal VARCHAR(20)
 , creditlimit INT
 , discount numeric(4,2)
 , lastorderdate DATETIME
 , lastorderamount NUMERIC(10,2)
 , lastordercontact VARCHAR(20)
 , created DATETIME
 , modified DATETIME
 , modifiedby VARCHAR(20)
 , statusid INT
 , active BIT
 , customersize INT
 , primarysalesid INT)
 GO
If I want to detect that the creditlimit was updated, what IF statements should I use?

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)

Getting Azure SQL Database Permissions

When I run this on Azure SQL Database, what is returned?

SELECT * FROM sys.fn_builtin_permissions('Server') AS fbp

Answer: All the server level permissions that one would see on-premises

Explanation: This function returns all the permissions, even if they are not valid on the platform. This looks the same in Azure SQL Database as it does in SQL Server 2022 on premises. Ref: sys.fn_builtin_permissions - https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-builtin-permissions-transact-sql?view=sql-server-ver16

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
built in deadlock information capture - Hi, i cannot recall the object or even if it comes off the shelf but i once saw a tool in sql server where the competing tables etc involved in a deadlock are recorded.   I think you had to know a bit about the complicated looking test it provided but it was sweet.   my recollection […]
why do my advanced i/o column lengths on city keep changing - hi , every time i go back to an ssis pkg that is under construction, at least one column in a tsv needs to be reset in the advanced properties of the oledb source from 50 bytes to 256.  Even though last time i edited it,  i saved the pkg. why is that happening?   Today […]
Anything that is NOT about SQL!
NKTg Law on Varying Inertia – A Different Way to Think About Motion - Hi everyone, I’d like to share something from the science side of life rather than the SQL side. It’s called the NKTg Law on Varying Inertia. In classical mechanics, Newton’s laws describe how objects move under the influence of forces. But the NKTg Law takes a different angle: instead of focusing only on forces, it […]
Editorials
Storage Enhancements - Comments posted to this topic are about the item Storage Enhancements
Everyone Wants a Piece of the AI Pie - Comments posted to this topic are about the item Everyone Wants a Piece of the AI Pie
Critical Data and Insomnia - Comments posted to this topic are about the item Critical Data and Insomnia
Article Discussions by Author
How to create your custom GPT SQL Expert - Comments posted to this topic are about the item How to create your custom GPT SQL Expert
MongoDB and NodeJS in action - Comments posted to this topic are about the item MongoDB and NodeJS in action
Data recovery from an Index - Comments posted to this topic are about the item Data recovery from an Index
Working with Indexes on SSMS - Comments posted to this topic are about the item Working with Indexes on SSMS
SQL Server Threats - Comments posted to this topic are about the item SQL Server Threats
SQL Server Threats - Comments posted to this topic are about the item SQL Server Threats
SQL Server 2022 - Administration
Can a Database be in an AG and do log shipping at the same time? - Hello, I have a large database about 8 GB.  It is in an AG. I have three replicas (Replica1, Replica2 and Replica3) Replica1 is Primary and healthy Replica2 is Secondary and heathy Replica3 is Secondary and not healthy.   I need get Replica3 healthy again.  My thought was to wait until after the normal backup […]
SQL CAL based Licensing - Hi Folks, I am about to purchase SQL server licences and need your advice on the Device CAL model. I understand we have to pay for the server license and then as per device count. SO if we have  2 application servers , with each routing 5 client connections, do I have to pay for […]
SQL Server 2022 - Development
azure vm has to be rebooted more often than we'd like - Hi we're noticing this 2022 server gets into a funk now and then.   Specifically, i notice when i script existing tables to the clipboard etc it just hangs with that circle continuing to spin.    i notice that if i reboot, the problem goes away for a while.  does the community have a similar experience?  […]
 

 

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

 

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