SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

What motivates you to do your best?

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

I would guess many of you have heard of the stick and the carrot.  They symbolize two main ways people are motivated by others.  The stick is the threat of some sort of punishment, it could be as simple as a verbal reprimand, all the way to getting fired.  The carrot is something positive, usually praise or money or a raise/promotion.  I believe these are ways to motivate people to do work, but I doubt they help anyone do their best.

I grew up in California.  I had a volleyball coach in high school that tried to use a stick approach to motivate us as a team to play better.  We were a young team and not very good at volleyball yet.  When we messed up in practice, he would have us run sprints.  That was the stick.  You make a mistake, you run.  During a game he started to threaten us, if we didn’t play better, or if we lost we could expect more sprints.  His threats didn’t really help us play better.  If anything we made more mistakes as we were already tired from all the running we did in practice the day before.  We were afraid of running more sprints if we lost and that caused us to be even more likely to mess up.  We ended up losing the game.  It seems the stick approach often does not have the desired effect.

In Phil Factor’s Confessions of an IT Manager there is an article called “Training Your IT Manager”.  It is a good read and it displays the carrot approach quite nicely.  He talked about his experience watching a Comms team in his company enjoying good interactions with their manager.  The manager might start off being quite rough, but over time he would change into a very friendly good tempered person.  The Comms team members figured out what carrots they could use with their manager to affect his behavior in a positive way.  You can read it for yourself to get the details.  The carrot approach seems to move people in a positive direction, but I am still not sure it brings out their best.

I would guess you have seen similar stick and carrot experiences in your life and in your professional career.  We all need motivation so where does it come from?  I believe that as much as these outside motivators such as stick or carrot can get us moving forward, they never truly get us to do our best.  I believe that for someone to be motivated to do their best it must come from inside.  In essence you have to want to do your best.  You have to do your best because you know you are capable of it.  You have to care and have some pride in your work.  In the end I believe the motivation to do your best comes from you.  You choose to do your best.

I remember when I was 12 or 13 years old.  I had generally been a good student up to that point, but my motivation was starting to wane a bit.  As my grades started to drop my father had a conversation with me.  I told him I was fine getting poor marks and he called my bluff.  He said you won’t be satisfied with doing anything less than your best.  He was right.  When we don’t do our best, we know it, but often try to justify it in one way or another.  In the same way, when we do our best we can have immense satisfaction with the knowledge that we did a job well done.

So what do you think?  What motivates you to do your best?  Or do you have a good stick or carrot story?

Ben Kubicek from SQLServerCentral.com

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

ADVERTISEMENT
DLM

DLM Demo Webinar

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

Featured Contents

 

Using EXCEPT to Determine Row Differences

M. Douglas Bowan II from SQLServerCentral.com

How to use the EXCEPT statement to perform row differences. More »


 

Introduction to SAP HANA on Azure

Additional Articles from Database Journal

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure. More »


 

From the SQLServerCentral Blogs - Deadlock priority

Kenneth Fisher from SQLServerCentral Blogs

Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who... More »


 

From the SQLServerCentral Blogs - Missing Checkbox for Security Filter in Power BI Desktop

Koen Verbeeck from SQLServerCentral Blogs

Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing... More »

Question of the Day

Today's Question (by Steve Jones):

What does sp_table_privileges_ex do?

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: T-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

Tabular Modeling in Microsoft SQL Server Analysis Services

With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and analysis cover all you need to know to create complete BI solutions with these powerful new tools. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I need to change the password on a linked server on a regular basis. I decide to use a T-SQL script to do this. What commands should I use?

Answer: sp_addlinkedsrvlogin

Explanation:

The sp_addlinkedsrvlogin is the procedure to create or update a linked server.

Ref: Changing Linked Server Passwords - http://www.sqlservercentral.com/articles/Linked+Server/151466/

sp_addlinkedsrvlogin - https://msdn.microsoft.com/en-us/library/ms189811.aspx?f=255&MSPPError=-2147217396


» 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 2016 : SQL Server 2016 - Administration

Store Procedure - I have a store Procedure which generate output as one random number I need to execute 100 times how can I...


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

Failed to lock variable - Hi,  I have created a SSIS project. In that I have created 3 dtsx packages (Mastertable.dtsx , FullLoad.dtsx,Fullload1.dtsx) Now when I merge...

Query never completes with CXPACKET waits - Hi, I have a query that runs in under 40 minutes on our test server but never completes on the production...

Is not null 2 columns... - Hello ALL! I have this table  CREATE TABLE .( NOT NULL, NULL, NULL, NOT NULL )


SQL Server 2014 : Administration - SQL Server 2014

Performance improves after reboot - I am an ETL Developer who was asked to look at SQL Server performance problem. We have two DBA's but they're...


SQL Server 2014 : Development - SQL Server 2014

Instead of Update Trigger - Hi ,  I created a instead of update trigger . Something like below. Can this be modified and instead of two updates...

Joining INSERTED and UPDATED tables when PK column changes - Hi SSC, First off, as should probably be as common as to need no explanation, I did not build the system...

Trouble with openxml query - Hello, I have an XML document formed like the attachment.  I have it in a table which ddl is: CREATE...

Delete the duplicate records of table having only one column - Hi all, Kindly suggest  or  share  such query to  me , How we can delete the rows having duplicate records  Condition; Table having...


SQL Server 2012 : SQL 2012 - General

How can I create a table schema based on reading samples from a text file? - I have done this in Hadoop with csvkit to generate a table's schema by reading certain numbers of data from...

Efficient way of writing this stored procedure (Takes too much time to run) - Dear all, We have a query which results all the records which are unpaid as of transaction effective date provided by...

Can anyone recommend a working sample ETL package created with SSIS? - I am looking for a working package, I came across this one from Microsoft's Tutorial, unfortunately just like many observations,...

To insert 50 parameters data into a SQL table, which way is better (fast insertion)? -


SQL Server 2012 : SQL Server 2012 - T-SQL

Non-ANSI equal join - SQL 2012 - I recently found a non-ANSI select statement with equal joins executing against a SQL 2012 (compatibility mode SQL Server 2012(110))...

Use variable in the Identity Seed of create table - There are several tables that were created using a lookup Table to get the Primary Key as opposed to defining...


SQL Server 2008 : SQL Server 2008 - General

How to break down time span in Categories - Basically I have list of the tickets (records) in the db table ticket, and I need to find how long...


SQL Server 2008 : SQL Server 2008 Administration

Using TLS 1.2 - We have SQL Server 2008R2 SP3 and I did the following A: Enabled TLS 1.2 B: Installed SP 3 B: Installed the...


Reporting Services : Reporting Services

SSRS Subscription cannot be created because the credentials used... - I am trying to create my first subscription on my SSRS webpage and I'm getting an error that says "Subscriptions...


Data Warehousing : Integration Services

Getting the first of the month based on yesterday's date - Hi All, I have tried several things and it's not doing quite what I need it to. So I have this expression...


Database Design : Relational Theory

Is having a lookup table that is for multiple entities a common practice? - I've been programming and designing databases of various sorts for several years. And I've been on teams who have designed...

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