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

Daily Coping Tip

Make uninterrupted time for your loved ones

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

You know what we really need? Better interpersonal communication

This editorial was originally published on 8 Sep 2016. It is being republished today as Steve is on holiday.

I might know what you are thinking. You are thinking: what I really need is a beer, a vacation, or a raise. Now that might be true, but I think what we really need is better communication. I would guess that a majority of people reading this are highly technical, smart individuals. I would also guess there are a large number of us that don’t communicate very well with others.

One way in which we don’t communicate very well is in the “how” we express ourselves. Just look in the forum or at some of the comments on the technical articles at SQLServerCentral. Many smart, technical people come off sounding very arrogant, proud, or highbrow. In many cases what is written can be sound advice or a good answer to a question, but the tone can be off-putting and disrepectful. If there was a slight change in how things were stated, it could go a long way towards better communication.

It is almost like we have something to prove. We need everyone to know how smart we are, or at least how smart we think we are. I am not sure I buy into the idea of, “there are no dumb questions,” but we don’t have to shove it in the questioners' faces, either. Where did we lose our patience, our kindness, our empathy?  Perhaps we never had any or were never modeled it by others.

So, what is the answer here?  Perhaps we should look to the golden rule: “Do on to others as you would have them do on to you.”  I can hear some of you saying, “I don’t mind being treated the way I treat others.”  I think that is a lie. You may be doing to others what has been done to you in the past, but I don’t believe anyone should be treated poorly. Don’t get me wrong, I am no different. I have certainly been prideful or boastful or condescending in my communication, but it was wrong, and I regret it. So ,how can we endeavor to communicate better?

How we communicate is our choice. So, let us start by making a choice to communicate differently. An initial reaction can be harsh, but don’t react. Give yourself time to think it through, and choose your words carefully. In conversation, be slow to speak and don’t let your temper or emotions get the better of you. Try not to communicate out of pridefulness. When you are communicating in writing, read over what you have written before you press send or post. If you are not sure how your response might be coming across, then have someone you trust read it and give you their opinion. Care about how you are coming across, instead of just thinking people will deal with it. In the end, if we can do these things, I think our communication will improve.  The benefit will be that, sooner or later you will find that when you treat people with respect and communicate yourself well, you will be treated likewise.

Share a time you really stuck your foot in your mouth and communicated yourself poorly.

bkubicek

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

 
 Featured Contents
Stairway to U-SQL

Stairway to U-SQL Level 2: Breakdown of a U-SQL Statement

Mike McQuillan from SQLServerCentral.com

Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.

PowerShell editors and environments: Part 1

Additional Articles from SimpleTalk

There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.

Create Calendar Table Using Power Query M Language

Additional Articles from MSSQLTips.com

Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.

From the SQL Server Central Blogs - Linux to Windows Authentication

Chad Crawford from Gosql.co.uk

As you are all very well aware Linux to Windows for access to SQL Server can be a slippery slope to doom. So I have decided to create an...

From the SQL Server Central Blogs - 2020 Advent of Code–Day 3

Steve Jones - SSC Editor from The Voice of the DBA

This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 3. Part 1 Day 3 was...

 

 Question of the Day

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

 

Using mode() in R

What does the function, mode(), do in R? As in:
> i
[1] 26
> mode(i)

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)

Adding N/A

I have a query that returns sales totals from a table. My query is:

SELECT 
       ms.saleyear
     , ms.salemonth
     , ms.currMonthSales
     , LAG (ms.currMonthSales, 1) OVER (ORDER BY
                                         ms.saleyear 
                                       , ms.salemonth) AS prevsales
FROM   dbo.MonthSales AS ms
ORDER BY ms.saleyear DESC, ms.salemonth desc;

The currMonthSales value is a numeric value. I want this to display "N/A" when the value is NULL. What should I do to the query?

Answer: Add a COALESCE and a CAST to varchar around the LAG function

