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

Daily Coping Tip

Tell someone about an event in your life that was really meaningful

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.

Sabotage at Work

I caught a link to the OSS's Simple Sabotage Field Manual from David Perell. It was written as a guide to destroying organizations during WWII to be distributed to citizens of enemy states. The OSS later became the CIA, but their goal was to find ways to disrupt the governments of enemy states.

What was surprising to me was that some of the advice seemed to still be in use in places I worked in my career. Such as the advice for managers: " To lower morale and production, be pleasant to inefficient workers; give them undeserved promotions. Discriminate against efficient workers; complain unjustly about their work."

This might seem to be human behavior, and it is, but it also destroys organizations. Too many people in authority don't seem to do a good job of evaluating those that perform well and drive our software forward. While I do think this is subjective, often the group view from workers and the managerial view of who is efficient can be quite different. Being transparent and open with expectations and evaluations can help here.

Working in committees and large groups is all too common, at least in US organizations. We hold meetings and have discussions with large groups instead of making decisions. I do agree with getting opinions from a large group, but discussions should be relatively short and then decisions made. We don't want a dictatorship nor a large democracy of debate, but something in between.

Maybe one of the more interesting ideas is the work slowly. I don't know of many workers that want to work slow. Some do, and sometimes we all struggle to get things done, but so often management doesn't want to invest in tools for workers. Tools can make a job much easier, and much more efficient. Part of DevOps is learning to use tools and become better. Or fabricate your own tools, something we can do in software easily. Too many managers don't want to budget time or money or build or buy tools.

It's easy to self sabotage ourselves, and too often, it's easy for managers to destroy an organization from within. This might be an interesting manual to review in a meeting and debate if our rules, protocols, and decisions are helping or hurting our organization. Unfortunately, too many managers aren't willing to perform that self-evaluation.

Steve Jones - SSC Editor

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

 
 Featured Contents

Installing SQL Server 2019 using the Azure Cloud Shell

ramakant from SQLServerCentral

Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. Platform File System Red Hat Enterprise Linux 7.3, 7.4, 7.5, 7.6, or 8 Server XFS […]

The State of Database Monitoring in 2020

Additional Articles from Redgate

The 2020 State of Database Monitoring report is no...

Text Mining and Sentiment Analysis: Analysis with R

Additional Articles from SQLServerCentral

In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating a word cloud, word associations, sentiment scores, and emotion classification.

From the SQL Server Central Blogs - Can We Get Row Counts After Execution?

Grant Fritchey from The Scary DBA

The general idea for this question came from dba.stackexchange.com: could we, and if we can, how, get row counts after execution. I was intrigued with the idea, so I...

From the SQL Server Central Blogs - SQL Prompt Fixes Missing Begin End in Procs

Steve Jones - SSC Editor from The Voice of the DBA

SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...

 

 Question of the Day

Today's question (by Greg Larsen):

 

Estimate a count

Which of these is an expression that can be used in SQL Server 2019 when performance is more important than accuracy to get a unique count?

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)

The Countrows Result

I have two tables that are related in a Power BI model as a parent and child. For ID 1, there are 3 rows in the child table with the matching key column value. For ID 6, there are no rows in the child table.

If I define a column in the parent table like this:

SOME ROWS = COUNTROWS(RELATEDTABLE(OrderLine))

where OrderLine is the child table, what value is returned for ID 6?

Answer: a blank value

