Today we have a guest editorial as Steve is out of the office.
Disappointment is hard. People can and sometimes do disappoint us. The way events or projects turn out can disappoint us. It would be nice if people never let us down, but they do from time to time. It would be great if projects always went the way we thought they should. Unfortunately, disappointing things happen so, how do we deal with them?
Clearly, when we experience disappointment in our lives, there are many possible reactions we can have to it. We can feel, pain, sorrow, hurt, etc. Some of us, being more introverted, when we experience these emotions withdraw even further into ourselves. Although, this is an understandable reaction, it is not necessarily a mature one.
So after the initial reaction has faded, it is time to be an adult. It is time to express ourselves, and properly communicate our feelings in a respectful way. We don’t need to give people the silent treatment or take a 2-hour lunch as we sulk. When has acting that way ever helped a situation?
Recently, a new project came up at work. An old printing engine needed to be re-written and a few of us got together to discuss how it might be re-architected and designed to better meet our current needs. One co-worker felt a bit left out. This co-worker is currently the one who does a lot of the support for the current printing engine. This person hasn’t shown any initiative with the old printing engine as far as re-writing it or trying to fix some of the issues we are experiencing with it. Anyway, this co-worker was feeling disappointed that they were being left out of the process. Instead of communicating this, this person got quiet, was gone all afternoon and resolved themselves that they would just be left out of the process.
Again, this co-worker’s response makes sense. Yet, in general, behaving this way is not going to get you what you want. Still, it got me thinking. How often have I let my emotions get the better of me? How often have I acted more like a child when I didn’t get my way or I when I was treated poorly?
In the end, we did pull the co-worker in to participate in the process and everything is working out. Still, we would have thought much better of our co-worker if they just would have come and said, “I want a more active role in this process.” Adults should properly communicate themselves with others, not give in to childish tendencies.
So how about you? Share a time you let emotions get the best of you. What would you do differently if you have a chance to do it over again?
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 migrations inside Visual Studio
Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free
The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships. More »
Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I have an Azure SQL Database and want to run Extended Events on this database. My intention is to persist the data in an Event File target. How can I do this?
Answer: Configure a container in Azure Storage and then assign the Azure storage container as your event file target.
You can create a container in Azure Storage and then use a Database Scoped Credential to assign rights. you can then configure your Event File target to use your container.
Ref: Event File target code for extended events in SQL Database - click here
Issue with using STUFF
I am executing below query in query window then it works fine and get the result for Dept field into...
Hierarchical query match with multiple tables
- I have this business_table
ref_ID name parent_id
ABC-0001 Amb NULL
PQR-899 boss NULL
tgv-632 pick NULL
yyy-888 xyz NULL
kkk-456 ued NULL
I want to update...
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.