SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

How do you deal with disappointment?

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?

Ben Kubicek from SQLServerCentral.com

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

SQL Compare

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

Featured Contents


Auto assign Column Data Types for Flat file Source Import

Daniel Taylor from SQLServerCentral.com

A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again! More »


SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database

Additional Articles from SimpleTalk

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 »


From the SQLServerCentral Blogs - Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions

david.fowler 42596 from SQLServerCentral Blogs

Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling... More »


From the SQLServerCentral Blogs - Defining FKs in CREATE TABLE–#SQLNewBlogger

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »

Question of the Day

Today's Question (by Steve Jones):

I have this code to create and load a table:

    Myval VARCHAR(20)
('A') ,
('123') ,
('123.5') ,
('20180301') ,
('Mar 23, 2000');

I now run this query. How many rows are returned?

FROM dbo.CastTest AS ct

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: TRY_CAST().

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


Expert Scripting and Automation for SQL Server DBAs

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

Yesterday's Question (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

» 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 - Development and T-SQL

Partition error - I'm trying to switch the partition from the staging table to final table and I am receiving this error. "'ALTER TABLE...

SQL Server 2014 : Administration - SQL Server 2014

SQL Overview ( Questions and Answers to SQL Creation) - Creating a relationship in SQL. Suppose I have two tables. One is called Sender's Table and the other is called Recipient's...

Point in time recovery with backups from different sources - Users came to me recently with a corrupted database after server crash. They have a full backup from a 3rd...

SQL Server 2014 : Development - SQL Server 2014

will this SQL trigger recursive - I am new on writing and testing trigger.  I am trying to write a trigger to monitor ta colume wih...

SQL Server 2012 : SQL 2012 - General

Unable to start Availability group role. error code 0x8007139a - Hello, we have a sql server 20012, latest service pack on a 2 node sql cluster with 1 availability group after...

SQL Server 2012 : SQL Server 2012 - T-SQL

Issue with using STUFF - HI, 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...

SQL Server 2008 : SQL Server 2008 - General

Partition Error - I'm trying to switch the partition from the staging table to final table and I am receiving this error. "'ALTER TABLE...

Data Warehousing : Integration Services

copying Files - Hi Experts, I want to copy files from Server1  D: folder A and Folder B to server2 E: folder A and...

This email has been sent to {user_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.
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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com