This editorial was originally published on Mar 21, 2014. It is being re-run as Steve is on vacation.
We all have them. As DBAs, there could be many bad days in our career. We poke fun at one of them with our first humorous DBA Team story this year. Hopefully you enjoy that one and smile. I know I got a kick out of reading it when got the first draft.
However that's not a really bad day for me. I've had some bad days at work involving corruption, missing backups, hardware failures, viruses, and more. Typically they involve fewer car crashes and political games than the DBA Team deals with, but they're almost as stressful and more than a few have stretched well into the night.
This week, I'd like to commiserate with you. I'd like to hear about the hard stories that you can now look back on with a smile (or grimace), having managed to move beyond the situation.
What's been a really bad day in your DBA career?
Or perhaps you've got a bad development story, an administrator story or something else. What was a time when you thought your career might be over, or you might lose your job? When did you feel a high level of stress over a situation that you thought might overwhelm you? Was there a time you might leave this industry?
I'm not looking to bring up bad memories, and please remember to be professional with your stories. However I've found writing things down can be cathartic. Perhaps you've held onto some anxiety for years, or fear about a repeat. Perhaps a little sharing, and empathy from the community, will help you feel better about the situation.
As always, if you'd like to share anonymously, feel free to send a note to sjones at this domain and I'll post your story without your name.
Write, format, analyze, and refactor SQL fast with SQL Prompt
Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial
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: count().
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Yesterday's Question of the Day
(by Steve Jones):
I've got a developer that is working on a query that contains a view. The developer tries to get the actual execution plan for the query, but receives a permission error. What permission needs to be granted to the JoeDev user in the development database for the ActiveCustomer view to allow him to view the execution plan?
Answer: GRANT VIEW SHOWPLAN to JoeDev
The permission to view plans is GRANT SHOWPLAN to <user>.
Ref: Granting, Denying, and Revoking the SHOWPLAN Permission - click here
Self Join Question
- I've got a table with the following fields in it:
Sample data looks like :
08-40089445, 1, '','BNT',10/17/17
08-40089445, 2, 'BNT','VFD',1/18/18
- I have been trying to find out the best way to design a Normalized table for
Format of result
- Hi all, im trying to do something, but have no idea how to acief this.
Here part OF the DATA i'm...
Looking to sort two queries by Date, Time
LTRIM(RIGHT(CONVERT(varchar(6), .,100),7)) AS
--, FORMAT(., 'MM-dd-yyyy') AS
, CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), .,101),'/','-')) AS
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.