| A community of more than 1,600,000 database professionals and growing |
| | What do you do when you make a mistake? Today we have a guest editorial as Steve is on vacation. It happens sooner or later. It is just a matter of time before you make a mistake. Hopefully, it is a small one, but it might be a really big mistake with all sorts of repercussions. There are some common reactions when someone is confronted with a mistake they have made, most of them are not good responses. One response is anger. This one doesn’t make a lot of sense, but some people get angry that they are being accused of making a mistake. Surely, that isn’t possible, since they and their code are perfect. Another response can be to blame someone or something else for the problem. It is clearly not their fault, so it must be a co-worker or gremlins or hardware or something else’s fault. Some people respond with denial. There is no mistake, perhaps they have gone blind, so if they can’t see the mistake it must not be there. This is kind of like an ostrich putting its head in the sand and thinking it is hiding. Besides, it is not a mistake; it is a feature. Finally, there is just owning up to your mistake and apologizing for it. This response always seems to be the correct action to take, although it is hard to admit to one’s failings. It is important to own your mistakes when you make them. The quicker you can get over the blame game, the quicker you can move toward a solution. It is interesting how much time and energy can be spent trying to figure who is at fault, when that same time and energy could be spent fixing the problem and moving forward. It seems like some of our ability to accept or deflect blame is inherited by how our parent’s modeled or showed us how they dealt with their mistakes. If we had parents that never admitted to making a mistake or being wrong, then we, their children, often act the same way. Conversely, if we had parent’s that owned their mistakes and apologized to us as children, we might be more likely to do the same. Other people can positively influence us as well. Co-workers or managers that we respect can model proper ways of owning one’s mistakes. Recently, I was working on a project and I needed to move some configuration settings from test into production. I accidentally missed a few settings. It was my fault I should have double checked them. The production staff were upset since everything had been tested and looked correct in the test environment. So when it was wrong in production they were not happy. I owned the mistake and apologized and of course fixed the data in prod. I hope you have people who model owning up to their mistakes in your life. Even if you don’t it is never too late for you to start. You might surprise the people around you, the next time you mess up, admit to being wrong and apologize. Share a mistake you made and how it worked out in the end. Ben Kubicek from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
| | Free whitepaper: Solving the database deployment problem with Database DevOps Find out how Database DevOps helps you gain consistency across your applications and databases, helps your team deliver value quicker, and keeps your data safe. Download the free whitepaper |
|
|
|
| | | Additional Articles from SQLPerformance.com Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns. More » |
| Redgate have just released SQL Census, a prototype tool from the Foundry division that makes auditing SQL Server user access permissions much easier. In this post Ally Parker shows how it works, tells us what's up next in the tool's development development, and explains how you can download it for free. More » |
| Brian Kelley from SQLServerCentral Blogs Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at... More » |
| Dharmendra Keshari from SQLServerCentral Blogs Whenever there is a business requirement to add a new article to an existing publication, you want to know how... More » |
|
|
| | Today's Question (by Steve Jones): I've got this code: WITH myTally(n) AS (SELECT n FROM (values (N' '),(N''),('2^2') ) a(n) ) SELECT top 10 TRY_CONVERT(INT, n) , ISNUMERIC(n) FROM myTally Of the three rows, how many can be converted with TRY_CONVERT to an integer, and return a 1 from IS_NUMERIC()? |
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: T-SQL. 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 | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database Get your copy from Amazon today. | e | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I write this in R: Exclamation <- c('SQL', 'Server', 'is', 'great!') If I want to return "SQL" and "Server", what should I do? Answer: Exclamation[1:2] Explanation: The colon notation will designate a range. The range of elements from the vector that contain "SQL" and "Server" is 1:2. Ref: Indexing - 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 2016 SP1 CU2 - sudden and unexplained shutdowns - Hi there, Anyone had problems with unplanned instance shut-downs on SQL 2016 SP1 CU2? We patched our Data Warehouse to CU2 in... Upgraded to sql 2016 but I am still able to query and create tables with "text" data types. - I thought the text data type was deprecated in sql 2016? Anybody know why this occurs? Successful jobs got failure notifications - I've got some very puzzling job failure notifications for scheduled jobs that actually ran successfully. These jobs have been running... Inner/Outer Join - I want to select all the columns from tblA and two columns from tblB: select A.field1, A.field2, A.field, B.Cost, B.totalcost from... BULK INSERT with format file problems - Hi all Could anyone shed any light on the problem I have using BULK INSERT please? It's not something I have... Convert Rows to Columns - Hello: I have this query: SELECT DISTINCT F.DocumentID, F., F.LatestRevisionNo, V.ValueText, V.VariableID FROM ACME.dbo.Documents F INNER JOIN (SELECT DocumentID, VariableID, ValueText,... Drop specific table - I have given user permission to execute a Stored procedure but that stored procedure drops a specific table and recreates... Sorting to keep people and secretaries together - CREATE TABLE #tblExperts ( ExpertID int, Expert varchar(50) ) GO Error : Connection failure. SQL Native Client is not installed correctly. To correct this, run SQL Server Setup. - Hi I am running Sql scripts through jenkins job. The jenkins job contains sql scripts like 1.Sql1 2.Sql2 3.Sql3 4.Sql4 5.Sql5 ..................................................... n.Sqln Three Database Permission related questions - We are running SQL Server 2012 EE SP3 on Windows Server 2008 R2 Enterprise. I have the following three permission... Trigger for Auditing - Probably been asked before but if I want to create a trigger for DML auditing on a particualr table. Will FOR... Long running insert - Hi Guys I have the following query which was taking a long time to complete 30 minutes or so. After creating... SQLServerAgent Error 22022 - I have a sql agent job that runs every 5 minutes. It executes a stored proc that only takes a... How to find the root cause of database growth – DATA FILE ? - Hi All , Help with query - I need all combinations (not permutations) of the keywords and their synonyms. I'm having trouble getting groups of words substituting... task => generate script with tool sqlCmd - Hello all, i would like to know if it's possible to generate a script (create schema and datas) with the command... why cant we take regular full backup on secondary replica? - Good Morning Experts, In Alwayson Availability Groups, why cant we take regular full backup on secondary replica? Create Multiple SSRS Subscriptions for a Parameterised SSRS Report - Programmatically / Dynamically / Quickly - Hi We have 470 subscriptions in total, of which 224 are for the same parameterised ssrs report but pass different parameter... YTD in matrix in SSRS - I need some expression to calculate the YTD highlighted in yellow. its calculating the difference between dec of previous year and... view definition from sys.sql_modules -- How does SSMS know how to format it? - I am building a mini-app that will give some power users the ability to browse tables and views in selected... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|