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 people doing good and reasons to be cheerful

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.

Living Up To Your Word

My well-worn Travelpro carry-on bag was getting a little old, and I've been jealous of the 4 wheel spinner bags as I roll my somewhat heavy bags through the airport. I looked at a few different bags but was interested in trying a hardshell bag. I was trying to decide between Away and Monos and ended up choosing the latter to give a highly rated smaller company a try. They offered a 100-day trial with this verbiage on their product pages: "We offer a 100-day trial on all our luggage. Take some time – make sure you’ve picked the perfect travel partner. If you don’t love it, send it back!"

I ordered the bag, had it arrive a day before a trip, and so I packed the new bag and headed to Chicago. I spent 3 days with the bag, after which I decided it wasn't quite for me. I went to return the bag, only to be told that since I'd "used" it, it wasn't eligible for a return. In looking over the other companies that offer 100-day trials, both Away and TravelPro (and others) will let you use the bag and return it for any reason. Monos somehow thinks giving you 100 days is great marketing, though their restriction is you can only "use" the bag in your house. Something you could do in a couple of hours and without really understanding how the product might work for you.

I feel this is quite deceitful and fraudulent and let them know. I'd also caution you and recommend you not purchase anything from Monos.

Clearly, I didn't read the fine print on the site on other pages, and that's my fault. However, being open and transparent in your business dealings is important if you want to build trust with colleagues and business partners.

A friend told me that this story reminded them of a person they work with, who will word their communications in a way that implies one thing but allows them to avoid meeting an obligation or deadline if they are struggling. This person will often accept a specification and argue later they met the letter of the document even though they failed to work together with others whose code was affected by their work. Over a few months, various teammates avoid working with this person and feel they cannot count on them as a teammate. That's a poor situation, but it's also likely to continue. After all, the team wouldn't disclose there is an issue since they would prefer this person be able to gain employment elsewhere and take their unreliability to another team.

Life can be chaotic, and despite the best of intentions, we may not be able to meet a commitment. I don't expect people to be perfect, and I know that sometimes our plan falls apart. A quote I love is "everyone has a plan until they get punched in the mouth."

We can, however, communicate openly and with the best of intentions. We can let others know when we realize something isn't going well, and we can treat others in an honest, open fashion. We should be the type of person we'd want others to be towards us, or maybe the type of people we hope our children will become.

I don't think Monos does that, and I've certainly learned that I don't want to work with people that operate in that way. I avoid them in my life, and I'd suggest you do the same.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Your First Repo in Azure Data Studio or VS Code

Steve Jones - SSC Editor from SQLServerCentral

Learn how to get started with Git and avoid the command line by using VS Code or Azure Data Studio.

External Article

DevOps 101: Introducing Database DevOps

Additional Articles from Redgate

Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization.

External Article

A MySQL story: Can system engineers solve database issues using system tools?

Additional Articles from SimpleTalk

A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan

From the SQL Server Central Blogs - Resource Hog! What’s my busiest database?

david.fowler 42596 from SQL Undercover

Imagine that we’re seeing very heavy load on our SQL server, be it CPU or IO and we need to find out which database is the driver. I’m sure...

Blog Post

From the SQL Server Central Blogs - Extended Events in AWS RDS

Grant Fritchey from The Scary DBA

For the longest time, we didn’t have one of the most useful tools for monitoring SQL Server behavior, but I just found out that, indeed, you can use Extended...

 

 Question of the Day

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

 

Full Azure SQL Database Backup Frequency

How often does the Azure platform run a full backup of your Azure SQL Database or Managed Instance databases?

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)

Exporting Masked Data

I have some data that is protected by a Dynamic Data Mask. If my user (Joe_User) queries this data, they see this:

Result set with masking

This user tries to execute this code from a command line:

sqlcmd -S Aristotle -U Joe_User -d ddmtest  -Q "select ProductName, UnitPrice from orderdetail where orderid = 4" -o order4.txt

What will they see in the output file?

Answer: The same data that they see in SSMS