Explanation: The result of COUNTROWS when there are no rows is a blank. If rows are filtered out, 0 is returned. Related table results Ref: COUNTROWS - https://docs.microsoft.com/en-us/dax/countrows-function-dax

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
sys.dm_db_file_space_usage - I've been reading up on sys.dm_db_file_space_usage and see a lot of examples of how to convert the results to MB / GB.   However, none these methods work for me... or if they do, I don't understand them. When I run use tempdb; go select * from sys.dm_db_file_space_usage; For the total_page_count I get 85184.00. That's […]
SQL Server 2017 - Development
Global Temporary Tables and dynamic sql string - I have a script: if OBJECT_ID('temptable') is not null drop table temptable go if OBJECT_ID('tempdb.dbo.##t') is not null drop table ##t go create table temptable(EmployeeID varchar(50), ProjectID varchar(50)) go declare @s varchar(4000) set @s = 'SELECT top 10 T.EmployeeID into ##t FROM temptable T' exec (@s) set @s = ' drop table ##t SELECT top […]
HTML Mail with more than one line in Resultset - Hello all, i would like to send a html Mail with sql server. But i can´t solve it by more than one line. Resultset: Select car,model,engine from cars Honda, Civic, 1.6 VW, Golf, 1.5 Dodge, Viper, 8.4 In my Mail i would receive a html table with:[…]
CarModelEngine
Honda
SSIS Export Flat File as Fixed Width - Hi Forum, I have a table that uses the script below to create fields with Spaces at the start of the field value. The way this works is if,for example, a field length is set at 12 characters and the value for the field is 8 characters long, it should have 4 spaces at the […]
SQL Server 2016 - Administration
Index Maintenance - I need a query to  find the unused indexes and missing indexes on all tables in a database.also for creation of index recommendations on tables.  
SQL Server 2019 - Administration
WSFC option missing in Availability Group Wizard - Hi, I have installed SQLServer 2019, and Windows Server Failover Cluster feature. I want to create a AO Availability Group. I start the create wizard, and in the "Specify availability group options" page the WSFC cluster type is missing. I only can choose EXTERNAL or NONE. Is there something I am forgetting? From what i […]
Using MS SQL Server Security mechanisms in a three-tier architecture - I am trying to understand how I can use the db server authentication - authorization mechanisms and user related tables, but I cant find any resource simple enough to grasp the whole concept. What I am trying to do is to not have my own tables for users, roles etc. but use the platform's syslogins, […]
SQL Server 2019 - Development
Nested Json Parsing issue - Greetings, I am having issues parsing the following Json string using openjson. I am having problems getting at the piece under custom fields. If I omit that, I can bring in the rest of the fields. Looking at other posts, it looks like it requires multiple cross apply statements but I haven't got the syntax […]
Reporting Services
SSRS 2014 - Page Break to follow a sub-report? - Hi everyone, Really really need help on this one.   You would think that page breaks would be easy to do, but alas, SSRS is not doing what I told it to do.   Of course, I am assuming that I simply haven't told it the exactly correct way to go about it.   I have a report […]
SSRS 2016
SSRS Branding - Different Font Colour for Primary and Secondary Bar? - I have followed a few different guides for branding SSRS and these all work but it seems impossible to have the text in the first bar (top-right showing Settings, Download and Help on same line as the logo) to be different to the bar below this (showing Favorites and Browse). The logo is dark blue […]
Analysis Services
AS Tabular and Sample Data in VS - Hello all, I really need your help – I want to use the sample data in an Analysis Services Project in the Visual Studio, but the sample Data from the Sample Partitions will not be displayed. The actual situation: I use a Tabular AS Server 2016 and 2019 Visual Studio 2019 with the latest Data […]
Anything that is NOT about SQL!
Replacing Remote Desktop Connection Manager - So RDCM is no longer being supported by Microsoft, but it was such a useful tool. I'm looking for alternatives that have the ability to group server connections and save those names so I don't have to type them in every time. Any thoughts on a good replacement for it?
COVID-19 Pandemic
Daily Coping 26 May 2020 - Today’s tip is to share an inspiring quote with others to give them a boost. My thoughts: https://voiceofthedba.com/2020/05/26/daily-coping-26-may-2020/
Daily Coping 25 May 2020 - Today’s tip is to share photos of 2 things you find meaningful or memorable. My thoughts: http://voiceofthedba.com/2020/05/25/daily-coping-25-may-2020/
Article Discussions by Author
Microsoft SQL Server Utilities and Tools - Comments posted to this topic are about the item Microsoft SQL Server Utilities and Tools
 

 

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

 

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