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

Daily Coping Tip

Look for a positive spin on a difficult situation

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.

A Culture That Allows Mistakes

Building a culture that promotes teamwork, efficiency, retention, and other positive attributes can be challenging. While many organizations want accountability and responsibility, it is easy for managers to tip over into a blame-and-chastise pattern. When someone makes a mistake and a deadline is missed or a client gets upset, how do you respond?

I saw an article that gives some examples from the cybersecurity world about how to build a culture that allows mistakes and forgives them. We all make mistakes, and we should strive to correct them while working to avoid repeating the same mistake. But we will make mistakes again in the future, so how do we deal with them?

One of the challenges with building a strong culture that is productive is with management. Far too many people react poorly when things go wrong. I find this is a similar challenge to parenting, where we often struggle to let go of control and accept that mistakes will occur. We can also worry that we will be blamed for others' mistakes and want to push our employees or children to avoid mistakes. Often our reactions are more fear-based, for ourselves or even for others' safety. However, we can't completely avoid things going wrong. It's never worked for me, either at work or at home.

There are plenty of articles on creating blameless cultures (one, two, and searches), most of which give reasoning why this works better and hints on what you can do. For many of us, these might feel like a dream we cannot chase. With some managers, the idea of even broaching the topic might be too scary. In those situations, I might try discussing the ideas with peers and perhaps implementing ideas with them, rather than trying to convince management.

Ultimately culture requires support from those in charge. Management has to actually believe in a culture that tolerates and accepts mistakes, while still striving to reduce their occurrence. Everyone deserves to make mistakes and recover from them. We'd like to prevent repeat mistakes, but those will happen. My goal is to work to be better over time and expect others to do the same. While I might need to move someone to a new job or even let them go, it wouldn't be because of making a few mistakes. It would be because of constant mistakes without making an effort to change their behavior and be better.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

PerfMon: Using SQL Server Performance Counters

Br. Kenneth Igiri from SQLServerCentral

Learn how you can use Windows Performance Monitor and the PAL to gather metrics from your SQL Server instances.

Technical Article

Columnstore Indexes are Finally Sorted in SQL Server 2022

Steve Jones - SSC Editor from SQLServerCentral

There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.

External Article

How to troubleshoot and fix PostgreSQL performance issues

Additional Articles from SimpleTalk

PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.

Blog Post

From the SQL Server Central Blogs - #PowershellBasics: Expanding the column width to avoid truncation

Kenneth.Fisher from SQLStudies

I was recently asked to get a list of all of the services running on one of the boxes we ... Continue reading

Blog Post

From the SQL Server Central Blogs - Power BI as a enterprise data warehouse solution?

James Serra from James Serra's Blog

With Power BI continuing to get many great new features, including the latest in Datamarts (see my blog Power BI Datamarts), I’m starting to hear customers ask “Can I...

 

 Question of the Day

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

 

Restoring a Certificate

I use the BACKUP CERTIFICATE command to back up a certificate from my SQL Server 2019 instance to a file. I want to restore this on another instance. What command do I use?

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)

Helping Developers Set Up a Sandbox

I have created a new database on a development server and added the user, JoeUser, as a user in this database. This user has no rights other than to connect to the database.

I then execute this code:

CREATE SCHEMA Dev
GO
GRANT CONTROL ON SCHEMA::Dev TO JoeUser

What happens when JoeUser connects and runs this code:

CREATE TABLE Dev.MyTable (myid INT)

Answer: JoeUser gets an error that they cannot create tables.