Explanation: Dynamic Data Masking is unaffected by how the user queries the data. If they do not have the Unmask permission, they will see the same results in SSMS and SQLCMD and all other client applications. 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 - Development
Calculate field in SQL statement - How we can achive from sql for balance field. I have attacted png file to expain. I will try my best to expain here For first month balance is 4476.55 - 2867.00 = 1609.55 For second month balance is 6468.61  - ( first month of balance which is 1609.55 - trans out which is 2997.49) […]
SQL Server 2016 - Administration
Extract Images from database - Hello! I am exporting images from database to the network path using SSIS - Export Column, I have two fields in the database that have images, this works as expected as long as both the fields have image. But sometimes one of the field might have image or not, how to use export Column in […]
SQL Server 2016 - Development and T-SQL
Converting XML to SQL - My company uses a reporting tool that basically sits on top of SQL Server (and generally makes my life miserable, but that's another post...). Anyway, one thing this software does is provides a GUI for "business users" (non-SQL-savvy users) to create SQL queries. But internally it actually stores those queries as XML, which it then […]
Administration - SQL Server 2014
How is he seeing all the databases - Hi, I have a user that doesn't have access to a database but yet he can see it and query it in SSMS. He is not a member of sysadmin roles or any other roles (there are no custom roles). I disabled his windows auth account and he was then unable to log in - […]
Development - SQL Server 2014
T-SQL Pivot Question - I am familiar with T-SQL's Pivot Operator, I've used it to convert rows of financial data into columns like one would find in a 12 Month Income Statement.  What I've never tried before and am not sure if its even possible is using Pivot when the end results will have 2 (not just 1) set […]
case when with count ms sql - how can I achieve this result below? | id  | id_status | rate    | | --- | ----------- | ------  | | 25 | X               |62.5% | | 15  | Y               |37.5% | having tried this SELECT COUNT(tab.id) AS id, tab.status AS […]
SQL Server 2019 - Administration
Distributed AG - Hello, Please I have question about distributed AG. In normal AG is redo thread per database for sync. Is this same also for Distributed AG (I think yes) or is somehow together in one? I cannot find some good article where is written. Thanks
SQL Server 2019 - Development
simple sp - Hi I have 2 tables in 2 different DBs, I need to have all the rows of  the second table in second DB when a filed(column)is "100" in the first table in the first DB. Should I use Trigger, If Yes, Would you please tell me how? Thank you.
SSMS removed debugging features so I am debugging in VS. Fetch takes like 30 sec - First I can't stress how angry I am with Microsoft for removing debugging from SSMS. Second, I am using Visual Studio to debug now. When I build a cursor, the fetch command takes about 30 seconds to complete. Does anyone know why? Thanks.
Does Server Collation Sequence overide Database Collation Sequence for VS publis - Hi there We have a Server where the collation Sequence has been set to Latin1_General_CS_AS   (Case Sensitivity) In this server , we have a database for which the Colllation Sequence has been set to  Latin1_General_CI_AS  (Case Insensitive) Now Ive been trying to update the database in question from a project in Visual Studio but its […]
Flattening of hierarchy - I was wondering if anyone has any sql code samples where they have had to flatten a hierarchy of nodes without the use of a CTE. For example,  consider an organizational hierarchy tree with the CEO is at the top and all levels of management down to the lowest levels. So, if the structure of […]
SSIS Error when trying to configure Connection Manager in a SQL Server Agent Job - I've exported some SSIS Packages from one environment to another. I created a sql server agent job to run the package and I want to modify the Configuration Parameters to point to the SQL Server that I'm now trying to run this package. I'm getting the following error: The property 'ParameterName' contains invalid characters as […]
Amazon AWS and other cloud vendors
AWS Lambda provisioned concurrency vs EC2 - I am looking to host an intensive computation app on AWS, and can't afford to wait for Lambda cold starts. The app needs to be able to handle up to 300 users without losing in performances, but it won't be having 300 users at all time, so it needs to be able to scale up […]
Powershell
The term 'New-SqlColumnEncryptionSettings' is not recognized as the name of a cm - Created powershell script using SSMS to setup Always Encrypted on a column. Getting this error, "The term 'New-SqlColumnEncryptionSettings' is not recognized as the name of a cmdlet, function, script file, or operable program", when I try to run it. I do have Import-Module SqlServer right before the $encryptionChanges and I have installed the SqlServer Module […]
Integration Services
SSDT installation fails with error message incorrect function(0x8007001) - I have installed SQL Server 2019. Trying to install SSDT 2017. It throws error message   SSDT installation fails with error message incorrect function(0x8007001). please let me know how can resolve this
 

 

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

 

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