SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Does the Tone matter?

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

Recently, during a project meeting, our Project Manager shushed a team member to stop him proceeding further with his views. The way the Project Manager did that was quite rude, and though it seemed weird to everyone, the meeting continued. Later on, I found that out that the team member did feel agitated about this incident and was reluctant to carry on working under this manager.

During a few other incidents, I felt that the Project Manager’s way of managing people was a bit abrupt and to some extent, not very courteous. Though, he is a bright, smart, experienced and quite socialable, when it comes to managing teams or people, he is quite unpredictable and very blunt.

On the other hand, it may just be us few who are a little more sensitive than others. It may be that the PM is just like any other Project Manager, getting things done in a way that is standard to meet the tight deadlines. Having lived and worked in UK, we may have gotten used to a way of communication, which is usually very courteous and polite.

Whatever the case, that particular team member and a few others did leave the project and the company. It may have been for other reasons as well, but it did make me think if I would have also done the same in a similar situation.

What would be your take on that ? Does the tone of communication matters to you that much that it affects your work in some way?

Nitin Bhojwani from SQLServerCentral.com

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

ADVERTISEMENT
GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

Featured Contents

 

Covering Indexes: Not Just for SELECT but also for UPDATE statements

Mike Byrd from SQLServerCentral.com

Covering indexes help UPDATE performance also More »


 

Pseudonymizing your data with SQL Data Generator

SQL Data Generator was, as its name suggests, intended to generate the data for databases, as required for testing, development work and training. However, it is perfectly at home with using the original data as the default source of the new data, and then substituting in fake data for any column that you want to mask - here's how. More »


 

Calculating Employee Attrition Rate with DAX – Part 1

Additional Articles from MSSQLTips.com

In many businesses, the HR department needs reports on the employee attrition. This is the number of people that leave the company (depending on the reason they leave; the terminology can also be dismissals or turnover). Suppose you have a table with your employee data, where you also store a possible termination date. How do you calculate the number of people who have left the company using the DAX query language? More »


 

From the SQLServerCentral Blogs - Change SSAS Tabular Data Source using TOM

Koen Verbeeck from SQLServerCentral Blogs

We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server... More »


 

From the SQLServerCentral Blogs - Power BI Monthly Digest – May 2018

Devin Knight from SQLServerCentral Blogs

This month I continued a new series with Manuel Quintana [Blog | Twitter] to help you stay on top of the... More »

Question of the Day

Today's Question (by Steve Jones):

Which object is used in SMO to perform the scripting function for SQL Server database objects?

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: SMO.

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

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 this code to create and load a table:

CREATE TABLE CastTest
(
    Myval VARCHAR(20)
);
GO
INSERT CastTest
(
    Myval
)
VALUES
('A') ,
('123') ,
('123.5') ,
('20180301') ,
('Mar 23, 2000');
GO

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

SELECT CAST(Myval AS INT)
FROM dbo.CastTest AS ct
WHERE TRY_CAST(ct.Myval AS INT) IS NOT NULL;

Answer: 2

Explanation:

In this case, there are two rows that can be converted to integers. These are the rows with 123 and 20180301. The rest would return NULL from TRY_CAST and aren't returned.

Ref: TRY_CAST - 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 2017 : SQL Server 2017 - Administration

Deprecation and compatibility level - Hi,   I analyzing possibility of database migration from SQL 2012 to 2017 ,  using CREATE EVENT SESSION ON SERVER and  ADD EVENT sqlserver.deprecation_announcement  ADD...


SQL Server 2017 : SQL Server 2017 - Development

Performance Question - Hi there,  I have a performance question here: how can I rewrite below highlighted area?  I am getting Lazy spool in execuation...


SQL Server 2016 : SQL Server 2016 - Administration

Registered servers - Hello - If someone creates the registered servers, can I use them to save time not to again add them one...

Table Compression Discrepancy - Evening Guys, I've enabled page compression for a few tables in the database, this seems to work fine. But when I...


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

Storing multiple variations of the same data? - Can anyone weigh in on why you would want to store multiple variations of the same data?  In all of...

Openrowset update issue - Hi  I have a problem using OPENROWSET to move data from Server A to Server B correctly. I have the following requirement...

Determine where a value falls between ranges to assign points - I need some suggestions on the best method to assign points based on how a store performed on different metrics. I have 7...


SQL Server 2014 : Administration - SQL Server 2014

Error: 18456, Severity: 14, State: 73. - Hey guys,  I am getting this in my errorlog,   I am unable to find the cause, does any one know what...

Server Name confusion - We had one of our database server which was moved to AWS couple of months ago. Old server was prod5...

Unable to remotely Connect to SQL 2014 Databases. - Just built Windows 2012 R2 two Node Cluster SQL 2012 Enterprise I have three databases added 1, Veeam Enterprise Manager...

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

SQL Query Help - Separate Column - Hi All: Need help with SQL Query. I have a column named Participants with Names and email addresses in one single column....


SQL Server 2012 : SQL 2012 - General

Log shipping and database backups - Hi all We've got a few databases that we want to start log-shipping from. Normally, we'd use replication but the 3rd-party software...


SQL Server 2012 : SQL Server 2012 - T-SQL

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...

How to identify the row in which any of the column was updated? - Hi, I am working on a scenario where I need to identify the rows in a table in which any of...

Performing Join on SHA2_256 Hashed Column - Hi All,  Having some issues with a hashing and matching based on a file. We have a hashed column in a table...


SQL Server 2008 : SQL Server 2008 - General

Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ? - Hi All, I have an application where we will be showing the invoice and Plan backup reports for each recipient in...

Frustrating Ola Hallengren log file (ldf) backup issue - This is one of those - the DBA quit, so let's have the BI developer fix it situations. I'm the BI...


Data Warehousing : Integration Services

SSIS Data Conversion Failed for Flat file to SQL table ? - Hello  I  have around 40 flat files to move to my sql  database   My destination table look like this  while importing from flat...


Data Warehousing : PowerPivot

always include value in filter? - I have several fact tables and a Schools dimension table. IS there a way to always include a specific school...

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