Explanation: You can grant CONTROL on a schema to a user, but this does not give them the right to create tables. You must explicitly grant this right. 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
SSIS Proxy/Credential/Login question - I need a quick refresher on how the Proxy stuff hangs together. I know I created a Credential mapped to an AD account which has permissions to any file system resource I need to access in my packages. I know I then create a Proxy mapped to that Credential and grant the Proxy access to […]
Timeout - System exception.Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Source: .Net SqlClient Data Provider. Application team received the error. How can you troubleshoot? No information in error log or event log. We have default enabled but didn’t find any useful information from default […]
Database backup sequence - Hi All, How the SQL server backup will work with scheduled job? What is the sequence it follows? What is the criteria it choose that it need to take this DB backup first, second .. like that? Is it possible before it complete the backup of the one database it will start another database backup?
SQL Server 2016 - Administration
Secondary database stuck in Not Synchronizing state - Hello experts, I am trying to restore a database that is part of an Always On availability group. As usual, I started by removing the database in question from its availability group. One secondary database properly went into the Restoring... state and I was able to delete it. For some reason, however, this time around […]
SQL Server 2016 - Development and T-SQL
Help with update on merge statement - Hello everyone, Needed to help with a merge statement.  So based on what I've read about merge statements the syntax on this should be correct, but it's not.   So my statement is below: merge dbo.qsr_store store using dbo.qsr_store_staging staging on store.id = staging.id and store.brand_code = staging.brand_code when matched then update set store.golive_date = staging.golive_date, […]
Converting SSIS packages from SSIS catalog to File system in Job - Hello, I need some advise on how to convert SQL agent jobs run a SSIS package( SQL agent job has source as "SSIS catalog" and has a SSIS package as destination which is under path example.. SSISDB - Catalog -->Project and where you select specific package) Now, I want to change the SQL agent job […]
Development - SQL Server 2014
Please help to get, Alphabet with underscore i.e special charecter - EMA_20210526T211254_0000_MRNMM0000001240_PMS110460PAT000001287_PID15235307_OR_Driver_Licensefrom.pdf In the above string, i would like to get as below like alphabet and '_', i tried  to use the function fn_GetAlphabetsOnly but getting only alphabet. EMA_MRNMM_PMS_PID_OR_Driver_Licensefrom
SQL Server 2019 - Administration
query that will return the information of every table in a database - Hi, I'm seeking for a query that will return the information listed below for every table in a database. Any suggestions please. Thank you.    
SQL Server 2019 - Development
How to setup Linked Server from SQL Server Express 2019 to Sage Line 50 - Hi there We have a Sage Line 50 Reports application located on one of our servers. This has been setup on our server as ODBC System DSN (Screenshots attached) Now Im trying to set up a linked server from this SageLine50 to SQL Server Express 2019 using the following programatically: EXEC sp_addlinkedserver @server='SageLine50Reports', @provider='SQLNCLI', @datasrc='ChrisSQL,1433', […]
Count of word inside cell - Hello all, I am trying to find a query that bring me the count of the exactly word name: PageDefinition like on the example. Thanks a lot all and best regards, Gilad
SSIS Web Service task SSL errors - I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great in any browser. Via the Web Service SSIS task, I get an error when running the package: Target Server 2016: --1. Connection manager "HTTP Connection Manager 1": SSL certificate response obtained from the server was not valid. Cannot process the request. […]
Amazon AWS and other cloud vendors
How to debug a StackSet? - We have a StackSet in our organisation that deploys config-central-logging. I wanted to change the regions this is deployed to and make sure it is deployed to new accounts. Any change I make to the StackSet is greeted with an error. Removing stacks fails, sometimes it says the OU is not part of the stackset […]
General Cloud Computing Questions
Please recommend me a cloud service based on description - I am working on an angular project and created a docker image for that.till now i only worked on the development side and never on full deployment side but I am willing to learn the process,can you please recommend me a cloud service where my docker container can be deployed with less/no fee charges as […]
General
SQL MAX of multiple columns? - How would you return 1 value per row of the max of several columns: TableName [Number, Date1, Date2, Date3, Cost] I need to return something like this: [Number, Most_Recent_Date, Cost] Can anyone help me out with this. Thanks in advance
Powershell
create file name with timezone CEST - Is there any easy script that will take current datetime and convert to CEST and account for DST also? I want to use that in my file name to help identify when process was ran. Thanks
 

 

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

 

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