Explanation: The COALESCE function will convert this value, but you cannot add a string data type to a column that returns numerics. Instead, you need to cast the output of LAG to string (VARCHAR) and then COALESCE around that. Ref:

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 2017 - Administration
"SQL Server Windows NT - 64 bit" in Task Manager: Memory and CPU high - Hello, It's weird that suddenly I can't access to my sql server database (it says it's being recovered)     and i found that the sql service is using a LOT OF my memory and disk in the task manager Could any one help me please to resolve this ? Thank you
SQL Server 2017 - Development
Concatenate columns with spl characters - Hi, In order to avoid redundant rows, I have to make the following changes to my SQL code :   For the same Quarters,Function, Product and Manager combination we want to update the [GM Scope] and [BL Scope] column as follows : 1) If Quarters,Function, Product and Manager are identical, then GM Scope should show […]
SQL Server 2016 - Administration
object_name (st.objectid) returns NULL. How can I overcome/fix this? - How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in the below query, as well as any other similar queries..). White paper says   "A user can only view the metadata of securables that the user owns or on which the user has been granted permission. This means that metadata-emitting, built-in functions […]
How can I prepare SQL server 2016 certification? - How can I prepare SQL server 2016 certification? Answer Follow · 12 Request plzz guide me.
Development - SQL Server 2014
trigger email alerts in case file is delivered or failed for the job - Hi all, I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail. I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not). Could you help me? Thanks
SQL 2012 - General
List all stored procedures which return datasets - Is there any way to do that? I need to list that kind of procedures in a list on a application form. There is more than 1500 procedures in the DB, most of which are returning result but not dataset. Is it at all possible? Thank you
SQL Server 2019 - Administration
Creating an Extended Event in a SQL Managed Instance - Recently moved our environment to SQL 2019 Managed Instance from SQL 2017 environment.  Trying to re-setup the Extended Event we had running to capture Deadlocks but having issues using an Azure Data Blob for storing the Extended Event file. The initial creation finally worked but when trying to start it get the following error: "The […]
Developer vs Enterprise - Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server (2019 ,2017 & 2014) both in features & performance wise?   TIA
SQL Server 2019 - Development
Newb - SQL Server IIF() Function - I am using the following function: IIf([var1Title] != '', [var1Title] + ' - ' + [var1Topic] + ' - ' + [var1Name], '') AS Item1 In some cases, the value of var1Name is NULL. Oddly, when var1Name is NULL, the value retuned for the entire line is NULL. I am hoping the value returned would […]
Looking for US state geospatial shape data - We have a request to calculate distances across states for a given line between 2 points. Example a line from Minneapolis to Los Angeles, I need to know the total length and what percentage of that length is within each state it crosses. I know how to do it but I need the state outlines. […]
SQL Server 2008 - General
SQL Server maximum Server Memory - I am using SQL Server 2008 R2  Express  edition. I have already set Maximum Server memory to 2Gb. Is there any benefit if I Change it from 2Gb to 3Gb?
Reporting Services
SSRS Export to separate pdfs - Hi everyone, can anyone tell me the process of how to create multiple pdf's from an SSRS report ? Each pdf should refer to one student . Thank you.   I tried doing data driven expressions , but got stuck with the "File name, Path, Render Format, Write mode, File Extension, User name, Password, Use […]
Reporting Services 2008/R2 Administration
how to configure Database Mirroring in SQL Server 2008 - sorry to bother all! could you please tell me the following concerns about database mirroring in SQL server 2008 ? thanks! how to configure the database mirroring for SQL Server 2008 without witness server under not windows domain environment? how to configure the database mirroring for SQL Server 2008 without witness server under windows domain […]
Integration Services
Missing connections not causing a job failure - Hello I have a package that logs using Configure SSIS Logs: Logging It logs to a database (log) I've set up a new connection to the DB and called this log I've created a config file and added log to this: log So, if I create a job that runs […]
SQLServerCentral.com Website Issues
how do you change your display name? - When I edit my profile the display name field is a dropdown. How can I change my display name to something not in the list?
 

 

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

 

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